grant 权限1,权限2,…权限n on 数据库名称.表名称 to 用户名@用户地址 identified by ‘密码’;

权限：select,insert,update,delete,create,drop,index,alter,grant,references,reload,shutdown,process,file

所有权限：all privileges或者all

所有数据库所有表：*.*

所有地址：’%’

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