為大家提供的MySQL忘記密碼的解決方案，供大家參考，具體內容如下
1.在操作系統windows操作系統，xp或win7.中進入如下目錄：
2.停止MySQL服務
C:/Program Files/MySQL/MySQL Server 5.5/bin>net stop mysql //MySQL 服務正在停止. //MySQL 服務已成功停止。
3.跳過授權給表
你會看到窗口光標在下一行的第一個位置閃爍，這說明已經啟動了，不需要管。
4. 新建一個命令行窗口同樣進入到e:/mysql5.5/bin目錄，啟動mysql
C:/Program Files/MySQL/MySQL Server 5.5/bin>mysql Welcome to the MySQL monitor. Commands end with ; or /g. Your MySQL connection id is 1 Server version: 5.5.36 MySQL Community Server (GPL) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '/h' for help. Type '/c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | test | +--------------------+ 4 rows in set (0.00 sec)
5.選擇mysql數據庫
mysql> use mysql; Database changed mysql> update user set password=PASSWORD('root') where user='root'; Query OK, 2 rows affected (0.00 sec) Rows matched: 2 Changed: 2 Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) 6.退出mysql終端：
mysql> quit Bye
7.看看那任務管理器中是否有mysqld.exe進程，如有，kill .
8.啟動mysql服務器
C:/Program Files/MySQL/MySQL Server 5.5/bin>net start mysql //MySQL 服務正在啟動 . //MySQL 服務已經啟動成功。
9.登錄mysql服務器
C:/Program Files/MySQL/MySQL Server 5.5/bin>mysql -u root -p root Welcome to the MySQL monitor. Commands end with ; or /g. Your MySQL connection id is 1 Server version: 5.5.36 MySQL Community Server (GPL) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '/h' for help. Type '/c' to clear the current input statement. mysql>
以后再也不用擔心MySQL忘記密碼了。
以上就是本文的全部內容，希望對大家的學習有所幫助。
新聞熱點
疑難解答
