Ubuntu MySQL5.7设置root密码

1.从debian.cnf中找到安装时生成的用户名和密码

(base) yhq@yhq-System-Product-Name:~$ sudo cat /etc/mysql/debian.cnf
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = xxxxxxxx
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
password = xxxxxxxx
socket   = /var/run/mysqld/mysqld.sock

2.修改root密码

用找到的用户名和密码登陆，我用的是dbeaver，创建新的连接，选择MySQL。

方法1：

update mysql.user set authentication_string=password('123456') where user='root' and Host = 'localhost';

方法2：

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

方法3：

set password for root@localhost = password('123');

3.修改plugin字段内容为mysql_native_password

update mysql.user set plugin='mysql_native_password'  where user='root' and Host = 'localhost';
flush privileges ; 

如果没有修改plugin字段为 mysql_native_password，用新密码无法成功登陆。因为没有更新这个字段，被坑的好苦…