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 密碼更改 | 豬窩 | 523
Howdy! This is my first comment here so I just wanted to give a quick shout out and tell you I
truly enjoy reading your articles. Can you suggest any other blogs/websites/forums that cover the same topics?
Thanks for your time!
mysql root 密碼更改 | 豬窩 | 505
Greate pieces. Keep writing such kind of info on your page.
Im really impressed by it.
Hey there, You've performed an incredible job. I'll definitely digg it and individually recommend
to my friends. I'm sure they'll be benefited from this
website.
mysql root 密碼更改 | 豬窩 | 523
hello!,I like your writing very so much! proportion we
keep up a correspondence extra approximately your post on AOL?
I require an expert on this house to solve my problem.
May be that is you! Having a look ahead to peer you.
mysql root 密碼更改 | 豬窩 | 523
Heya i am for the first time here. I found this board and
I find It truly useful & it helped me out much. I hope
to give something back and aid others like you helped me.
mysql root 密碼更改 | 豬窩
I simply couldn't go away your website before
suggesting that I really enjoyed the usual
information an individual provide in your guests? Is gonna
be back often to check up on new posts