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 密碼更改 | 豬窩
Millions of visitors have been to Kuala Lumpur over the years.
It is a stunning city in the middle of Malaysia. While many foreigners go to Kuala Lumpur for recreational purposes, many others
visit for business purposes. Anyone who visits the city ought to know all the details regarding accommodation so that his stay his both relaxed and
peaceful. In this article, the most important aspects are discussed to help foreigners search for Kuala Lumpur apartments
for rent.Expatriates in Kuala Lumpur on work or leisure can have a hard to comprehend local property issues.
Anybody who doesn't have a deep understanding of the city
can find it difficult to strike an equilibrium between the rent and the location. If the latter is an issue
for you, then you ought to have more information about the areas that are well connected in the city.
The Golden Triangle is a great area to live in if willing to
pay more. This is the city's most commercial area, and there are many serviced apartments available.
mysql root 密碼更改 | 豬窩
Hey there! This is my first comment here so I just wanted
to give a quick shout out and tell you I really enjoy reading through your articles.
Can you recommend any other blogs/websites/forums that go over the same subjects?
Appreciate it!
mysql root 密碼更改 | 豬窩
I simply could not go away your site prior to suggesting that I really enjoyed the standard information a person supply on your guests?
Is going to be again frequently in order to check out new posts
mysql root 密碼更改 | 豬窩
Great delivery. Sound arguments. Keep up the great
work.
mysql root 密碼更改 | 豬窩
Thank you for another informative blog. Where else may just I am getting that type
of information written in such a perfect method? I have a challenge that I'm simply now working on, and I've
been at the glance out for such info.