Mysql 安全登陆工具 mysql_config_editor

Mysql 安全登陆工具 mysql_config_editor
mysql_config_editor
帮助信息请查看
man mysql_config_editor 或 mysql_config_editor -? 或 mysql_config_editor set -?
该工具会在用户家目录生成二进制文件:.mylogin.cnf
该文件格式由选项组组成,每个选项组被称为login path ,仅包含特定选项: host, user, password, port and socket 用于用户验证。

用法:
mysql_config_editor set [command options] Sets user name/password/host name/socket/port for a given login path (section).
mysql_config_editor remove [command options] Remove a login path from the login file.
mysql_config_editor print [command options] Print all the options for a specified login path.
mysql_config_editor reset [command options] Deletes the contents of the login file.

设置 login path
复制代码
[root@mysql1 ~]# mysql_config_editor set -?

-h, --host=name Host name to be entered into the login file.
-G, --login-path=name Name of the login path to use in the login file. (Default: client)
-p, --password Prompt for password to be entered into the login file.
-u, --user=name User name to be entered into the login file.
-S, --socket=name Socket path to be entered into login file.
-P, --port=name Port number to be entered into login file.

复制代码

如:
mysql_config_editor set -G mypath -u root -p -S /u01/data/mysql5.7.25/mysql.sock
mysql_config_editor set -G user1 -u user1 -p -S /u01/data/mysql5.7.25/mysql.sock

显示 login path
mysql_config_editor print --all
mysql_config_editor print -G user1
复制代码
[root@mysql1 ~]# mysql_config_editor print --all
[client] # 默认 login path
[mypath]
user = root
password = *
socket = /u01/data/mysql5.7.25/mysql.sock
[mypath1]
user = root
password = *
socket = /u01/data/mysql5.7.25/mysql.sock
[user1]
user = user1
password = *
socket = /u01/data/mysql5.7.25/mysql.sock
复制代码

删除 login path
mysql_config_editor remove -G user1
复制代码
[root@mysql1 ~]# mysql_config_editor remove -G user1
[root@mysql1 ~]# mysql_config_editor print --all
[client]
[mypath]
user = root
password = *
socket = /u01/data/mysql5.7.25/mysql.sock
[mypath1]
user = root
password = *
socket = /u01/data/mysql5.7.25/mysql.sock
复制代码

重置 login file
mysql_config_editor reset
[root@mysql1 ~]# mysql_config_editor reset
[root@mysql1 ~]# mysql_config_editor print --all # 文件已被清空

使用 login path
mysql --login-path=mypath
mysqladmin --login-path=mypath
[root@mysql1 ~]# mysqladmin --login-path=mypath status
Uptime: 11918 Threads: 1 Questions: 18 Slow queries: 0 Opens: 106 Flush tables: 1 Open tables: 99 Queries per second avg: 0.001
原文地址https://www.cnblogs.com/plluoye/p/10629180.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值