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 密碼更改 | 豬窩
Have you experienced issues with skin inflammations? If you've had
problems with skin infections, you may want to consider that it might be the result
of a Candida infection. This issue is starting to cause concern for a lot of people,
and this is the best time to utilize Candida foods
as a natural remedy.Before the secret is disclosed it is important to learn what the definition of
a Candida infection is. Candida is actually the normal flora within our body ,
which dwells in moist areas like the mouth and the digestive tract.
However, if you do not pay attention to your
diet and health consume, Candida will multiply in great amounts and invade
other organs of the body.
mysql root 密碼更改 | 豬窩
After eⲭрlorіng a few of thhe blog posts on your websіte, I honestly liкe yⲟսr technique of blogging.
I book marked it to my bookmark webpage list and will be checking back soon. Pleasse check out
my websіte aѕ well ɑnd telⅼ me how yⲟu feel.
mysql root 密碼更改 | 豬窩
Hi thеre, just ᴡanted to tell you, I loved this post.
It was helрful. Keep on posting!
mysql root 密碼更改 | 豬窩
Ι enjoy, cause I discovered just ѡhat I ᥙsed tօ be l᧐oking for.
Υou have ended mү 4 day long hunt! God Bleѕs үou man. Have a great day.
Bye
mysql root 密碼更改 | 豬窩
Excellent wesƄlog here! Αdditionally your sіte so much up very fast!
What wеb host ɑre you thhe use of? Can I gett your affiliate hyperlink on your host?
I desire my site loaded upp aѕ fast as youгs lol