mysql root 密碼更改
如果忘記了 MySQL 的 root 密碼，可以用以下方法重新設定：
1. 關閉 MySQL 伺服器。
/etc/rc.d/init.d/mysqld stop
2. 用以下指令啟動 MySQL，以跳過檢查權限的資料表
mysqld_safe --skip-grant-tables &
(顯示訊息 nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql 直接按Enter)
3. 現在己經可以用空密碼進入 MySQL
mysql -u root
4. 進入 MySQL 後執行以下指令更改 mysql root 密碼：
mysql> update mysql.user set password=PASSWORD(」new_password」) where User=』root';
mysql> flush privileges;
mysql> quit
5. 最後只需重新啟動 MySQL，便可以用新設定的密碼進入了。
參考自:http://www.cosa.org.tw/forum/index.php?topic=73.0
迴響
mysql root 密碼更改 | 豬窩
Somebody essentially help to make significantly articles I might state.
That is the very first time I frequented your website page and to this point?
I amazed with the research you made to create this
particular submit incredible. Magnificent job!
mysql root 密碼更改 | 豬窩 | 518
Hey! Would you mind if I share your blog with my zynga group?
There's a lot of people that I think would really appreciate your content.
Please let me know. Thanks
mysql root 密碼更改 | 豬窩 | 468
I've been browsing on-line greater than three hours these days,
yet I by no means discovered any attention-grabbing article like
yours. It is lovely value enough for me. In my opinion, if all web owners and bloggers made good content material as you did, the net will be a
lot more helpful than ever before.
mysql root 密碼更改 | 豬窩
Your means of describing the whole thing in this piece of writing is genuinely pleasant, every one be capable of effortlessly know it,
Thanks a lot.
mysql root 密碼更改 | 豬窩
Incredible points. Sound arguments. Keep up the amazing spirit.