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 密碼更改 | 豬窩
I used to be suggested this web site by means of my cousin. I'm now not positive whether or not this publish is written through him as no one else recognise such designated about my
problem. You are amazing! Thanks!
mysql root 密碼更改 | 豬窩
Hello, I enjoy reading through your article. I like to write a little comment to support you.
mysql root 密碼更改 | 豬窩
Hello my family member! I want to say that this post
is amazing, nice written and come with almost all significant infos.
I'd like to see extra posts like this .
mysql root 密碼更改 | 豬窩
Hi, I do believe this is a great site. I stumbledupon it ;) I am going to return yet again since i have saved as a favorite it.
Money and freedom is the best way to change,
may you be rich and continue to help others.
mysql root 密碼更改 | 豬窩
A fascinating discussion is definitely worth comment.
I think that you need to publish more on this issue,
it may not be a taboo subject but usually people do not speak about these topics.
To the next! Cheers!!