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 密碼更改 | 豬窩 | 534
hello there and thank you for your info – I have certainly picked up something
new from right here. I did however expertise some technical points using this website, since I experienced
to reload the website a lot of times previous to I could
get it to load correctly. I had been wondering if your web hosting is OK?
Not that I am complaining, but slow loading instances
times will sometimes affect your placement in google and can damage your high quality score if ads
and marketing with Adwords. Anyway I am adding
this RSS to my e-mail and can look out for a lot
more of your respective fascinating content.
Ensure that you update this again soon.
mysql root 密碼更改 | 豬窩 | 789
I blog frequently and I truly thank you for your information. The
article has truly peaked my interest. I will take a
note of your site and keep checking for new details about once
a week. I subscribed to your RSS feed too.
mysql root 密碼更改 | 豬窩 | 1223
I'm amazed, I have to admit. Seldom do I come across a blog that's equally educative and
amusing, and without a doubt, you have hit the nail on the
head. The issue is something not enough folks are speaking intelligently
about. I'm very happy I found this during my search for
something relating to this.
mysql root 密碼更改 | 豬窩 | 699
It's actually a great and useful piece of information. I'm happy that you simply shared this useful info with us.
Please stay us informed like this. Thank you for
sharing.
mysql root 密碼更改 | 豬窩 | 1223
I really like your blog.. very nice colors & theme. Did you design this website yourself or did you hire someone
to do it for you? Plz answer back as I'm
looking to design my own blog and would like to find out where u got this from.
cheers