Linux:
1、用root或者运行mysqld的用户登录系统;
[root@abao ~]# mysql -V
mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1
2、利用kill命令结束掉mysqld的进程;
[root@abao ~]#service mysql stop
3、为root@localhost设置新密码
[root@abao ~]# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
[root@abao ~]#mysql
mysql> use mysql
Database changed
mysql>UPDATE user SET password=PASSWORD("新密码") WHERE user='root';
Query OK, 4 rows affected (0.01 sec)
Rows matched: 4 Changed: 4 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
6. 重新启动MySQL
[root@abao ~]# service mysqld restart
170410 11:10:01 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
停止 mysqld: [确定]
正在启动 mysqld: [确定]
[1]+ Done mysqld_safe --user=mysql --skip-grant-tables --skip-networkin
Windows:
1.以系统管理员登陆;
2.停止MySQL服务;
3.进入CMD,进入MySQL的安装目录,假设是D:/MySQL/MySQL Server 5.0/;
4.跳过权限检查启动MySQL,
D:/MySQL/MySQL Server 5.0/bin/mysqld-nt –skip-grant-tables
5.重新打开一个CMD,进入D:/MySQL/MySQL Server 5.0/bin/,
重设root密码
D:/MySQL/MySQL Server 5.0/bin/mysqladmin -uroot flush-privileges password “newpassword”
D:/MySQL/MySQL Server 5.0/bin/mysqladmin -u root -p shutdown
将newpassword替换为你的新密码,第二个命令会让你重复输入一次新 密码。
6. 在cmd里net start mysql