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 密碼更改 | 豬窩
Very descriptive post, I enjoyed that a lot.
Will there be a part 2?
mysql root 密碼更改 | 豬窩
Its such as you read my thoughts! You seem to know so much approximately this, like you wrote the e book in it or something.
I think that you simply can do with some % to pressure the
message house a little bit, but instead of that, that is magnificent blog.
A great read. I will definitely be back.
mysql root 密碼更改 | 豬窩
Hi, everything is going perfectly here and ofcourse
every one is sharing data, that's truly good, keep up writing.
mysql root 密碼更改 | 豬窩
Appreciate this post. Let me try it out.
mysql root 密碼更改 | 豬窩
It doesn't matter if you're old or young or rich or poor, the topic of sex is
most likely among the top discussed and debated things in the world.
All people need sex, not just for procreation, but for
the pleasure and strength of a relationship as well.
You can't talk about romance without incorporating sexual intimacy, so if you're already in a relationship , and you are looking to make your relationship
last, you need to start working on your sex lifestyle.
But how do you start? While you'll find plenty of fantastic ideas on how you can spice up your
love life There is only one way that can help you take your sex life
up by a few notches. Want to know what a sex instructional video can do to improve
your relationship? Then don't hesitate to read
on.Assuming that you and your spouse have an open mind about the topic,
a sex instructional video could do wonders on your romance.
Be aware that this method isn't appropriate for every person. If you've just started dating, make sure
to be open with your partner on what he or she
thinks about watching these videos. This way, you'll able to
avoid causing offense or awkward situations that may lead to future miscommunications in your relationship.