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
Spot on with this write-up, I absolutely believe that this amazing
site needs much more attention. I'll probably be back again to
see more, thanks for the information!
mysql root 密碼更改 | 豬窩
Link exchange is nothing else however it is just placing the
other person's web site link on your page at proper place and other person will also
do similar in support of you.
mysql root 密碼更改 | 豬窩 | 2066
I just could not depart your website prior to suggesting that I extremely loved the usual info
a person supply in your visitors? Is gonna be back often to check out new posts
mysql root 密碼更改 | 豬窩 | 1092
Hello, i think that i saw you visited my website thus
i came to “return the favor”.I'm attempting to find things to
improve my site!I suppose its ok to use a few of your ideas!!
mysql root 密碼更改 | 豬窩 | 1092
Hello! I simply wish to give you a big thumbs up for the
excellent information you have got right here on this post.
I am coming back to your blog for more soon.