设置免密登录的工具

使用mysql的mysql_config_editor

创建login文件

命令：
/usr/local/mysql/bin/mysql_config_editor set --login-path=my${MYSQL_PORT} --socket=/data/my${MYSQL_PORT}/var/mysql.sock --user=root --password

例子：
/usr/local/mysql/bin/mysql_config_editor set --login-path=my3301 --socket=/data/my3301/var/mysql.sock --user=root --password
输入root的密码

验证login文件无需输入密码登录即可

命令：
mysql --login-path=root --socket=--socket=/data/my${MYSQL_PORT}/var/mysql.sock

例子：
/usr/local/mysql/bin/mysql --login-path=my3301  --socket=/data/my3301/var/mysql.sock

打印密码

命令：

/usr/local/mysql/bin/my_print_defaults -s root

例子：
[root@host001 bin]# /usr/local/mysql/bin/mysql_config_editor print  --all
[root]
user = root
password = *****
[my3301]
user = root
password = *****
socket = /data/my3301}/var/mysql.sock
[my3302]
user = root
password = *****
socket = /data/my3302/var/mysql.sock
[my3307]
user = root
password = *****
socket = /data/my3307/var/mysql.sock
[root@host001 bin]#
[root@host001 bin]#

[root@host001 bin]# /usr/local/mysql/bin/my_print_defaults -s my3301
--user=root
--password=xxxxxxxx
--socket=/data/my3301}/var/mysql.sock