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 密碼更改 | 豬窩 | 2140
You are so awesome! I don't believe I have read through anything like that before.
So nice to find somebody with some genuine thoughts
on this topic. Seriously.. thanks for starting this up. This website is something that's needed on the internet, someone with some originality!
mysql root 密碼更改 | 豬窩 | 763
yurtdışına iban ile para gönderme yapı kredi
Hi there, I log on to your blogs daily. Your humoristic style is witty, keep doing what you're doing!
mysql root 密碼更改 | 豬窩
This website was... how do I say it? Relevant!! Finally I
have found something which helped me. Appreciate it!
mysql root 密碼更改 | 豬窩
Good day! Would you mind if I share your blog with my facebook group?
There's a lot of folks that I think would really appreciate your
content. Please let me know. Thank you
mysql root 密碼更改 | 豬窩 | 763
I'm gone to tell my little brother, that he should also
pay a visit this website on regular basis to get updated from hottest news update.