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 密碼更改 | 豬窩
Some Russian women are recognized for their promiscuity, just as Russian men are recognized for drinking.
If you would like to distinguish a great agency from one that is fake the English suited for the website is easily understandable and
contains few grammatical mistakes. But they are not always welcomed in to
the lucrative professional jobs they are suited for.
mysql root 密碼更改 | 豬窩
Finding a doozy is like playing a slot machine where the itrrrs likely that tilted so that you can lose.
You may have to email several dozen when long maybe you have a storm of replies
stating that "Yes" they certainly need a husband.
Before the Internet, men from the United States met Filipino women through picture personals companies.
mysql root 密碼更改 | 豬窩
Manufacturers also don't need to register using the FDA, in support of must tell them with their intent to market a brand
new supplement if the supplement contains a 'new' ingredient that is just not currently available
and accepted inside food supply in other forms. None of these things
have a food label so stick to them and cook them from scratch.
Often we all know more about what is going on in New York then we all
know what is happening inside our neighbors' lives next door.
mysql root 密碼更改 | 豬窩
Don't worry about stopping and starting, just
execute a regular masturbation. All live their lives the best they can within their community: work and play are a similar, in accordance with each person's interests; friendships are the identical, taking into account that many people can be prejudiced against Gay people among others merely cautious; Gay folks
have pets, interests, jobs, cars, a home and family a similar as almost every other people.
For centuries, we've got had the opportunity to transform
the appearance of our own bodies with aesthetic surgery.
mysql root 密碼更改 | 豬窩
My coder is trying to persuade me to move to .net from PHP.
I have always disliked the idea because of the costs.
But he's tryiong none the less. I've been using WordPress on a variety of websites
for about a year and am worried about switching to another platform.
I have heard good things about blogengine.net. Is there a way I can import all my wordpress content into it?
Any kind of help would be greatly appreciated!