GRANT SELECT,INSERT,UPDATE,DELETE ON test.* TO 用户名@"localhost" IDENTIFIED BY "密码"; -- 执行
use mysql; ALTER USER 'root'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; FLUSH PRIVILEGES;