zabbix Warning: Using a password on the command line interface can be insecure

  使用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