zabbix Warning: Using a password on the command line interface can be insecure
来源:互联网 发布:天谕捏脸数据 编辑:程序博客网 时间:2024/06/01 22:10
使用zabbix的默认模板监控MySQL 5.6指标无法出来,后台报错:
3272:20170816:180439.492 error reason for "10.10.18.158:mysql.status[Bytes_sent]" changed: Received value [Warning: Using a password on the command line interface can be insecure.6010237] is not suitable for value type [Numeric (float)]
3272:20170816:180439.492 error reason for "10.10.18.158:mysql.status[Com_begin]" changed: Received value [Warning: Using a password on the command line interface can be insecure.1028] is not suitable for value type [Numeric (float)]
3272:20170816:180439.492 error reason for "10.10.18.158:mysql.status[Com_commit]" changed: Received value [Warning: Using a password on the command line interface can be insecure.1029] is not suitable for value type [Numeric (float)]
3271:20170816:180444.495 error reason for "10.10.18.158:mysql.status[Com_insert]" changed: Received value [Warning: Using a password on the command line interface can be insecure.477] is not suitable for value type [Numeric (float)]
3271:20170816:180444.496 error reason for "10.10.18.158:mysql.status[Com_select]" changed: Received value [Warning: Using a password on the command line interface can be insecure.6442] is not suitable for value type [Numeric (float)]
原因是:Warning: Using a password on the command line interface can be insecure这一行无法被shell脚本解析,需要屏蔽。
解决方案:
/usr/local/mysql/bin/mysql_config_editor set --login-path=local --host=localhost --user=zabbix -p
上述设置好之后,下面使用--login-path=local就可以了
/usr/local/mysql/bin/mysql --login-path=local -e "select 1" --socket=/opt/mysql/mysqldata/3306/mysql.sock
/usr/local/mysql/bin/mysqladmin --login-path=local --socket=/opt/mysql/mysqldata/3306/mysql.sock status
- zabbix Warning: Using a password on the command line interface can be insecure
- zabbix监控mysql之Warning: Using a password on the command line interface can be insecure.
- Warning: Using a password on the command line interface can be insecure .ERROR 1045 (28000): Access
- cmd命令行下 Warning: Using a password on the command line interface can be insecure.
- Warning: Using a password on the command line interface can be insecure.
- mysqldump Warning: Using a password on the command line interface can be insecure.
- Error: mysql error: mysql: [Warning] Using a password on the command line interface can be insecure
- Warning: Using a password on the command line interface can be insecure
- mysql 备份报错mysqldump: [Warning] Using a password on the command line interface can be insecure.
- MySQL5.6 Using a password on the command line interface can be insecure解决方法;
- MySQL 解决数据导出问题:Using a password on the command line interface can be insecure.
- mysql5.0 Using a password on the command line interface can be insecure.最简单的解决办法
- Mysql Warning :Using a password on the command line...
- 解决MySQL5.6出现"Using a password on the command line interface..."
- MySQL5.6出现”Using a password on the command line interface…”解决办法
- MySQL5.6 Using a password on the command line inte
- This warning can be disabled by using the command line flag -Dcom.android.build.gradle.overridePath
- This warning can be disabled by using the command line flag -Dcom.android.build.gradle.overridePath
- 记一次ajax跨域访问后,session失效
- 奇异值分解的推理及意义
- 创建用户以及用户授权
- 树的可见区域的获取和滚动条监听
- 2017.8.7 用python实现简单文本编辑器
- zabbix Warning: Using a password on the command line interface can be insecure
- 盛大游戏2017校招前端工程师笔试试卷
- 封装
- 【翻译】在Ext JS 5+ 使用ViewControllers
- Mac OS X下完全卸载MySQL
- log4j配置文件简介&slf4j
- C++ 怎样让函数返回数组
- [leetcode]19. Remove Nth Node From End of List@Java解题报告
- HDU 1031 Design T-Shirt(结构体排序)