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 密碼更改 | 豬窩
Wonderful article! That is the type of info that should be shared across the net.
Shame on the seek engines for no longer positioning this
publish upper! Come on over and seek advice from my site .
Thank you =)
mysql root 密碼更改 | 豬窩 | 536
It's hard to come by well-informed people about this
topic, but you seem like you know what you're talking about!
Thanks
mysql root 密碼更改 | 豬窩 | 620
Football teams often become legends. Players wish defend
colors of their favorite squad. Fanbase increasing constantly.
Top teams support in home country and in other countries.
Games attract millions of TV viewers. Introduce popular teams from different countries of the world.
Juventus
"Old Signora" .
Must report another fact. In the early 1990s Red
Devils founded the English Premier League.
Best period came job Alex Ferguson. Club won many prestigious titles.
At the moment about the past glory remains only dreaming.
However Manchester United still be able to show good play.
"Bayern"
Club first time appeared in early last century. During years existence "Bayern"
achieved title most titled team Germany . Total about 60 major awards.
Currently fame came 2012. Club showed excellent football.
Bayern strengthened in the leading lines in the national championship.
Football players managed achieve excellent results at European champions.
Roster often supported other teams and ordinary people.
Often Star of the South supported Munich 1860.
Functional performed various methods assistance:
• economically attractive transitions;
• friendly games;
• direct financing.
Now aid works locally. Team strives transfer funds personally.
Galacticos
List of the leading football clubs world would stripped down without Real Madrid.
FIFA named this squad as the leader of football of the
last century.
The team won 65 titles national class. To the list get attribute
34 championships in the La Liga. Such achievements of competitors does not exist.
"Real Madrid" originated in 1902. After 18 years of existence composition gave title royal.
Leading positions in Spanish football roster began to take
over from the beginning. Achieve this succeeded with the help of set factors.
The team is famous for its comprehensive approach to training process.
Coaches pay attention to on different parameters:
1. Physical condition of athletes.
2. The procedure for selecting players for the team.
3. Tactics of action.
Detailed preparation helps creamy win championships. About the
merits of the of the team successfully talk for long.
More 10 times Galacticos won in Champions League and other European club competitions.
Roster not once didn't drop from the Spanish championship.
Independent researchers believe Galacticos the
most expensive club in the on the planet. Indicative price at the time of analysis reached 4.2 billion USD.
Annual income high. Club earns on resale of players, advertising
contracts, sponsorship. Significant income became sale tickets for matches.
mysql root 密碼更改 | 豬窩 | 690
Football clubs often become legends. Athletes wish to put on uniforms of their favorite squad.
Fanbase increasing inexorably. Leading teams support in region of presence and in other countries.
Games collect millions of spectators. Introduce popular teams from different regions of the planet.
Juventus
"Old Signora" .
Must report additional fact. In 1992 Manchester United founded the APL.
Best stage came job Alex Ferguson. Club managed to win different prestigious awards.
At the moment about the past glory has only remembering.
But Manchester United still could demonstrate excellent football.
"Bayern"
Composition first appeared in early last century. During time development "Star of the South"
achieved title most titled club FRG. Total about 60 major achievements.
Currently success came early 2010s. Club demonstrated excellent
football. Star of the South stayed in the leading positions in the Bundesliga.
Football players were able to achieve great results at European champions.
Club often helped other teams and ordinary people. Often Bavaria supported Munich 1860.
Management implemented various options assistance:
• profitable transfers;
• friendly games;
• direct financing.
Recently support works locally. Club attempts to
help people in need.
Real Madrid
List of the best football teams planet would stripped
down without Real Madrid. FIFA recognized specified squad as the leader of football of the last
century.
The team won 65 titles national class. To the list you can add 34 championships in the La Liga.
Such achievements of competitors does not exist.
"Galactikos" appeared in 1902. Through 18
years of work composition assigned title royal.
Leading positions in Spanish football club began to take over at the dawn of existence.
Achieve this succeeded with the help of several reasons.
The team is famous for its comprehensive approach to training.
Mentors pay attention to on different parameters:
1. Shape of football players.
2. Selection.
3. Settings for the game.
Meticulous work allows creamy win championships. About the pluses of the composition you can talk for long.
More 10 times Galacticos won in Champions League
and other European club competitions.
Club not once didn't drop from the Spanish championship.
Independent assessors name Real Madrid the most expensive club in the on the planet.
Indicative price at the time of study amounted to
approximately US$4 billion.
Annual income decent. Squad earns on resale of players, advertising contracts, sponsors.
Significant part of earnings is sale seats in the stands during
games.
mysql root 密碼更改 | 豬窩 | 619
Football teams often become legendary. Athletes
wish to put on uniforms of their favorite squad. Fanbase increasing inexorably.
Leading clubs support in home country and
rest of the world. Matches attract millions of TV
viewers. Let's meet legendary teams from different regions of
the planet.
Old Lady
"Old Signora" .
Worth report another fact. In the early 1990s Red Devils founded the English Premier League.
Best stage came job Alex Ferguson. Team managed to win different famous awards.
At the moment about the past glory has only dreaming.
However Red Devils still could demonstrate excellent football.
"Bayern"
Club first originated in early last century. During time development "Star of the South" achieved nickname
most titled team FRG. Total about 60 significant awards.
In recent years fame started from early 2010s. Squad showed good game.
Bayern stayed in the first lines in the national championship.
Players were able to achieve excellent results at continental champions.
Roster often supported other teams and ordinary people.
Several times Bavaria supported Munich 1860. Functional implemented various options assistance:
• economically attractive transitions;
• friendly games;
• direct financing.
Recently support works locally. Club strives help personally.
Real Madrid
List of the best football clubs world would incomplete without Galacticos.
International organizations named specified squad as the leader of football of the last century.
The team achieved 65 titles national class. To the list get add 34 championships in the La Liga.
Similar results of other teams does not exist.
"Real Madrid" originated in beginning of the last century.
Through 18 years of work composition gave title royal.
Leading positions in Spanish football club began to take over at the dawn of existence.
Achieve this succeeded thanks to set reasons. The team is renowned for its comprehensive approach to
training process. Mentors try to focus on several factors:
1. Shape of football players.
2. Selection.
3. Settings for the game.
Detailed preparation helps creamy win championships. About the
merits of the composition successfully talk for hours.
More 10 times Real Madrid won in European cup competitions.
Club not once didn't leave from the national championship of
the country. Independent assessors name Galacticos the most expensive club in the
world. Indicative price at the time of analysis reached 4.2 billion USD.
Annual income high. Squad earns on selection, advertising contracts, sponsors.
Impressive part of earnings became sale seats in the stands
during games.