- 添加用户
CREATE USER 'test'@'localhost' IDENTIFIED BY '123456';
- 分配用户指定库权限
GRANT SELECT, INSERT, UPDATE, REFERENCES, DELETE, CREATE, DROP, ALTER, INDEX, TRIGGER, CREATE VIEW, SHOW VIEW, EXECUTE, ALTER ROUTINE, CREATE ROUTINE, CREATE TEMPORARY TABLES, LOCK TABLES, EVENT ON `test_db`.* TO 'test'@'localhost';
- 分配权限
GRANT GRANT OPTION ON `test_db`.* TO 'test'@'localhost';