mysql开启远程连接权限

1.mysql>user mysql
2.更改user表中的host字段为%,即任意ip都可连接:mysql>update user set host = '%' where user = 'root';
3.mysql> grant all privileges on . to root@'%' identified by "123456";
4.刷新:mysql> flush privileges;