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 密碼更改 | 豬窩 | 146
Howdy! I know this is kinda off topic however I'd figured I'd
ask. Would you be interested in trading links or maybe guest authoring a blog post or vice-versa?
My site discusses a lot of the same subjects as yours and I feel we could greatly benefit from each other.
If you're interested feel free to send me an email. I look forward to hearing from
you! Fantastic blog by the way!
mysql root 密碼更改 | 豬窩 | 1209
Link exchange is nothing else however it is just placing the other person's
weblog link on your page at proper place and other person will
also do similar in support of you.
mysql root 密碼更改 | 豬窩 | 1209
Hello There. I found your blog the use of msn. That is a very neatly written article.
I will be sure to bookmark it and return to
learn more of your useful information. Thanks for the post.
I'll definitely comeback.
mysql root 密碼更改 | 豬窩 | 174
It's truly very complex in this full of activity life to listen news
on Television, therefore I only use the web for that
reason, and obtain the most recent information.
mysql root 密碼更改 | 豬窩 | 907
Howdy! Do you know if they make any plugins to protect against hackers?
I'm kinda paranoid about losing everything I've worked hard on. Any tips?