Mysql 8.0修改密码的方式

哪有天生的学霸，一切都是厚积薄发

已于 2022-09-17 23:15:46 修改

阅读量263

点赞数

分类专栏： Mysql Linux 文章标签： mysql

于 2021-05-13 09:28:20 首次发布

本文链接：https://blog.youkuaiyun.com/qq_35078688/article/details/116736810

版权

Linux 同时被 2 个专栏收录

72 篇文章

订阅专栏

Mysql

21 篇文章

订阅专栏

本文展示了如何使用MySQL命令行工具更改root用户的密码，并刷新权限。演示了从登录到更新密码及验证整个过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> alter user root@'localhost' IDENTIFIED BY 'MyNewPass@123';
Query OK, 0 rows affected (0.01 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> status
--------------
mysql  Ver 8.0.21 for Linux on x86_64 (Source distribution)

Connection id:		12
Current database:	
Current user:		root@localhost
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		8.0.21 Source distribution
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	utf8mb4
Db     characterset:	utf8mb4
Client characterset:	utf8mb4
Conn.  characterset:	utf8mb4
UNIX socket:		/var/lib/mysql/mysql.sock
Binary data as:		Hexadecimal
Uptime:			12 hours 34 min 2 sec

Threads: 2  Questions: 7  Slow queries: 0  Opens: 116  Flush tables: 3  Open tables: 37  Queries per second avg: 0.000
--------------