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 密碼更改 | 豬窩 | 178
excellent submit, very informative. I'm wondering why the opposite experts of this
sector don't notice this. You should proceed your
writing. I'm sure, you have a great readers' base already!
mysql root 密碼更改 | 豬窩 | 1616
After going over a number of the blog articles
on your website, I seriously appreciate your technique of writing a blog.
I saved as a favorite it to my bookmark site list and will be checking back soon. Please visit my website as well and let me know your opinion.
mysql root 密碼更改 | 豬窩 | 1736
This is very interesting, You are a very professional blogger.
I've joined your rss feed and look ahead to in the hunt for more of your excellent post.
Also, I have shared your web site in my social networks
mysql root 密碼更改 | 豬窩
Today, I went to the beachfront with my children. I found a sea
shell and gave it to my 4 year old daughter and said "You can hear the ocean if you put this to your ear." She put the
shell to her ear and screamed. There was a hermit
crab inside and it pinched her ear. She never wants to go back!
LoL I know this is completely off topic but I had to tell someone!
mysql root 密碼更改 | 豬窩 | 1156
Thanks a bunch for sharing this with all folks you really recognize what you
are talking about! Bookmarked. Please additionally talk over with my web site =).
We could have a link change contract among us