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 密碼更改 | 豬窩 | 1216
It's very effortless to find out any matter on web as compared to textbooks, as I found this post at this site.
mysql root 密碼更改 | 豬窩 | 1338
Generally I do not read post on blogs, but I
wish to say that this write-up very pressured me to take
a look at and do so! Your writing taste has been amazed me.
Thank you, quite nice post.
mysql root 密碼更改 | 豬窩 | 1295
I am sure this post has touched all the internet users, its
really really good post on building up new weblog.
mysql root 密碼更改 | 豬窩 | 1272
Simply want to say your article is as astonishing.
The clearness on your submit is simply excellent and i can suppose
you're an expert on this subject. Well along with your permission let me to take hold of your feed to keep up
to date with drawing close post. Thank you a million and please
keep up the enjoyable work.
mysql root 密碼更改 | 豬窩 | 1333
Article writing is also a excitement, if you be familiar with
after that you can write otherwise it is complicated
to write.