1,My.cnf中用户名密码无效
在azure云上面,使用Zabbix监控mysql中,发现在/usr/local/mysql/my.cnf里面设置的默认用户名密码无效,出不来数据,而且在zabbix服务器上,使用zabbix_get也报错failed,如下
[root@zabbix_serv_121_12 ~]#/usr/local/zabbix/bin/zabbix_get -s 192.168.13.13 -p10050 -kmysql.status[Uptime]
/usr/local/mysql/bin/mysqladmin: connect toserver at 'localhost' failed
error: 'Access denied for user'adminuser'@'localhost' (using password: NO)'
[root@zabbix_serv_121_12 ~]#
2,尝试[client]无效
在/usr/local/mysql/my.cnf里面添加所有客户端都可以使用的[client]选项卡配额好mysql的用户名密码
[root@azure_test_dbm2_3_13 mysql]# vim.my.cnf
[client]
MYSQL_USER=zabbix
password=ys_test0418
再去zabbix服务器上,使用get来测试下,
[root@zabbix_serv_121_12 ~]#
[root@zabbix_serv_121_12 ~]#/usr/local/zabbix/bin/zabbix_get -s 192.168.13.13 -p10050 -kmysql.status[Uptime]
/usr/local/mysql/bin/mysqladmin: connect toserver at 'l27.0.0.1' failed
error: 'Unknown MySQL server host 'l27.0.0.1'(0)'
Check that mysqld is running on l27.0.0.1and that the port is 3317.
You can check this by doing &