1、修改加密规则
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;
2、更新一下用户的密码 ,可以使用原密码
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘新密码’;
3、 刷新权限
FLUSH PRIVILEGES;
使用MySQL8注意事项
MySQL8.0url
jdbd.url=jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8
MySQL8.0驱动类
jdbc.drivercClass=com.mysql.cj.jdbc.Driver