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';
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';