咨询热线:4006-75-4006
售前:9:00-23:30 备案:9:00-18:00 技术:7*24h
1.切换到MYSQL数据库安装的盘区并cd进入bin目录下,如图:
2. 键入mysqld --skip-grant-tables就跳过了mysql身份验证(此时的DOS窗口不用,另打开一个dos窗口),然后键入mysql ,如图所示:(注意:键入mysql命令之前确定关闭mysql服务和结束mysql.exe进程)


3.键入show databases;
4.键入use mysql
5.键入show tables;
6.键入select user,host,password from user;
7.键入update user set password=password('617dcd418478') where user='root' and host='localhost';
如下图所示,说明修改成功----------------------------------(617dcd418478为密码)

8.mysql> flush privileges;
9.登录测试:重启MySQL数据库,打开cmd.exe,键入mysql -uroot -p617dcd418478回车,说明修改成功
