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 密碼更改 | 豬窩 | 174
I used to be able to find good advice from your blog
articles.
mysql root 密碼更改 | 豬窩
If you are going for best contents like myself, just visit this web page all the
time because it provides quality contents,
thanks
mysql root 密碼更改 | 豬窩
I wanted to follow up and allow you to know how really I
treasured discovering your blog today. I'd consider it
a honor to operate at my company and be able to operate on the tips shared
on your website and also be involved in visitors' remarks like this.
Should a position connected with guest article author become on offer at your end,
i highly recommend you let me know.
mysql root 密碼更改 | 豬窩
I feel this is one of the so much vital information for me.
And i'm satisfied reading your article. However want to remark on some general things, The site taste is great, the articles is actually nice
:D. Just right job, cheers.
mysql root 密碼更改 | 豬窩
Hiya! Quick question that's entirely off topic. Do you know how to make your
site mobile friendly? My site looks weird when viewing from my iphone 4.
I'm trying to find a theme or plugin that might be able
to fix this problem. If you have any suggestions, please
share. Cheers!