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'