1.创建新用户

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

2.授权该用户对所有数据库的所有权限

GRANT ALL PRIVILEGES ON database.* TO 'newuser'@'localhost';

3.刷新权限

FLUSH PRIVILEGES;