mysql本地连接密码正常,远程连接出错
- 输入 netstat -lntp 查看端口是否正常开放
[root@VM-12-6-centos ~]# netstat -lntp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp6 0 0 :::3306 :::* LISTEN 3362/mysqld
2.需要授予其他IP远程登录的权利
输入mysql>GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘root’ WITH GRANT OPTION; //IDENTIFIED BY ‘设置的密码’
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '##########' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.01 sec)
3.刷新权限
mysql>flush privileges;
在重新尝试远程连接,已经可以连接上