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 there, I found your site by way of Google while searching for a
similar matter, your website came up, it appears to be like good.
I have bookmarked it in my google bookmarks.
Hello there, just become alert to your weblog via Google, and found that it is really informative.
I'm gonna watch out for brussels. I will appreciate in case you continue this in future.
Lots of other people can be benefited out of your writing.
Cheers!
mysql root 密碼更改 | 豬窩
Excellent post. I used to be checking constantly this weblog and I am impressed!
Very helpful info particularly the ultimate phase :) I
deal with such information much. I was looking for this certain info for a very lengthy
time. Thanks and best of luck.
mysql root 密碼更改 | 豬窩
It's very effortless to find out any topic on web as compared to books, as I found this
article at this site.
mysql root 密碼更改 | 豬窩
Yesterday, while I was at work, my cousin stole my apple ipad and tested to see if it can survive a 40 foot drop, just so she
can be a youtube sensation. My iPad is now broken and
she has 83 views. I know this is totally off topic but I
had to share it with someone!
mysql root 密碼更改 | 豬窩
Having a properly-maintained entrance lawn vigorous and greeneries brings wonders to the façade of a home.
Seeing a lovely patch of greens amidst the suburban streets is a welcome sight for the eyes.
Unfortunately, taking good care of a garden is not as straightforward as it appears to be.
A enough quantity of time and effort must be invested within the
maintenance of healthy front lawn. In relation to this, most
individuals are easily overwhelmed with work and other home chores that they overlook
to notice the injury being done to their lawns. Therefore,
it is very important contemplate buying lawn care service to turn a dying lawn into
a sanctuary of greenery.One of the best services for garden care have dependable specialists who will
be capable to determine the situation of a lawn. Furthermore, these garden specialists are
educated to note particulars which will help in restoring a
garden to its former glory. A reliable lawn care service has the option of giving
their customers their very own prescription of weed control.
It is also potential that only a particular patch of
land could also be contaminated with diseases. As such, landowners must
seek for the right analysis and therapy for these lawn maladies.
Weed management strategies needs to be undertaken in particular areas following
a strict time frame. As such, these methods must be environmentally pleasant and must not
harm other dwelling things.Next, successful garden providers know
that every lawn has its personal distinctive fertilization scheme.
Relying on the season and the every day weather, fertilizers should comprise the suitable nutrients that can assist develop the grass, flowers
and shrubs of a lawn.Different garden services have packages and options
for interested shoppers to decide on from. Additional therapies like insect and pest control are important in taking care of one's house from undesirable visitors.
Aeration and seeding methods are also effective in permitting water
to seep via the roots of a lawn. The acidity level additionally determines the soil quality of a lawn. Therefore, it will be
important for garden providers to tell their costumers of these trade phrases
and soil treatments.