mysql 新用户授权单库

CREATE USER ‘xxx’@’%’ IDENTIFIED BY ‘xxx’;

CREATE DATABASE new_database;

GRANT ALL PRIVILEGES ON new_database.* TO ‘xxx’@’%’;

FLUSH PRIVILEGES;

删除权限

REVOKE ALL PRIVILEGES, GRANT OPTION FROM ‘xxx’@’%’;

删除用户

DROP USER ‘username’@’hostname1’, ‘username’@’hostname2’, …;