【解决ubuntu20.04登陆mysql的疑难杂症】

1、确保本地拥有mysql安装包

2、查找默认用户名和密码

sudo cat /etc/mysql/debian.cnf

[client]
host     = localhost
user     = debian-sys-maint
password = 5M3ayJbyJT1R1OKO
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
password = 5M3ayJbyJT1R1OKO
socket   = /var/run/mysqld/mysqld.sock
 

3、用client下面的user 和 password来登录

mysql -u(user) -p(password)

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

4、远程连接

use mysql;
create user 'root'@'%' identified by '你的mysql密码';
grant all privileges on *.* to 'root'@'%';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的mysql密码';
flush privileges;     #退出mysql

#mysql配置文件中把 127.0.0.1 那行注释掉
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

#注释下面这行
bind-address =127.0.0.1

重启mysql服务
sudo service mysql restart