Conversation

Notices

1. Douglas A. Whitfield (musicman@nu.federati.net)'s status on Wednesday, 13-May-2020 13:25:37 UTC Douglas A. Whitfield

   • Nagios Unofficial
   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
   • Douglas A. Whitfield (musicman@nu.federati.net)'s status on Wednesday, 13-May-2020 13:36:12 UTC Douglas A. Whitfield

     in reply to
     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';
   • LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} (lnxw48a1@nu.federati.net)'s status on Wednesday, 13-May-2020 15:00:09 UTC LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}

     in reply to
     @musicman That GRANT command should also create the user, so you do not need to "CREATE USER ...".
   • Douglas A. Whitfield (musicman@nu.federati.net)'s status on Wednesday, 13-May-2020 15:24:31 UTC Douglas A. Whitfield

     in reply to

     • LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}
     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
   • LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864} (lnxw48a1@nu.federati.net)'s status on Wednesday, 13-May-2020 15:40:16 UTC LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}

     in reply to
     @musicman With that, they broke 20 years of tutorials and courses.
   • Douglas A. Whitfield (musicman@nu.federati.net)'s status on Wednesday, 13-May-2020 17:12:44 UTC Douglas A. Whitfield

     in reply to

     • LinuxWalt (@lnxw48a1) {3EB165E0-5BB1-45D2-9E7D-93B31821F864}
     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.