bind-address = 127.0.0.1 => bind-address= 136.129.20.168
IP要这么改
这么改远程连不上,那么需要把这行整行注释掉,重启MYSQL,telnet 136.129.20.168 3306,提示1130 is not allowed to connect to this MySQL server
那么需要在ubuntu上进去 mysql
sudo mysql -u root -p
提示输入密码
然后
mysql>
mysql>use mysql;
mysql>update user set host = '%' where user ='root';
然后重启MYSQL
就OK 了