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 密碼更改 | 豬窩
Many individuals decide to position their sports activities bets with
online betting companies quite than traditional betting centers.
It is much more convenient to position your bets online. The only drawback with on-line betting
is that there are such a lot of on-line betting companies.
Trying to find the perfect sports activities betting websites can be quite a process and
this guide will provide help to discover one that's greatest for you.Betting sites
will normally have a target market that they prefer. Some desire bettors within the
UK, others within the US and others from Australia or other countries.
It's best to do a seek for an inventory of betting firms that favor bettors from
an space that you are in.After getting an inventory of sites, then you have to to check the popularity of that site.
You do not want to end up going with a web site that will abruptly disappear or take time to
course of any withdrawals. Checking the popularity of a website is
as straightforward as searching for opinions
of that site or going to betting boards and discovering
out what persons are saying in regards to the website
you may have in mind.Many sports betting websites have different provides to their members.
Normally members are given additional advantages.
Gives might be free bets, additional quantities entered
into your account, and plenty of other offers.
It's good to check the presents that different sites have.There are two forms of online betting companies.
There are companies the place members can wager
towards every other. These corporations are called betting exchanges.
The percentages given by these sites are higher than the percentages given by traditional betting sites.
They may even have side bets on the games.
However don't let this distract you. The standard betting companies could have greater odds however they may even have more forms of bets which you can place.
The type of betting technique you have got will guide you on what type of betting web site you will possible go with.
mysql root 密碼更改 | 豬窩
A person necessarily help to make critically posts I might state.
That is the first time I frequented your web page and up
to now? I amazed with the analysis you made to create this actual post amazing.
Excellent task!
mysql root 密碼更改 | 豬窩
Hurrah! At last I got a weblog from where I be capable of actually obtain useful data regarding my study and knowledge.
mysql root 密碼更改 | 豬窩
Hi, i think that i saw you visited my site thus i came to ?return the favor?.I am attempting to find things to enhance my web
site!I suppose its ok to use a few of your ideas!!
mysql root 密碼更改 | 豬窩
As I website owner I conceive the subject matter here is rattling good,
thank you for your efforts.