navicat 连接远程MySQL服务失败原因
1.进入数据库授权用户 GRANT ALL PRIVILEGES ON *.* TO '授权用户'@'localhost' IDENTIFIED BY '授权密码&
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;