ubuntu下设定mysql的远程访问

1.首先建立用户

  grant all privileges on *.* to 'root'@'%' identified by '123456';

 

2.配置my.cnf

  sudo vi /etc/mysql/my.cnf

  注释掉bind-address = 127.0.0.1

 

 

 

然后重启mysql

  sudo /etc/init.d/mysql restart