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 密碼更改 | 豬窩 | 1092
Incredible points. Outstanding arguments. Keep up the good work.
mysql root 密碼更改 | 豬窩
First off I would like to say superb blog! I had a quick question in which I'd
like to ask if you do not mind. I was interested to know how you center yourself and
clear your thoughts prior to writing. I have had trouble clearing my thoughts in getting my ideas out there.
I do enjoy writing however it just seems like the first 10 to 15 minutes are generally wasted
just trying to figure out how to begin. Any recommendations or hints?
Kudos!
mysql root 密碼更改 | 豬窩
I love your blog.. very nice colors & theme. Did you create this website yourself or did you hire someone to do it for you?
Plz respond as I'm looking to construct my own blog and would like to
know where u got this from. thanks
mysql root 密碼更改 | 豬窩 | 763
Asking questions are actually nice thing if you are not understanding anything fully, but this piece of writing gives
nice understanding even.
mysql root 密碼更改 | 豬窩 | 1092
I'm gone to inform my little brother, that he should
also pay a quick visit this web site on regular basis to obtain updated from
newest information.