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 密碼更改 | 豬窩
It's genuinely very complicated in this active life to listen news on Television, therefore I
just use world wide web for that reason, and get the most recent news.
mysql root 密碼更改 | 豬窩
Hi there just wanted to give you a quick heads
up. The text in your post seem to be running off the screen in Safari.
I'm not sure if this is a format issue or something to
do with internet browser compatibility but I thought
I'd post to let you know. The design look great though!
Hope you get the issue fixed soon. Kudos
mysql root 密碼更改 | 豬窩 | 763
Cheap auto insurance coverage is actually excellent for students that need to save money.
There are actually special discount rates available if
you seem for them.
mysql root 密碼更改 | 豬窩
It's really very complex in this full of activity life to listen news on TV, therefore
I only use the web for that purpose, and take the hottest news.
mysql root 密碼更改 | 豬窩 | 1156
First of all I would like to say great blog!
I had a quick question which I'd like to ask if you don't mind.
I was interested to find out how you center yourself and clear your mind prior
to writing. I have had trouble clearing my mind in getting my ideas out.
I truly do enjoy writing however it just seems like the first 10 to 15
minutes tend to be lost simply just trying to figure out how to begin. Any
suggestions or tips? Thank you!