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 密碼更改 | 豬窩
Once you have the list of all of the companies in your town offering
video production services, you will need to start checking what they've
to offer. With these show tunes, the lyrics with the songs are general yet they
still fit in the entire narrative in the production. This
innovative software lets you hear your own voice
whilst you sing and reveals your true ability as a vocalist.
mysql root 密碼更改 | 豬窩
I constantly spent my half an hour to read this web site's posts everyday along with a cup
of coffee.
mysql root 密碼更改 | 豬窩
With more advancement, high technology based cameras were introduced in the area of photography.
I recognize few other human science that could
make this happen so thoroughly, so consistently, so accurately, with such logic to its information. After locating the ring using a
fiber optic camera the restaurant opted for let a
plumbing and excavating company jackhammer the bottom to arrive at the ring deep in the sewer.
mysql root 密碼更改 | 豬窩
Males can find the female of their choice without difficulty through
free dating sites. These scammers usually simply have one picture within their profile, thus it may
be the norm for many experienced those who date online to think
that one picture profiles don't show the true person.
Once they are successful inside their career and accomplish
what they have to want, they realize the value of marriage.
mysql root 密碼更改 | 豬窩
Of course, in the event you go with a free site, you can have a lot more than social contact
based upon your mood and also the friends you make on each site.
There are a couple of Americans who believe Inter racial relationships needs to be
banned since it destroys the cultures of two races plus brings problem on their
siblings. You have complete control that you want to get hold of and that you wish
to block from.