ITPub博客

首页 > 数据库 > MySQL > mysql_config_editor用法举例

mysql_config_editor用法举例

原创 MySQL 作者:chenfeng 时间:2019-01-17 10:46:29 0 删除 编辑

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







来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15498/viewspace-2564016/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
交流MySQL,MongoDB和Redis技术。 微信或QQ:410294

注册时间:2015-12-07

  • 博文量
    758
  • 访问量
    2201379