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 密碼更改 | 豬窩
Hello There. I found your weblog the usage of msn. This is a very
well written article. I will make sure to bookmark it and return to
learn extra of your useful information. Thanks
for the post. I will definitely comeback.
mysql root 密碼更改 | 豬窩
Hi my loved one! I wish to say that this post is awesome, great
written and come with approximately all significant infos.
I would like to look more posts like this .
mysql root 密碼更改 | 豬窩
Hello there, just became alert to your blog through Google, and found that
it is truly informative. I am going to watch out for brussels.
I will appreciate if you continue this in future. Many people will be benefited from your writing.
Cheers!
mysql root 密碼更改 | 豬窩
Football clubs often become legendary. Players dream to put on uniforms of
their favorite squad. Number of fans increasing inexorably.
Leading teams support in home country and rest of
the world. Games collect millions of spectators. Introduce popular clubs from different regions of the planet.
Juventus
"Old Signora" .
Worth report additional fact. In the early 1990s Manchester United founded the English Premier League.
Best period came job Alex Ferguson. Club managed to win many famous awards.
While about the past glory remains only remembering. But Red Devils still could show good play.
"Star of the South"
Composition first originated in 1900. During time existence "Bayern" won nickname most
titled team FRG. Total about 60 major achievements.
Currently fame came early 2010s. Squad demonstrated excellent football.
Star of the South strengthened in the first positions in the Bundesliga.
Football players managed achieve excellent results at continental
tournaments.
Roster often helped other teams and ordinary people.
Several times Bavaria supported Munich 1860. Functional performed various methods support:
• profitable transitions;
• friendly games;
• direct financing.
Recently aid works addressed. Team strives help people in need.
Real Madrid
List of the leading football teams planet be stripped down without Galacticos.
FIFA named specified squad as the leader of football of the
last century.
The team achieved 65 titles national class.
To the list you can add 34 championships in the Spain championship.
Such results of other teams does not exist.
"Galactikos" originated in beginning of the last century.
After 18 years of work composition assigned title royal.
Leadership in Spanish football club tried to take over
at the dawn of existence. Achieve this succeeded thanks to several factors.
The team is renowned for its comprehensive approach to training.
Mentors try to focus on different parameters:
1. Physical condition of athletes.
2. The procedure for selecting players for the team.
3. Tactics of action.
Meticulous work allows white win championships. About the merits of the composition you can talk for hours.
More 10 times Real Madrid won in European cup competitions.
Roster never didn't drop from the Spanish championship.
Independent researchers believe Galacticos the most
expensive club in the world. Approximate value at the time of analysis amounted to 4.2 billion USD.
Annual income high. Squad earns on resale of players, advertising contracts,
sponsorship. Significant part of earnings is selling seats
in the stands during games.
mysql root 密碼更改 | 豬窩
Hello there! Do you know if they make any plugins to protect against hackers?
I'm kinda paranoid about losing everything I've worked
hard on. Any recommendations?