mysql config editor_mysql_config_editor设置

[root@node01 etc]# mysql_config_editor set -G mysql3307 -S /tmp/mysql3307.sock -uroot -p

Enter password:

[root@node01 etc]# mysql

mysql mysqld_multi mysql_secure_installation

mysqladmin mysqld_safe mysqlshow

mysqlbinlog mysqldump mysqlslap

mysqlcheck mysqldumpslow mysql_ssl_rsa_setup

mysql_client_test_embedded mysql_embedded mysqltest_embedded

mysql_config mysqlimport mysql_tzinfo_to_sql

mysql_config_editor mysql_install_db mysql_upgrade

mysqld mysql_plugin mysqlxtest

mysqld-debug mysqlpump

[root@node01 etc]# mysql --login-path=mysql3307

[root@node01 etc]# mysqladmin --login-path=mysql3307 status

Uptime: 9694 Threads: 1 Questions: 5450 Slow queries: 0 Opens: 462 Flush tables: 1 Open tables: 38 Queries per second avg: 0.562

[root@node01 ~]# cat .my

.mylogin.cnf .mysql_history

[root@node01 ~]# cat .mylogin.cnf