1、先打开mysql
2、写入一句:
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
出现
3、然后修改密码:
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';
4、刷新一下
FLUSH PRIVILEGES;
5、最后在试着创建连接
这样子就成功了