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 密碼更改 | 豬窩
An impressive share! I've just forwarded this onto a colleague who
was conducting a little research on this. And he actually ordered me breakfast due to the fact that I found it for him...
lol. So allow me to reword this.... Thanks for the meal!!
But yeah, thanx for spending some time to talk about this topic here
on your website.
mysql root 密碼更改 | 豬窩
What's up to all, as I am truly eager of reading this web site's post to be
updated regularly. It contains nice stuff.
mysql root 密碼更改 | 豬窩
Way cool! Some extremely valid points! I appreciate you
writing this write-up plus the rest of the site is very good.
mysql root 密碼更改 | 豬窩
It's appropriate time to make a few plans for the future and it's time
to be happy. I've learn this submit and if I could
I want to recommend you few interesting things or suggestions.
Perhaps you could write next articles regarding this
article. I want to learn even more issues about it!
mysql root 密碼更改 | 豬窩
Awesome site you have here but I was wondering if you knew of
any user discussion forums that cover the
same topics discussed here? I'd really love to be a part of group where I can get
feed-back from other knowledgeable individuals that share the same interest.
If you have any recommendations, please let me know.
Thank you!