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 密碼更改 | 豬窩
This info is priceless. When can I find out more?
mysql root 密碼更改 | 豬窩 | 788
Fantastic goods from you, man. I've take into account your stuff prior to and
you are just extremely magnificent. I actually like what you have acquired
here, certainly like what you are stating and the best way in which you
say it. You make it entertaining and you still take care of to stay it smart.
I can't wait to read far more from you. That is actually
a tremendous site.
mysql root 密碼更改 | 豬窩
Way cool! Some extremely valid points! I appreciate you writing this write-up plus the
rest of the site is extremely good.
mysql root 密碼更改 | 豬窩 | 1295
Pretty nice post. I just stumbled upon your weblog and wished to say
that I have really enjoyed surfing around your weblog posts.
After all I will be subscribing on your rss feed
and I hope you write again very soon!
mysql root 密碼更改 | 豬窩 | 1295
Wow that was strange. I just wrote an incredibly long comment but after I clicked submit my
comment didn't show up. Grrrr... well I'm not
writing all that over again. Anyways, just wanted to say superb blog!