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 密碼更改 | 豬窩
I blog frequently and I really appreciate your content.
Your article has really peaked my interest. I am going to book mark your site
and keep checking for new information about once a week. I
subscribed to your RSS feed as well.
mysql root 密碼更改 | 豬窩 | 386
I needed to thank you for this great read!! I definitely loved every bit of it.
I have got you saved as a favorite to check out new
stuff you post…
mysql root 密碼更改 | 豬窩
This is my first time visit at here and i am genuinely impressed to read everthing at one place.
mysql root 密碼更改 | 豬窩
I am really enjoying the theme/design of your web site.
Do you ever run into any internet browser
compatibility issues? A small number of my blog audience have complained about my blog not operating correctly
in Explorer but looks great in Safari. Do you
have any advice to help fix this problem?
mysql root 密碼更改 | 豬窩
Hello there, I discovered your website by way of Google whilst looking
for a comparable subject, your site got here up, it seems good.
I have bookmarked it in my google bookmarks.
Hello there, simply become aware of your weblog via Google, and found that it is really informative.
I am going to be careful for brussels. I'll be grateful for those who
proceed this in future. A lot of other people might be benefited out of your writing.
Cheers!