Conversation:
Notices
-
It has been a while since I have done anything with #MySQL and #Postgres. I keep forgetting that the package 'mysql' is not the server.
Of course, the Zabbix instructions could be a lot better in this regard. !monitoring
-
for example, need to create a user before this grant command:
# mysql -uroot -p
password
mysql> create database zabbix character set utf8 collate utf8_bin;
mysql> grant all privileges on zabbix.* to zabbix@localhost identified by 'password';
-
@musicman That GRANT command should also create the user, so you do not need to "CREATE USER ...".
-
the error specifically says you cannot use GRANT to create user. Maybe you could in earlier versions of MySQL? You can't in MySQL 8.whateverIhave
-
@musicman With that, they broke 20 years of tutorials and courses.
-
my suspicion, after reading https://stackoverflow.com/questions/26573940/why-cant-create-a-new-user-in-mysql is that zabbix had me import the user in an earlier step so that the user existed.
Which gets me back to the original statement...that the zabbix instructions could use some work
The weird thing is that the CREATE statement worked. This may be because of the hostname, but I got it working, so I am no longer worried about it.
Douglas A. Whitfield
LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}
All Hacker Poesy content and data are available under the