> 文章列表 > mysql8密码兼容

mysql8密码兼容

mysql8密码兼容

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;

免费软件下载