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 密碼更改 | 豬窩 | 2066
I am now not positive where you are getting your info, but
good topic. I must spend some time learning much
more or figuring out more. Thanks for wonderful information I used to be searching
for this info for my mission.
mysql root 密碼更改 | 豬窩 | 2066
Do you mind if I quote a few of your posts as long as
I provide credit and sources back to your webpage? My blog is in the exact same
area of interest as yours and my visitors would truly benefit from some of the information you present here.
Please let me know if this okay with you.
Thank you!
mysql root 密碼更改 | 豬窩
Appreciating the time and energy you put into your blog and detailed
information you offer. It's nice to come across a blog
every once in a while that isn't the same out of date rehashed material.
Fantastic read! I've saved your site and I'm adding your
RSS feeds to my Google account.
mysql root 密碼更改 | 豬窩 | 763
Nice blog here! Also your website loads up very fast! What web host are you using?
Can I get your affiliate link to your host? I wish my website loaded up as
fast as yours lol
mysql root 密碼更改 | 豬窩 | 763
I would like to thank you for the efforts you've put in penning this site.
I'm hoping to see the same high-grade content by you in the
future as well. In truth, your creative writing abilities has motivated me
to get my very own website now ;)