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
I absolutely love your blog and find a lot of your post's
to be exactly I'm looking for. Would you offer guest writers
to write content in your case? I wouldn't mind producing a post or elaborating on many of the subjects you write concerning
here. Again, awesome web site!
mysql root 密碼更改 | 豬窩 | 1092
With havin so much content do you ever run into any problems of plagorism or copyright infringement?
My website has a lot of exclusive content I've either written myself
or outsourced but it appears a lot of it is popping it up all over the web without my agreement.
Do you know any solutions to help reduce content
from being ripped off? I'd definitely appreciate it.
mysql root 密碼更改 | 豬窩 | 1092
I got this web site from my pal who shared with me about this web site and
now this time I am visiting this site and reading very informative articles at this
place.
mysql root 密碼更改 | 豬窩 | 1092
If some one desires to be updated with most up-to-date technologies then he must be go to see this site and be up to date daily.