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 密碼更改 | 豬窩 | 1270
Very nice post. I just stumbled upon your weblog and wanted to
say that I have really loved browsing your blog posts.
After all I will be subscribing to your feed and I'm hoping you write
once more soon!
mysql root 密碼更改 | 豬窩 | 1243
Excellent post however , I was wondering if you could write a litte more on this topic?
I'd be very thankful if you could elaborate a little bit further.
Thanks!
mysql root 密碼更改 | 豬窩 | 541
Akan kah lebih baik bermain Game Slot terus menerus meskipun kita tahu akan Mendapatkan kekalahan ?
Mungkin banyak di kalian yang merasa engakpuas karena telah mengalami kekalahan yang mengakibatkan anda ingin main kembali.
Kami juga tau yang kalian pikir kan adalah ingin main dan kembalikan kekalahan anda sebelum nya.
Bukan nya mau menentang anda akan tetapi jika anda ingin bermain lagi
setidak nya memiliki rencana anda sendiri. Atau anda memiliki tips atau strategi untuk bermain dan menang tanpa membuang uang
tenaga serta waktu anda. Di sini kita akan menjelaskan mengenai beberapa permasalahan permainan slot online yang telah di anggap buruk oleh masyarakat indonesia.
mysql root 密碼更改 | 豬窩 | 1222
You are so cool! I don't believe I have read through anything like that before.
So wonderful to find someone with unique thoughts on this subject matter.
Really.. thanks for starting this up. This web site is one thing that's needed on the
internet, someone with a bit of originality!
mysql root 密碼更改 | 豬窩 | 1226
This site was... how do you say it? Relevant!! Finally I have found
something that helped me. Many thanks!