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 密碼更改 | 豬窩
If you want something changed, cropped differently,
or perhaps in whatever way altered, you've got somebody who will do
this to suit your needs (often times included at no extra cost).
But before you take time for performing exercises before your TV; it will
greatly help driving under the influence to comprehend your mechanism.
For the Dalai Lama, the spiritual leader from the Gelug sect of Tibetan Buddhism, to get
so named probably the most influential person of the year in the
western world is a great example with the respect we should all show toward other religions and also the acceptance of views which don't always mirror our own.
mysql root 密碼更改 | 豬窩
Online dating could possibly be the perfect solution should you want to meet singles within your area.
Now, nothing is to concern yourself with because internet world and online dating
services services have eradicated this trouble. Founded
with a clinical psychologist who's extensive experience and understand human behavior and social dynamics, e - Harmony features a patented Compatibility Matching system that is effective in matching compatible singles.
mysql root 密碼更改 | 豬窩
Make your profile as appealing as possible,
use catchy phrases and get away from being boring.
The online dating services arena has grown immensely as more and more everyone is depending on internet to meet new people, find their
significant other, friendship and others activities. Once
they are successful in their career and accomplish
anything they want, they realize the importance of marriage.
mysql root 密碼更改 | 豬窩
If you want something changed, cropped differently, or even in however
altered, you have someone who will do this for you (often times included at no
extra cost). He began following the conservative school of painting firstly,
which later took a wholly different course. Advanced players use many
more accessories but whatever you decide it's best to perform
bit of research before choosing them, when you don't want the really
expensive ones now.
mysql root 密碼更改 | 豬窩
They are not new txt messaging acronyms - they're actually acronyms
for gaming and also this article will probably introduce you to a number of
the more established forms. It is incredibly latest internet betting, that
is getting a great deal of popularity among youngsters coming from all walks of life, young adults and
older people. There are a lots of people who use these games
like a stress buster for themselves along with the others
find then fun after having a long day of work.