1.创建用户 GRANT USAGE ON *.* TO 'test'@'localhost' IDENTIFIED BY '1234' WITH GRANT OPTION; 2 授权 GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON tableName.* TO 'test'@'localhost' IDENTIFIED BY '1234'; 3 完成 FLUSH PRIVILEGES;