debian mysql 8.0.21修改root密码

---

第一步：找到用户名和密码

• 查找用户名和密码的命令：

sudo cat /etc/mysql/debian.cnf

• 具体操作如下

bobo@bobo-B85M-D2V-SI:~$ sudo cat /etc/mysql/debian.cnf
[sudo] bobo 的密码：
#Automatically generated for Debian scripts. DO NET TOUCH!
[client]
host		=	localhost
user		=	debian-sys-maint
password	=	IFjLzdMLYvq55biL
socket		=	/var/run/mysqld/mysqld.sock
[mysql_upgrade]
host		=	localhost
user		=	debian-sys-maint
password	=	IFjLzdMLYvq55biL
socket		=	/var/run/mysqld/mysqld.sock

• 以下为找的用户名和密码

user		=	debian-sys-maint
password	=	IFjLzdMLYvq55biL

第二步：用此用户名和密码登陆

• 具体操作如下

bobo@bobo-B85M-D2V-SI:~$ mysql -u debian-sys-maint -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19
Server version: 8.0.21-0ubuntu0.20.04.4 (Ubuntu)

Copyright (c) 2000, 2020, 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>

第三步：修改密码

• 具体操作如下

~# use mysql;
~# flush privileges;
~# ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';
~# flush privileges;