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 密碼更改 | 豬窩
I’m not that much of a internet reader to be honest but your sites really nice, keep
it up! I'll go ahead and bookmark your site to come back down the road.
All the best
mysql root 密碼更改 | 豬窩 | 534
Hello there! This is my first comment here so I just
wanted to give a quick shout out and tell you I really enjoy
reading your posts. Can you recommend any other blogs/websites/forums
that deal with the same topics? Thanks a ton!
mysql root 密碼更改 | 豬窩
To begin with, congratses on this message.
This is actually truly remarkable but that's why you consistently crank out my close friend.
Wonderful posts that our company can drain our
teeth in to as well as actually head to function.
I like this weblog article as well as you know you're. Due to
the fact that there is actually therefore much entailed however its like anything else, blogging can easily be really mind-boggling for a whole lot
of people. Every thing takes a while as well as most of us have the very same amount of hrs in a day
so put them to great make use of. Most of us must start
somewhere and also your strategy is best.
Terrific portion and thanks for the mention listed
below, wow ... Exactly how great is actually that.
Off to share this article right now, I prefer all those brand new bloggers
to find that if they do not actually possess a strategy 10 they do right now.
mysql root 密碼更改 | 豬窩 | 789
magnificent submit, very informative. I'm wondering why the opposite specialists of
this sector do not realize this. You must continue your writing.
I'm confident, you have a huge readers' base already!
mysql root 密碼更改 | 豬窩 | 534
hey there and thank you for your info – I've certainly
picked up anything new from right here. I did however expertise some technical issues using this web site,
as I experienced to reload the website many times previous to I could
get it to load properly. I had been wondering if your web host is OK?
Not that I'm complaining, but sluggish loading instances times will very
frequently affect your placement in google and could damage your high-quality score if ads and marketing with Adwords.
Anyway I'm adding this RSS to my email and could look
out for a lot more of your respective intriguing content.
Make sure you update this again soon.