语法:
grant [权限] on [数据库名].[表名] to ['用户名']@['web服务器的ip地址'] identified by ['密码'];
grant all on *.* to 'root'@'%' identified by 'root';
或者指定IP地址
grant all on *.* to 'root'@'192.168.1.103' identified by 'root';
/*Mysql默认条件下,只允许本机访问,如果远程访问,必须开放权限*/
GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'root';