navicat 连接远程MySQL服务失败原因

2023-06-13 12:27:16

1.进入数据库授权用户 GRANT ALL PRIVILEGES ON *.* TO &#39;授权用户&#39;@&#39;localhost&#39; IDENTIFIED BY &#39;授权密码&

1.进入数据库授权用户

GRANT ALL PRIVILEGES ON *.* TO '授权用户'@'localhost' IDENTIFIED BY '授权密码' WITH GRANT OPTION;

2.MySQL5.7 以后设置密码出现 Your password does not satisfy the current policy requirements. 解决

(1)修改参数 validate_password_policy参数的值 set global validate_password_policy=0;

(2)设置密码长度 set global validate_password_length=1;

通过 select @@validate_password_length;查看密码长度;

最后 flush privileges;

3.如果还不能连接成功,修改mysql 配置 ubuntu 默认在

/etc/mysql/mysql.conf.d/mysqld.cnf 里修改

bind-address = 127.0.0.1改成bind-address = 自己的IP

重启MySQL service mysql stop service mysql start;