MySQL 用户授权

-- 创建数据库
CREATE DATABASE `database_name`;

-- 赋权
CREATE USER 'database_username'@'localhost' IDENTIFIED BY 'username_password';
GRANT ALL PRIVILEGES ON `database_name`.* TO `database_username`@'localhost';

-- 查看用户权限情况
SHOW GRANTS FOR 'database_username'@'localhost';

-- 回收权限和用户
REVOKE ALL PRIVILEGES ON `database_name`.'table_name' FROM `database_username`@'localhost';
DROP USER `database_username`@'localhost';