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 密碼更改 | 豬窩 | 1241
Hello there, I discovered your blog by means of Google
at the same time as looking for a related subject, your web site got here up,
it appears great. I've bookmarked it in my google bookmarks.
Hello there, just was alert to your blog thru Google, and located that
it is truly informative. I am gonna be careful for brussels.
I will be grateful when you proceed this in future. A lot of people can be benefited out of your writing.
Cheers!
mysql root 密碼更改 | 豬窩 | 1272
Hello there, I do think your website may be having
browser compatibility problems. When I look at your web site
in Safari, it looks fine but when opening in I.E., it has some overlapping issues.
I simply wanted to provide you with a quick heads up!
Besides that, wonderful website!
mysql root 密碼更改 | 豬窩 | 546
Hi there Dear, are you genuinely visiting this web page daily, if so after that you will
without doubt get fastidious experience.
mysql root 密碼更改 | 豬窩 | 1340
I'm truly enjoying the design and layout of your blog. It's a very easy on the eyes which makes it much more enjoyable
for me to come here and visit more often. Did
you hire out a designer to create your theme? Excellent work!
mysql root 密碼更改 | 豬窩 | 524
I was very happy to uncover this web site. I wanted to thank
you for your time due to this wonderful read!! I definitely
really liked every part of it and i also have you
bookmarked to look at new stuff in your site.