mysql_config_editor用法示例

2024-07-24 12:32:26

字體：大中小

來源：轉載

供稿：網友

mysql_config_editor是一種存儲mysql登錄信息的工具。

通過mysql_config_editor設置了登錄信息后，在用mysql命令登錄數據庫時就可以只用加一個--login-path=name的參數，

舉例如下:

正常登陸為:

# mysql -uroot -p'123456' --socket=/tmp/mysql.sock

配置config_editor:

#mysql_config_editor set --login-path=9527 --socket=/tmp/mysql.sock --user=root --password

Enter password:      --此時輸入123456

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Connection id:          66820

Current database:

Current user:           root@localhost

SSL:                    Not in use

Current pager:          stdout

Using outfile:          ''

Using delimiter:        ;

Server version:         8.0.13 MySQL Community Server - GPL

Protocol version:       10

Connection:             Localhost via UNIX socket

Threads: 2 Questions: 266 Slow queries: 0 Opens: 380 Flush tables: 2 Open tables: 352 Queries per second avg: 0.003

（編輯：武林網）

上一篇：MySQL中修改密碼及訪問限制設定詳解

下一篇：mysql innobackupex加量備份