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 密碼更改 | 豬窩
I got this web site from my friend who shared with me concerning this website and att
the moment thijs time I am browsing this site and reading very informative
posts at this time.
mysql root 密碼更改 | 豬窩
Thankfulness to my father who stated to me on the topic of this weblog, this web
site is truly awesome.
mysql root 密碼更改 | 豬窩
Thanks to my father who shared with me concerning this website, this
blog is truly awesome.
mysql root 密碼更改 | 豬窩
Pet Wellness encompasses many aspects of a healthy, happy
pet. To celebrate Stress Awareness Month and the stress-free lifestyle, you should learn how to spot and remove stress for your
pet so they will live a healthier and longer life. Are you surprised to read that animals
have stress? Stress affects our dogs and cats and various type pets in all kinds.
Stress in pets is similar to stress in humans.
It can result in illnesses, poor quality of life, depression, and decreases
the length of life. In these instances, and many other reasons,
it's important that pet owners practice another part of pet wellness which is finding out whether your pet is stressed, identifying the stress factors and
implementing the appropriate techniques to eliminate the
stress and increase the quality of their pet's life.Many signs of
stress in your pet may also be indicators of other
problems so do not think that it's stress. You need to investigate the options available
to you to help your pet. This can save you and your pet from health issues in the future
and costly vet expenses. Pets that itch more often than normal can be an indication of stress.
Eliminate the possibility of lice, ticks, and allergy first, and then think about whether it might
be that your pet is suffering from stress. There are many natural solutions for
pet allergies that can be applied at home. Treating itching and discomfort from allergies and removing the allergy source can also prevent your pet from being anxiety resulting from constant itching.
mysql root 密碼更改 | 豬窩
I am really grateful to the holder of this web page who has shared this enormous paragraph at at this place.