无法连接远程服务器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;