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 密碼更改 | 豬窩 | 1240
Hi there! Quick question that's completely off topic.
Do you know how to make your site mobile friendly? My
weblog looks weird when browsing from my iphone4.
I'm trying to find a template or plugin that might be able to fix this issue.
If you have any suggestions, please share. Appreciate it!
mysql root 密碼更改 | 豬窩 | 1223
Wonderful goods from you, man. I have bear in mind your stuff previous to and you are
simply extremely great. I actually like what you've acquired here, really like what you're
stating and the way by which you say it. You are making it entertaining and you continue to care for to keep it smart.
I can't wait to learn far more from you. That is really a wonderful website.
mysql root 密碼更改 | 豬窩 | 763
My partner and I stumbled over here from a different web page and
thought I may as well check things out. I like what I see so now i'm
following you. Look forward to checking out your web page again.
mysql root 密碼更改 | 豬窩
Howdy! This blog post could not be written any
better! Looking through this article reminds me of my previous roommate!
He constantly kept talking about this. I most certainly will forward this article to him.
Pretty sure he will have a good read. Thanks for sharing!
mysql root 密碼更改 | 豬窩 | 1270
Hey! This post couldn't be written any better! Reading this post reminds me of my previous room
mate! He always kept chatting about this.
I will forward this post to him. Pretty
sure he will have a good read. Thank you for sharing!