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 密碼更改 | 豬窩 | 146
Heya i'm for the first time here. I found this board and
I find It truly useful & it helped me out a lot.
I hope to give something back and aid others like you helped me.
mysql root 密碼更改 | 豬窩 | 1338
Nice weblog right here! Additionally your site so much up
fast! What host are you the usage of? Can I get your associate link in your host?
I want my site loaded up as fast as yours lol
mysql root 密碼更改 | 豬窩 | 146
Ahaa, its pleasant dialogue about this article
at this place at this web site, I have read all that,
so at this time me also commenting here.
mysql root 密碼更改 | 豬窩 | 546
Its like you read my thoughts! You appear to know so much about this, like
you wrote the e-book in it or something.
I think that you simply could do with some p.c. to drive
the message house a bit, but other than that, that is great blog.
A fantastic read. I will definitely be back.
mysql root 密碼更改 | 豬窩
Can you tell us more about this? I'd like to find out some additional information.