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 密碼更改 | 豬窩 | 426
Hello, I think your website could possibly be having internet browser compatibility problems.
When I look at your site in Safari, it looks fine however, if opening in Internet Explorer,
it has some overlapping issues. I merely wanted to give you a
quick heads up! Other than that, fantastic site!
mysql root 密碼更改 | 豬窩
For most up-to-date news you have to pay a visit internet and
on internet I found this site as a most excellent web page for most recent updates.
mysql root 密碼更改 | 豬窩
Definitely believe that which you stated. Your favorite justification seemed
to be on the web the simplest thing to be aware of.
I say to you, I definitely get irked while people think about worries that they plainly do not know about.
You managed to hit the nail upon the top and also defined out the whole
thing without having side-effects , people can take a signal.
Will likely be back to get more. Thanks
mysql root 密碼更改 | 豬窩 | 369
Hi, just wanted to say, I liked this post. It was helpful.
Keep on posting!
mysql root 密碼更改 | 豬窩
Hello! Someone in my Myspace group shared this website with us so I came to
check it out. I'm definitely enjoying the information. I'm
bookmarking and will be tweeting this to my followers!
Superb blog and excellent design.