GRANT ALL PRIVILEGES ON *.* TO ‘username’@’%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION; 所有数据库所有表
GRANT ALL PRIVILEGES ON xinchuanbo.* TO ‘zzs’@’%’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION; 开通用户:zzs 密码:123456 数据库 xinchuanbo (远程操作)