mysql_config_editor的配置

参考文档：
https://mysql.net.cn/doc/refman/8.0/en/mysql-config-editor.html

OS上分别有2套库，设置后，通过不使用密码来登录，类似postgres的.pgpass文件 

-- 执行一下命令，会要求提示输入密码 

mysql_config_editor set --login-path=3306 --user=root  --host=127.0.0.1 --port=3306 --password
mysql_config_editor set --login-path=3307 --user=root  --host=127.0.0.1 --port=3307 --password

-- 产生的.mylogin.cnf文件，这是一个隐藏文件 ，而且不是文本格式的，所以打开会是乱码

[root@redhat762100 ~]# more .mylogin.cnf
�ԋu����>���J

--通过print打印出分组3306，分组3307，以及所有的内容 

[root@redhat762100 ~]# mysql_config_editor print --login-path=3306
[3306]
user = root
password = *****
host = 127.0.0.1
port = 3306
[root@redhat762100 ~]# mysql_config_editor print --login-path=3307
[3307]
user = root
password = *****
host = 127.0.0.1
port = 3307
[root@redhat762100 ~]#
 
[root@redhat762100 ~]# mysql_config_editor print --all
[3306]
user = root
password = *****
host = 127.0.0.1
port = 3306
[3307]
user = root
password = *****
host = 127.0.0.1
port = 3307
[root@redhat762100 ~]#

-- 通过免密码登录到3306库

[root@redhat762100 ~]# mysql --login-path=3306
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 30
Server version: 5.7.25-log MySQL Community Server (GPL)
 
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
 
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
root@db 15:27:  [(none)]>

-- 通过免密码登录到3307库 

[root@redhat762100 ~]# mysql --login-path=3307
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.7.25-log MySQL Community Server (GPL)
 
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
 
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
root@db 15:27:  [(none)]>

END