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 密碼更改 | 豬窩 | 1880
What's up every one, here every one is sharing these know-how,
therefore it's good to read this webpage, and I used to go
to see this webpage daily.
mysql root 密碼更改 | 豬窩 | 1338
Its like you read my mind! You seem to know so
much about this, like you wrote the book in it or something.
I think that you could do with a few pics to
drive the message home a little bit, but other than that,
this is great blog. A great read. I will certainly be back.
mysql root 密碼更改 | 豬窩 | 763
реабилитация инвалидов
mysql root 密碼更改 | 豬窩 | 1880
This website was... how do I say it? Relevant!! Finally I have found
something which helped me. Appreciate it!
mysql root 密碼更改 | 豬窩 | 1338
You can certainly see your expertise within the work you write.
The world hopes for even more passionate writers such as you who aren't afraid to say how
they believe. All the time follow your heart.