Ubuntu server 20设置mysql密码

原因：使用命令mysql -u root -p登录时提示Access denied for user ‘root’@localhost’
百度得好像是没有给mysql设置密码
解决方法：在终端执行以下命令就好

sudo mysql
flush privileges;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;
exit

界面效果

lqc@lqc:~$ sudo mysql
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.01 sec)

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

mysql> exit
Bye
lqc@lqc:~$ 

再次登录就可以正常使用了

lqc@lqc:~$ mysql -u root -p
//输入密码
mysql>