下载地址:
MySQL :: Download MySQL Community Server (Archived Versions)
下载后进行系统环境变量配置
1. MYSQL_HOME=D:\mysql\mysql-5.7.35-winx64
2.Path: ……之前的配置……%MYSQL_HOME%\bin\;
3.增加my.ini文件在D:\mysql\mysql-5.7.35-winx64\
打开命令行(最好是管理员模式):
mysqld --defaults-file="D:\mysql\mysql-5.7.35-winx64\my.ini" --skip-grant-tables
mysql -uroot -p
输入密码直接回车
use mysql; 切换到mysql数据库
UPDATE user SET authentication_string=PASSWORD(‘root’) where user=’root’;
flush privileges;
exit;
mysql服务启动关闭命令:
net start mysql
net stop mysql
mysql error You must reset your password using ALTER USER statement before executing this statement.
step 1: SET PASSWORD = PASSWORD('your new password');//这里your new password 就是你的密码
step 2: ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER; step 3: flush privileges; 完成以上三步退出再登,使用新设置的密码就行了,其他原样输入即可
值得一看的文章: