mysql远程3306不通_解决navicat无法通过3306访问远程mysql问题

首先防火墙开放3306

编辑

注释 bind-address = 127.0.0.1 添加 skip-name-resolve

允许非本地登陆

mysql -u root -p

mysql>use mysql;

查看root账号的登录权限

mysql>select host, user from user;

修改登录权限

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

刷新,生效,最后一步,至关重要

注意，以上修改以后，会导致 mysql -h localhost -u root 无法登陆了，所以统一账号加密码登陆方式(mysql -u root -p)

接下来：继续参考https://stackoverflow.com/questions/39281594/error-1698-28000-access-denied-for-user-rootlocalhost

$ sudo mysql -u root # I had to use "sudo" since is new installation

mysql> USE mysql;

mysql> SELECT User, Host, plugin FROM mysql.user;

+------------------+-----------------------+

+------------------+-----------------------+

| debian-sys-maint | mysql_native_password |

+------------------+-----------------------+

修改方法一：

$ sudo mysql -u root # I had to use "sudo" since is new installation

mysql> USE mysql;

mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';

mysql> FLUSH PRIVILEGES;

mysql> exit;

$ service mysql restart

这样，就可以通过Navicat直接通过3306远程登陆了