178 无法连接远程服务器mysql数据库

无法连接远程服务器mysql数据库

---

　修改配置

今天连接阿里云上的mysql数据报错，信息如下

ERROR 2003 (HY000): Can't connect to MySQL server on "host" (111) 

默认情况下Mysql只允许本地登录，所以需要修改配置文件将地址绑定给注释掉：

vim /etc/mysql/my.cnf

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address           = 127.0.0.1  <---注释掉这一行就可以远程登录了

修改用户表

另外一个报错

报错:1130-host ... is not allowed to connect to this MySql server

可能是你的帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入mysql后，更改 “mysql” 数据库里的 “user” 表里的 “host” 项，从”localhost”改称”%”

mysql -u root -pvmwaremysql>use mysql;
mysql> update user set host = '%' where user = 'root';
mysql> FLUSH PRIVILEGES;