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 密碼更改 | 豬窩 | 1272
At this time I am going away to do my breakfast, after
having my breakfast coming again to read other news.
mysql root 密碼更改 | 豬窩
Amman Arab university is a Jordanian moot institute of innovative education, located on Jordan Street, Mubis-Amman. Amman Arab university
circles (AAU) was founded in 1997 under the complex Education Council
No. (1476) on 24/11/1997 as a non-profit private academic world specialized in graduate studies under the declare Amman Arab academic world for Graduate Studies, and thereby
became the first university in Jordan that offers graduate
programs leading to Master's Degrees, and Doctoral Degrees.
upon 30/9/1998 the innovative Education Council gave allow for the university
circles to begin keen like the supreme No. (1625).
Academic operation started in the coming on of the Second
Semester of the academic year 1999/2000. One of Jordanian Private Universites
mysql root 密碼更改 | 豬窩 | 1338
magnificent points altogether, you simply gained a new reader.
What may you recommend in regards to your submit that you simply
made some days in the past? Any sure?
mysql root 密碼更改 | 豬窩 | 1216
Admiring the time and effort you put into your site and detailed information you present.
It's good to come across a blog every once in a while that isn't the same unwanted rehashed information. Wonderful
read! I've saved your site and I'm including your RSS feeds to my Google
account.
mysql root 密碼更改 | 豬窩 | 1216
I really love your site.. Very nice colors & theme.
Did you build this site yourself? Please reply back as I'm hoping
to create my own personal website and would like to know where
you got this from or just what the theme
is named. Thanks!