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 密碼更改 | 豬窩
Ваш метод повествования всего этого
в этой вырезке - это искренне хорошо, все могут просто осознать это, спасибо.
mysql root 密碼更改 | 豬窩
Мне нравится такие группы которыесобираются и делятся своими мнениями.
Отличный вебсайт, развивайтесь в том же духе!
mysql root 密碼更改 | 豬窩
Amman Arab university circles is a Jordanian teacher institute of well along education, located on Jordan Street, Mubis-Amman. Amman Arab college circles (AAU) was founded in 1997 below the
well along Education Council No. (1476) upon 24/11/1997 as a non-profit private academe
specialized in graduate studies below the pronounce Amman Arab
university for Graduate Studies, and thereby became the first academe in Jordan that offers graduate
programs leading to Master's Degrees, and Doctoral Degrees.
on 30/9/1998 the far along Education Council gave
attain for the academic world to start enthusiastic in the manner of the unchangeable No.
(1625). Academic operation started in the dawn of the Second Semester
of the academic year 1999/2000. One of Jordanian Private Universites
mysql root 密碼更改 | 豬窩 | 817
When I originally commented I seem to have clicked
the -Notify me when new comments are added- checkbox and now each time a
comment is added I receive four emails with the exact same comment.
There has to be a way you are able to remove me from
that service? Cheers!
mysql root 密碼更改 | 豬窩 | 785
Hello there, I discovered your site by the use of Google whilst
looking for a similar topic, your site came up, it looks great.
I have bookmarked it in my google bookmarks.
Hi there, just became alert to your blog thru Google,
and located that it's really informative. I'm gonna be careful for brussels.
I'll be grateful if you happen to continue this {in future}.
A lot of other people shall be benefited out of your writing.
Cheers!