设置mysql允许外部连接访问(授权和修改表方式)

1.设置mysql允许外部连接访问(授权)：

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

例子：
查询mysql用户权限、授权、刷新使生效

select host, user from user;
grant all privileges on *.* to root@'%' identified by '密码' with grant option;
flush privileges;

指定ip地址授权：ip地址指的是连接时失败报错1130弹出的地址

grant all privileges on *.* to root@'ip地址' i