mysql_config_editor用法举例
mysql_config_editor是一种存储mysql登录信息的工具。
通过mysql_config_editor设置了登录信息后，在用mysql命令登录数据库时就可以只用加一个--login-path=name的参数，
而不用再输入host,user,password等信息登陆。
举例如下:
正常登陆为:
# 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
打印config_editor信息:
#mysql_config_editor print --all
[9527]
user = root
password = *****
socket = /tmp/mysql.sock
用mysql --login-path登陆:
#mysql --login-path=9527
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 66820
Server version: 8.0.13 MySQL Community Server - GPL
Copyright (c) 2000, 2018, 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.
mysql>\s
--------------
mysql Ver 8.0.13 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)
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
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
UNIX socket: /tmp/mysql.sock
Uptime: 23 hours 41 min 42 sec
Threads: 2 Questions: 266 Slow queries: 0 Opens: 380 Flush tables: 2 Open tables: 352 Queries per second avg: 0.003
--------------
mysql>quit
Bye
reset 删除config_editor日志的所有内容
# mysql_config_editor reset
开发shell脚本时不提示密码方法:
# cd ~
# vim .my.cnf
[client]
user=root
password=123456
直接敲mysql就能登陆，不需要输入密码:
# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 132246
Server version: 8.0.13 MySQL Community Server - GPL
Copyright (c) 2000, 2018, 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.
mysql >quit
Bye
