mysql8.0修改加密方式和设置简单密码
- 1、安装mysql8.0
- 2、查看临时密码:grep "A temporary password" /var/log/mysqld.log
- 3、登录及输入密码:mysql -u root -p 输入密码
- 4、进行权限查看: SHOW VARIABLES LIKE 'validate_password%';
- 5、修改密码长度限制:set global validate_password.length=4;
- 6、修改密码加密方式限制:set global validate_password.policy=0;
- 7、修改密码:ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
- 8、刷新密码数据:flush privileges;
- 9、进入mysql数据库: use mysql;
- 10、更新远程链接:update user set host='%' where user='root';
- 11、刷新数据库:flush privileges;