centos7安装Zabbix4.4,遇到ERROR 1044 (42000): Access denied for user 'zabbix'@'%' to database 'zabbix'
按照之前代码安装的时候遇到权限问题
[root@localhost ~]# zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -uzabbix -p zabbix
Enter password:
ERROR 1044 (42000): Access denied for user 'zabbix'@'%' to database 'zabbix'
查看权限如下
[root@localhost ~]# mysql -uroot -p
Enter password:
mysql> SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
+---------------------------------------+
| query |
+---------------------------------------+
| User: 'zabbix'@'%'; |
| User: 'mysql.infoschema'@'localhost'; |
| User: 'mysql.session'@'localhost'; |
| User: 'mysql.sys'@'localhost'; |
| User: 'root'@'localhost'; |
| User: 'zabbix'@'zabbix'; |
+---------------------------------------+
6 rows in set (0.00 sec)
解决方法如下:
mysql> grant all privileges on zabbix.* to 'zabbix'@'%' ;