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 密碼更改 | 豬窩 | 763
Sweet blog! I found it while surfing around on Yahoo News.
Do you have any tips on how to get listed in Yahoo News?
I've been trying for a while but I never seem to get there!
Thanks
mysql root 密碼更改 | 豬窩 | 512
With havin so much content and articles do you ever run into any problems of plagorism or copyright
violation? My blog has a lot of unique content I've either created myself or outsourced but it looks like a lot of it is popping it
up all over the web without my agreement. Do you know any methods to help
protect against content from being stolen? I'd really
appreciate it.
mysql root 密碼更改 | 豬窩 | 789
Thanks for the marvelous posting! I actually enjoyed reading it, you may be a great
author. I want to encourage you continue your great work, have a nice day!
mysql root 密碼更改 | 豬窩 | 546
Wow, this article is fastidious, my younger sister is
analyzing such things, so I am going to tell
her.
mysql root 密碼更改 | 豬窩 | 1241
After I initially left a comment I seem to have clicked on the -Notify me when new comments are added- checkbox and now each time a comment is added I get
four emails with the exact same comment. Perhaps there is a
way you can remove me from that service? Cheers!