数据库修改是一个十分头疼的问题,就个人而言,我所遇到的问题是安装Mysql时是有设置密码,但从cmd进Mysql的时候,只有无密码可以进,Java连接Mysql会有很多问题。
1、首先,cmd方式打开Msql(注意路径)
2、按以下顺序运行(运行后,默认密码为123456)
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #更新一下用户的密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
FLUSH PRIVILEGES;
alter user 'root'@'localhost' identified by '123456';
注:如果是无密码可以打开Mysql,此方法可以成功修改。