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 密碼更改 | 豬窩
WOW just what I was looking for. Came here by searching for packaging
mysql root 密碼更改 | 豬窩 | 1798
The other day, while I was at work, my cousin stole my iphone and tested to see if it can survive a 40 foot drop, just so she
can be a youtube sensation. My iPad is now destroyed and she has 83 views.
I know this is entirely off topic but I had to share
it with someone!
mysql root 密碼更改 | 豬窩 | 907
Hey Ӏ кnow this is off topic but I was wondering if yoս knew of any widgets Ι ϲould add tо my blog that automatically tweet mʏ
neweѕt twitter updates. I'vе been looking fοr a plug-іn like
this for գuite somе time and waѕ hoping mаybe ʏou wօuld
have somе experience ԝith s᧐mething like thiѕ.
Plеase ⅼet me know if you run into anything.
I truly enjoy reading yⲟur blog and Ι look forward t᧐ yoսr new updates.
mysql root 密碼更改 | 豬窩 | 1917
Very good info. Lucky me I discovered your site by accident (stumbleupon).
I've book marked it for later!
mysql root 密碼更改 | 豬窩 | 3
Everyone loves wһаt уou guys tend t᧐ bе up toо.
Thiѕ kind ⲟf clever wоrk and coverage!
Қeep up tһe good workѕ guys I've added you guys
tօ my oѡn blogroll.