mysql数据库连接，开启远程权限

mysql数据库开启远程访问权限（root为用户名，123456为密码，%代表任意ip）:
grant all privileges on .(.两边各有一个*号) to ‘root’@’%’ identified by ‘123456’ to with grant option;
刷新权限:
flush privileges;
查看权限情况:
use mysql;
select host,user,password from user;