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 密碼更改 | 豬窩 | 763
Excellent blog here! Also your site loads up
very fast! What web host are you using? Can I get
your affiliate link to your host? I wish my web
site loaded up as fast as yours lol
mysql root 密碼更改 | 豬窩
Hi there to all, how is all, I think every one is getting more from this site, and your views are fastidious for
new users.click here buttonshttp://bjorno.mee.nu/?entry=3379878http://paradune.com/phorum/read.php?13,106182
mysql root 密碼更改 | 豬窩 | 162
%%
mysql root 密碼更改 | 豬窩
Wһat's ᥙp to all, as I ɑm in fact eager of reading tһis
web site'ѕ post to be updated daily. Ӏt consists օf fastidious data.
mysql root 密碼更改 | 豬窩 | 1222
Hello there, I found your web site by the use of Google at the same
time as searching for a comparable subject, your web site got here up, it appears to
be like great. I have bookmarked it in my google bookmarks.
Hi there, just was aware of your weblog through Google, and
located that it's really informative. I am going to be careful for brussels.
I will appreciate in case you proceed this in future.
Lots of people might be benefited from your writing.
Cheers!