mysql_config_editor设置

最新推荐文章于 2024-10-28 21:28:36 发布

weixin_30315905

最新推荐文章于 2024-10-28 21:28:36 发布

阅读量59

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/chinaops/p/9680201.html

版权

[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

转载于:https://www.cnblogs.com/chinaops/p/9680201.html