问题:
1,My.cnf中用户名密码无效
使用Zabbix监控mysql中,发现在/usr/local/mysql/my.cnf里面设置的默认用户名密码无效,出不来数据,而且在zabbix服务器上,使用zabbix_get也报错failed,如下
#/usr/local/zabbix/bin/zabbix_get -s 192.168.13.13 -p10050 -k mysql.status[Uptime]
/usr/local/mysql/bin/mysqladmin: connect toserver at 'localhost' failed
error: 'Access denied for user'adminuser'@'localhost' (using password: NO)'
解决方式:
由于是二进制包安装的,默认的配置文件路径在/usr/local/mysql/my.cnf,但是mysqladmin识别的my.cnf路径中(/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf ),并不存在/usr/local/mysql/my.cnf,解决过程选择一个/usr/local/mysql/etc/my.cnf,然后新建并且在里面录制好用户名密码,然后调试通过
# 在mysql服务器上面准备新的配置文件my.cnf
# mkdir /usr/local/mysql/etc
# vim /usr/local/mysql/etc/my.cnf
[mysqladmin]
user=zabbix
password=ys_test0418
socket=/usr/local/mysql/mysql.sock
# 赋予mysql用户访问权限
# chown -R mysql.mysql /usr/local/mysql/etc/my.cnf