use mysql;
select * from user;
# 创建用户,使用mysql_native_password加密密码
create user 'root_native'@'%' identified with mysql_native_password by '123456782023';
flush privileges;
# 授权用户访问所有数据库
grant all privileges on *.* to 'root_native'@'%' with grant option;
flush privileges;
select * from user;
07-10
906
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
07-27
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交