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 密碼更改 | 豬窩
I get pleasure from, lead to I found just what I used to be looking for.
You have ended my 4 day long hunt! God Bless you man. Have
a great day. Bye
mysql root 密碼更改 | 豬窩
You actually make it seem so easy with your presentation but I find this matter to be really something which I think I would never understand.
It seems too complicated and extremely broad for me.
I am looking forward for your next post, I will try to get the hang of it!
mysql root 密碼更改 | 豬窩
I was very happy to find this page. I want to to thank you for your
time due to this wonderful read!! I definitely appreciated
every bit of it and I have you saved to fav to look at new
stuff in your blog.
mysql root 密碼更改 | 豬窩
Greetings! Very useful advice in this particular article!
It's the little changes that will make the most significant changes.
Thanks a lot for sharing!
mysql root 密碼更改 | 豬窩
Just wish to say your article is as surprising.
The clarity in your post is simply excellent and that i can assume you're a professional
in this subject. Fine together with your permission allow me to grab your
feed to keep up to date with drawing close post.
Thank you 1,000,000 and please carry on the enjoyable work.