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;
![](https://www.cnblogs.com/images/cnblogs_com/-hao/1352120/o_zfbAndWx.jpg)
您的资助是我最大的动力!
金额随意,欢迎来赏!