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 密碼更改 | 豬窩 | 907
I am sure this paragraph has touched all the internet visitors, its really really pleasant article on building up new
blog.
mysql root 密碼更改 | 豬窩 | 907
Hi, I log on to your new stuff regularly. Your writing style is awesome, keep
it up!
mysql root 密碼更改 | 豬窩 | 907
Hi! I'm at work surfing around your blog from my new iphone 3gs!
Just wanted to say I love reading through your blog and look forward to all your posts!
Carry on the superb work!
mysql root 密碼更改 | 豬窩 | 1335
Itts liike you rread my mind! Yoou srem to know so muh about this, like you
wrote thhe book in it orr something. I think tuat you
could do wijth some pics to drivve the messate home a bit, but other than that, this is wonderful blog.
An excellent read. I will certainly be back.
mysql root 密碼更改 | 豬窩 | 907
fantastic publish, very informative. I'm wondering why the opposite experts of this
sector don't notice this. You should proceed your writing.
I am confident, you've a great readers' base already!