– 创建新用户(这里的’username’是新用户名,'password’是新密码)
create user username@'%' identified by 'password';
– 授权新用户对数据库的权限(这里的’databaseName’是数据库名,username 是用户)
GRANT ALL PRIVILEGES ON databaseName.* TO 'username'@'%';
– 刷新权限使变更生效
FLUSH PRIVILEGES;
– 创建新用户(这里的’username’是新用户名,'password’是新密码)
create user username@'%' identified by 'password';
– 授权新用户对数据库的权限(这里的’databaseName’是数据库名,username 是用户)
GRANT ALL PRIVILEGES ON databaseName.* TO 'username'@'%';
– 刷新权限使变更生效
FLUSH PRIVILEGES;