[mysql]创建新用户并赋权

 

 

 

-- 创建用户

CREATE USER 'dev'@'%' IDENTIFIED BY 'dev';

-- 赋权

GRANT ALL PRIVILEGES ON *.* TO 'dev'@'%';

GRANT ALL PRIVILEGES ON db.* TO 'dev'@'%';

-- 刷新权限

FLUSH PRIVILEGES;