mysql开启远程连接

修改my.ini

去掉

bind-address 127.0.0.1

或添加

bind-address 0.0.0.0

mysql -u root -p 进入mysql，执行

 

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

然后

flush privileges;

重启mysql