ubuntu下安装mysql连接不上的问题

1.navicat连接时报10061

sudo vi /etc/mysql/mysql.conf.d/mysqld.conf  找到bind-address = 127.0.0.1并注释掉

service mysql restart

2.报1130

使用mysql命令，然后

mysql>update user set host = '%' where user = 'root';

mysql>flush   privileges;

3.报1689

mysql>alter user 'root'@'localhost' identified with mysql_native_password by 'xxx';
若此时已经执行过第二步，@‘localhost'要改为@’%‘，其中xxx是mysql的密码,进行刷新
mysql>flush   privileges;

 引用：

https://blog.csdn.net/shahuhu000/article/details/94067776

https://www.cnblogs.com/Jack-zhao/p/11124960.html