1 Can't connect to MySQL server (10060)
①.设置远程用户访问权限:
// 任何远程主机都可以访问数据库
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION;
//需要输入次命令使修改生效
mysql> FLUSH PRIVILEGES; mysql> EXIT
②.在iptables中开放3306端口
vi /etc/sysconfig/iptables
添加-A INPUT -p tcp --dport 3306 -j ACCEPT
# service iptables restart 重启生效
2. 1045 - Access denied for user ‘root‘@‘localhost‘ (using password: YES)
mysql>grant all on *.* to aaa@‘%‘ identified by ‘123456‘;
mysql> FLUSH PRIVILEGES;
重新打开Navicat,OK,正常。