国外那些网站是做菠菜的,wordpress媒体库,北京app手机网站制作,前端开发招聘信息zabbix3.0 监控mysql服务免用户名密码登录的问题故障处理详细过程1#xff0c;My.cnf中用户名密码无效在azure云上面#xff0c;使用Zabbix监控mysql中#xff0c;发现在/usr/local/mysql/my.cnf里面设置的默认用户名密码无效#xff0c;出不来数据#xff0c;而且在zabbi…zabbix3.0 监控mysql服务免用户名密码登录的问题故障处理详细过程1My.cnf中用户名密码无效在azure云上面使用Zabbix监控mysql中发现在/usr/local/mysql/my.cnf里面设置的默认用户名密码无效出不来数据而且在zabbix服务器上使用zabbix_get也报错failed如下[rootzabbix_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 failederror: Access denied for useradminuserlocalhost (using password: NO)[rootzabbix_serv_121_12 ~]#2尝试[client]无效在/usr/local/mysql/my.cnf里面添加所有客户端都可以使用的[client]选项卡配额好mysql的用户名密码[rootazure_test_dbm2_3_13 mysql]# vim.my.cnf[client]MYSQL_USERzabbixpasswordys_test0418再去zabbix服务器上使用get来测试下[rootzabbix_serv_121_12 ~]#[rootzabbix_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 failederror: 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 telnetl27.0.0.1 3317[rootzabbix_serv_121_12 ~]#本文章来源blog地址http://blog.csdn.net/mchdba/article/details/51344063谢绝转载。3继续尝试mysqladmin本地调试一下Zabbix监控mysql是通过远程调用mysql服务器的本地的mysqladmin组件来获取mysql数据库信息的这样只要在本地mysql服务器调试通过了那么就应ok了。先在本地免密码登录调试通过吧。尝试本地mysqladmin无效[rootazure_test_dbm2_3_13 zabbix]#/usr/local/mysql/bin/mysqladmin -hl27.0.0.1 -uzabbix -pys_test0418 -P3317 -S/usr/local/mysql/mysql.sock extended-status grep -w Com_updateWarning: Using a password on the commandline interface can be insecure.Got error: Unknown MySQL server hostl27.0.0.1 (0)尝试本地mysql无效[rootazure_test_dbm2_3_13 zabbix]#/usr/local/mysql/bin/mysql -hl27.0.0.1 -uzabbix -pys_test0418 -P3317Warning: Using a password on the commandline interface can be insecure.ERROR 2005 (HY000): Unknown MySQL serverhost l27.0.0.1 (0)[rootazure_test_dbm2_3_13 zabbix]# mysql-hl27.0.0.1 -uzabbix -pys_test0418 -P3317Warning: Using a password on the commandline interface can be insecure.ERROR 2005 (HY000): Unknown MySQL server hostl27.0.0.1 (0)[rootazure_test_dbm2_3_13 zabbix]#mysql -uzabbix -pys_test0418 -P3317Warning: Using a password on the commandline interface can be insecure.ERROR 1045 (28000): Access denied for userzabbixlocalhost (using password: YES)[rootazure_test_dbm2_3_13 zabbix]#问题在哪里呢4找到mysql组件识别的my.cnf所在的路径看来默认的/usr/local/mysql/my.cnf里面的配置对于登录来说无效了那么我们需要去看下mysqladmin识别哪些my.cnf以及他们的路径地址[rootazure_test_dbm2_3_13 mysql]#mysqladmin --help……Default options are read from the followingfiles in the given order:/etc/my.cnf /etc/mysql/my.cnf/usr/local/mysql/etc/my.cnf ~/.my.cnf……[rootazure_test_dbm2_3_13 mysql]#再ll下看是否能找到这些配置文件[rootazure_test_dbm2_3_13 mysql]# ll/etc/my.cnfls: cannot access /etc/my.cnf: No such fileor directory[rootazure_test_dbm2_3_13 mysql]# ll/etc/mysql/my.cnfls: cannot access /etc/mysql/my.cnf: Nosuch file or directory[rootazure_test_dbm2_3_13 mysql]# ll/usr/local/mysql/etc/my.cnfls: cannot access/usr/local/mysql/etc/my.cnf: No such file or directory[rootazure_test_dbm2_3_13 mysql]# ll~/.my.cnfls: cannot access /root/.my.cnf: No suchfile or directory[rootazure_test_dbm2_3_13 mysql]# ll/usr/local/mysql/etcls: cannot access /usr/local/mysql/etc: Nosuch file or directory[rootazure_test_dbm2_3_13 mysql]#一个也没用找到原来我的mysql是源码编译的编译路径是在/usr/local/mysql/my.cnf但是mysqladmin不识别了。所以需要安装提示准备一个新的my.cnf吧5准备新的my.cnfOK在mysqladmin识别的my.cnf路径中(/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf )选择一个/usr/local/mysql/etc/my.cnf然后新建并且在里面录制好用户名密码然后调试通过# 在mysql服务器上面准备新的配置文件my.cnf[rootazure_test_dbm2_3_13 mysql]# mkdir /usr/local/mysql/etc[rootazure_test_dbm2_3_13 mysql]#[rootazure_test_dbm2_3_13 mysql]# vim /usr/local/mysql/etc/my.cnf[mysqladmin]userzabbixpasswordys_test0418socket/usr/local/mysql/mysql.sock# 赋予mysql用户访问权限[rootazure_test_dbm2_3_13 mysql]# chown -R mysql.mysql /usr/local/mysql/etc/my.cnf[rootazure_test_dbm2_3_13 mysql]# chmod ux /usr/local/mysql/etc/my.cnf[rootazure_test_dbm2_3_13 mysql]## 重启下因为我发现不重启的话不生效[rootazure_test_dbm2_3_13 mysql]# service mysql restartShutting down MySQL. [ OK ]Starting MySQL.. [ OK ][rootazure_test_dbm2_3_13 mysql]#然后去zabbix服务器上验证可以获取到mysql服务器的数据信息[rootzabbix_test_121_12 ~]# /usr/local/zabbix/bin/zabbix_get -s 192.168.13.13 -p10050 -k mysql.status[Uptime]154408[rootzabbix_test_121_12 ~]#Bty感谢网友木木指点参考文章http://dev.mysql.com/doc/refman/5.6/en/password-security-user.html欢迎大家阅读《zabbix3.0 监控mysql服务免用户名密码登录的有关问题故障处理详细过程_mysql》,跪求各位点评by 搞代码微信 赏一包辣条吧~支付宝 赏一听可乐吧~
