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 密碼更改 | 豬窩
Hello great blog! Does running a blog similar to this require a great deal of work?
I have absolutely no expertise in coding however I was hoping to start my own blog
soon. Anyways, should you have any recommendations or
tips for new blog owners please share. I know this is off subject however I simply had to ask.
Thanks a lot!
mysql root 密碼更改 | 豬窩
I am truly happy to read this web site posts which carries
tons of valuable facts, thanks for providing these kinds of data.
mysql root 密碼更改 | 豬窩
Simply wish to say your article is as surprising. The clarity for your publish is just nice
and that i can think you are knowledgeable in this subject.
Well along with your permission let me to grab
your feed to keep up to date with coming near near
post. Thanks one million and please continue the rewarding work.
mysql root 密碼更改 | 豬窩
Link exchange is nothing else except it is simply placing
the other person's web site link on your page at appropriate place and other person will also do similar in support
of you.
mysql root 密碼更改 | 豬窩 | 1223
When I originally commented I clicked the "Notify me when new comments are added" checkbox and now each time a comment
is added I get several e-mails with the same comment. Is there any way you can remove me from that service?
Thanks a lot!