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 密碼更改 | 豬窩 | 1092
This is really interesting, You're a very skilled blogger.
I've joined your rss feed and look forward to seeking more
of your fantastic post. Also, I've shared your web site in my social networks!
mysql root 密碼更改 | 豬窩 | 2066
I wanted to thank you for this good read!! I absolutely enjoyed every
little bit of it. I've got you book marked to check out new stuff you post…
mysql root 密碼更改 | 豬窩 | 2066
I've been surfing online more than 4 hours today, yet I never found any
attention-grabbing article like yours. It is appropriate time to make some plans for the future
and it's time to be happy.
I have been surfing online greater than 3 hours with
this. Ahaa, its good discussion about this article at this place
at this webpage.
Very well written! I will right away grasp your rss as well.
I'd like to look at more posts like this.
It's appropriate time to make a few plans for the long run and it is time to be happy.
I have read this article and if I might I want to recommend you few attention-grabbing things or suggestions.
It's actually a wonderful and helpful piece of info. I am satisfied that you shared this useful information with us.
Please keep us informed like this. Thanks for sharing.
mysql root 密碼更改 | 豬窩 | 1092
Appreciate this post. Let me try it out.
mysql root 密碼更改 | 豬窩 | 2066
I like the helpful information you supply for your articles.
I will bookmark your weblog and test again right here frequently.
I'm relatively certain I'll learn lots of
new stuff proper right here! Best of luck for the
following!