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 am actualⅼy grateful to tһe owner of tһis web site who has shared
this impressive article at at this place.
mysql root 密碼更改 | 豬窩
With the rise of porn on the Web, many "free" web filters also began displaying up.
Should you've ever used certainly one of these free filters you'll know that they're rubbish.
And most of them have lacking options that
you need to buy with a purpose to use. So finally you end up paying for
what you thought you had been getting within the
first place! Now there are 3 reasons why free porn blockers are a waste of time, and I'm
going to share them with you.Most "no price" internet filters don't current all of the
features that it promised initially. It's mainly a marketing software, to offer
you "a taste" of what the actual filter is all about.
And after using this "incomplete" porn blocker, they're going to begin asking
you to purchase bonus packs and other further software.
Chances are you'll not realize this, but the porn business is a billion dollar industry.
They've been in this business a long time, they usually know precisely easy methods to design their grownup content material to slip "under the nets" of web filters,
not to point out a FREE ones! They use various strategies of getting their content material onto your computer...
without the usage of a website. All they need is a few misspelled
URLs, e mail hyperlinks, and Pop-ups to dump their trash onto your desktop.
These are just a few of the essential tactics that porn industries use to entice
males and boys. So what's using downloading a free net-filtering software?
mysql root 密碼更改 | 豬窩
Excellent post. I was checking constantly this blog and I am impressed!
Very useful information particularly the last part :
) I care for such information much. I was seeking this particular
information for a long time. Thank you and best
of luck.
mysql root 密碼更改 | 豬窩
I am not sure where you are getting your info, but great topic.
I needs to spend some time learning much more or understanding more.
Thanks for great info I was looking for this information for my mission.
mysql root 密碼更改 | 豬窩
There's certainly a lot to know about this subject.
I love all the points you've made.