远程连接mysql 数据库授权

grant [权限] on [数据库名].[表名] to ['用户名']@['web服务器的ip地址'] identified by ['密码']

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

grant all on *.* to 'root'@'192.168.1.1' identified by 'root';