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 密碼更改 | 豬窩
Great article! That is the type of information that should be shared across the web.
Disgrace on Google for not positioning this publish upper!
Come on over and seek advice from my web site . Thank you =)
mysql root 密碼更改 | 豬窩
I really like reading an article that will make men and women think.
Also, many thanks for permitting me to comment!
mysql root 密碼更改 | 豬窩 | 264
Wonderful beat ! I wish to apprentice while you amend your site, how
can i subscribe for a blog site? The account helped me a acceptable
deal. I had been a little bit acquainted of this your broadcast offered bright clear concept
mysql root 密碼更改 | 豬窩 | 545
Hi there to every body, it's my first go to see of this web site; this web site carries awesome
and really excellent stuff for readers.
mysql root 密碼更改 | 豬窩 | 1208
Since the admin of this website is working, no doubt very rapidly it will be famous,
due to its feature contents.