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 密碼更改 | 豬窩
Do you mind if I quote a couple of your articles as long as
I provide credit and sources back to your blog? My blog is
in the exact same area of interest as yours and my users would really benefit from a lot of the information you
provide here. Please let me know if this alright
with you. Thanks!
mysql root 密碼更改 | 豬窩
What's up to every , as I am genuinely eager of reading this website's post to be updated daily.
It contains fastidious material.
mysql root 密碼更改 | 豬窩
I have been exploring for a little for any high-quality articles or blog posts in this kind of house .
Exploring in Yahoo I ultimately stumbled upon this site.
Studying this information So i'm glad to show that I've an incredibly
good uncanny feeling I discovered exactly what I needed.
I such a lot without a doubt will make sure to don?t omit this web
site and give it a look regularly.
mysql root 密碼更改 | 豬窩
Hi friends, its impressive paragraph about teachingand completely defined,
keep it up all the time.
mysql root 密碼更改 | 豬窩
Hello there, I found your blog by means of Google
while searching for a related topic, your web site came
up, it seems to be good. I have bookmarked it in my google bookmarks.
Hi there, simply become aware of your blog thru Google, and found that it's truly informative.
I am going to be careful for brussels. I will appreciate
in the event you continue this in future. Lots of
other folks will likely be benefited out of your writing.
Cheers!