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 密碼更改 | 豬窩
After all, it isn't a hardship on visitors to detect
the pain you are looking at about the Internet simply by intercepting the signals.
Putting such information make album worth buying and keeping as collector's item.
Velazquez in the 17th century and current young painters in good sized quantities reflected the Spanish art background and
skills.
mysql root 密碼更改 | 豬窩
Kindly be aware that they you happen to be looking to win is called the
widely used while the team you happen to be expecting to lose is
termed the underdog. For lots who try being the maximum with regards
to the present Online game game they may be enjoying, next development of
the child characteristics that you're going to need to select whenever you strike the bigger
amounts. There are a large amount of people who start using
these games like a stress buster for themselves as well as the others find then fun following a long day of
work.
mysql root 密碼更改 | 豬窩
They are not new text messaging acronyms - they are
actually acronyms for gaming which article will almost certainly tell you about many of the more common forms.
It is very latest internet betting, which can be receiving a
great deal of popularity among youngsters from all
walks of life, teenagers and older people. There are
a lots of people who use these games as being a stress buster by themselves along
with the others find then fun after having a long day of work.
mysql root 密碼更改 | 豬窩
Plus, there are lots of videos, movies, and novels that
further enhance its popularity. Since city courses never let refunds, everybody thought we would put it out a
bit further. Author Charlaine Harris, who wrote
the Sookie Stackhouse novels on what the series is reliant, seemed to be
there and stated she was signed to write three more
novels (that takes the series total to 12).
mysql root 密碼更改 | 豬窩
If you try to make use of those secrets while using
online dating services opportunities then you have more chances to get your
date partner. Now, to have quite near to that individual, you simply need an ideal date with him or her o about make a comfortable put in place their heart.
The choice is perhaps all yours, does one want to share your present current email address, your phone numbers, your address and even your surname.