mysql8.0 保护登录信息

lao_yunger

已于 2023-10-24 08:00:09 修改

阅读量100

点赞数

分类专栏： my sql8.0 ocp 数据库文章标签： mysql 数据库 sql dba oracle 1024程序员节

于 2023-10-12 21:43:03 首次发布

本文链接：https://blog.csdn.net/qq_25439957/article/details/133799791

版权

数据库同时被 3 个专栏收录

26 篇文章 1 订阅

订阅专栏

my sql8.0

6 篇文章 0 订阅

订阅专栏

ocp

3 篇文章 0 订阅

订阅专栏

[root@student ~]# mysql_config_editor --help
mysql_config_editor Ver 8.0.13 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)
Copyright (c) 2012, 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.

MySQL Configuration Utility.
Usage: mysql_config_editor [program options] [command [command options]]
-#, --debug[=#] This is a non-debug version. Catch this and exit.
-?, --help Display this help and exit.
-v, --verbose Write more information.
-V, --version Output version information and exit.

Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- ----------------------------------------
verbose FALSE

Where command can be any one of the following :
set [command options] Sets user name/password/host name/socket/port
for a given login path (section).
remove [command options] Remove a login path from the login file.
print [command options] Print all the options for a specified
login path.
reset [command options] Deletes the contents of the login file.
help Display this usage/help information.

[root@student ~]# mysql_config_editor set --login_path=client --user=root --password --host=localhost --port=3306
Enter password:
会在当前用户HOME文件夹下创建一个隐藏二进制文件

[root@student ~]# ls -al .mylogin.cnf
-rw------- 1 root root 156 Oct 12 21:37 .mylogin.cnf
[root@student ~]#

[root@student ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18
Server version: 8.0.13 MySQL Community Server - GPL

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>