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 密碼更改 | 豬窩 | 1163
We are a bunch of volunteers and starting a new scheme in our community.
Your site provided us with useful info to work on. You have
performed an impressive job and our entire neighborhood might be grateful to you.
mysql root 密碼更改 | 豬窩 | 583
On the tail finish of the 1960s into the ’70s, the former members of
Cream went on to establish other supergroups resembling Blind Religion and Derek and the Dominos, and Cream’s fashion drastically
influenced progressive rock acts akin to Rush and the live
"jam band" performances of teams such because the Allman Brothers
Band. Clapton’s model as a guitarist had lengthy been influenced by Chicago and Delta bluesmen such as B.B.
Ask these girls which creams labored for them and which didn’t work.
Veet - My guess is that almost all girls have heard of Veet by now.
Area Shuttle and Worldwide Space Station astronauts have also taken regular ice cream
into the area station. Since Ben couldn't taste
or odor, he had to rely on the mouthfeel, which means that you've him
to thank for all the chunks and ooey-gooey additions to Ben & Jerry's ice cream.
When you have oily pores and skin then it for optimistic that
the texture of your skin will certainly be dissimilar from the individual
by having the dry pores and skin and therefore you require to utilize
a gentle face cream that can simply stop the manifestation of oil out of your pores and skin. The
primary purpose of the manufacturing of such creams is to make the skin easy however they'll simply
even be incredibly helpful within the eliminating of make-up.
mysql root 密碼更改 | 豬窩
Very nice post. I just stumbled upon your blog
and wanted to say that I have truly enjoyed surfing around your blog posts.
After all I will be subscribing to your rss feed and I
hope you write again soon!
mysql root 密碼更改 | 豬窩
Have you ever earned $765 just within 5 minutes?
trade binary options
mysql root 密碼更改 | 豬窩 | 228
Hello to every body, it's my first pay a quick visit
of this web site; this webpage carries remarkable and truly good information in favor of visitors.