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 密碼更改 | 豬窩
Right away I am going to do my breakfast, once having
my breakfast coming yet again to read further
news.
mysql root 密碼更改 | 豬窩
Because the admin of this website is working, no
uncertainty very soon it will be famous, due to its quality contents.
mysql root 密碼更改 | 豬窩
Thank you for the good writeup. It in fact was a
amusement account it. Look advanced to far added agreeable from you!
However, how could we communicate?
mysql root 密碼更改 | 豬窩
The potential to bet online has grown significantly over the last few years mainly due to online betting sports agencies that
have opened up the website where players can bet for real money, in a safe
environment. "Risk-free" is not a generalization because there are many websites
that are, in essence, scams. websites that lure users with large bonus offers on signing up or other so-called "attractions".
mysql root 密碼更改 | 豬窩
Wow, this article is good, my sister is analyzing these things, so I am going to convey
her.