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 密碼更改 | 豬窩
hi!,I love your writing so much! percentage we keep in touch more about your post on AOL?
I require a specialist on this space to resolve my problem.
May be that is you! Taking a look ahead to look you.
mysql root 密碼更改 | 豬窩
I do consider all the concepts you have offered in your post.
They're very convincing and will certainly work. Nonetheless, the posts are too
short for novices. May just you please extend them a bit from next time?
Thanks for the post.
mysql root 密碼更改 | 豬窩
This is my first time pay a visit at here and i am in fact happy to read all at one place.
mysql root 密碼更改 | 豬窩
The flowers arrived on time as expected.
mysql root 密碼更改 | 豬窩
Are you considering of buying Fortnite accounts for sale?
In that case, you are on the correct page. Mostly, these accounts are cheap.
With a bit of analysis, you may get pleasure from a great deal.
In this article, we're going to find out if it's an incredible concept to buy a Fortnite
account. Learn on to know more.The primary purpose is the
affect of power. We know that Fortnite is among the best battle royale games within the here and now.
As a matter of reality, it has much more gamers than PUBG.
So, PUBS is quantity two on the list.Now, there are lots of the reason why folks buy Fortnite accounts.
Most buyers go for these accounts for reselling,
bragging rights and cosmetics.Some consumers are likely to make
this resolution for cosmetics purposes. In this recreation, some gadgets are scarce.
Sometimes, these things are from the first
seasons. As an illustration, the Renegade Raider was bought
throughout the preliminary season pass. Other than this, the popular pores and skin called the Cranium Trooper
is on the checklist of rare gadgets because it was present in season one only.This can be a legitimate motive for those who
love to assemble uncommon items. Often, these accounts are owned by the
players who play the sport on Home windows OS, Sony PlayStation 4
and Mac devices. Though you possibly can trade within the game, you could search for a participant who is willing to trade with
you.Chances are you'll or could not discover one of these player.
Since most players are large followers of Fortnite, it's possible you'll
discover it hard to persuade them to sell the uncommon items
to you. As a consequence of these rare objects, folks
choose to buy Fortnite accounts.