MySql默认是禁止外部访问的,需要按如下修改:
1. 登入 MySql
mysql -u root -p
2. 然后输入(password填写自己的)
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;
3. 我的系统是Ubuntu 16.04 ,MySql 5.7
打开文件
nano /etc/mysql/mysql.conf
然后发现有一行显示
bind-address = 127.0.0.1
用‘#’注释掉
#bind-address = 127.0.0.1
完事
参考(https://stackoverflow.com/questions/14779104/how-to-allow-remote-connection-to-mysql)