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 密碼更改 | 豬窩 | 667
Football teams often become legends. Players dream to put on uniforms of their favorite squad.
Number of fans increasing constantly. Top clubs support in home country
and in other countries. Matches collect millions of TV viewers.
Let's meet legendary clubs from different countries of the world.
Old Lady
"Old Signora" .
Worth note additional fact. In 1992 Manchester
United founded the APL.
Most successful period came coaching Alex Ferguson. Team won many
famous titles. While about the past glory remains only
remembering. However Red Devils still could show good play.
"Bayern"
Club first appeared in early last century.
During time existence "Star of the South" achieved nickname most famous club
Germany . Total about 60 significant achievements.
In recent years fame started from 2012. Squad demonstrated
excellent football. Star of the South strengthened in the leading positions in the national championship.
Players were able to achieve excellent results at European tournaments.
Club often supported other teams and ordinary people. Several times Star of the South supported
Munich 1860. Management implemented various methods support:
• profitable transfers;
• free matches;
• financial transactions.
Recently support works locally. Team attempts to transfer funds personally.
Galacticos
List of the leading football clubs world would incomplete without
Real Madrid. International organizations named specified 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. Similar achievements of other teams does not exist.
"Real Madrid" originated in 1902. After 18 years of work team gave title royal.
Leadership in local football roster began to take over from the beginning.
Achieve this succeeded thanks to several reasons. The team is renowned for
its comprehensive approach to training. Mentors
try to focus on different factors:
1. Physical condition of athletes.
2. Selection.
3. Settings for the game.
Meticulous work allows creamy win championships. About the pluses of the composition successfully talk
for hours. More 10 times Real Madrid won in European cup competitions.
Roster not once didn't leave from the national championship
of the country. Independent researchers believe Galacticos the
most expensive club in the on the planet. Approximate
price at the time of study amounted to approximately US$4 billion.
Annual income high. Club earns on resale of players, advertising contracts, sponsors.
Impressive part of earnings is selling seats in the stands during
games.
mysql root 密碼更改 | 豬窩 | 732
Football clubs often become legendary. Athletes wish defend colors of their favorite squad.
Fanbase growing inexorably. Top teams support in home country and rest of the world.
Matches attract millions of TV viewers. Let's meet legendary clubs
from different regions of the planet.
Old Lady
"Juventus" appeared in 1897. Roster considered most titled.
About achievements you can talk hours. In the early 2010s
the club was recognised as the most famous among Italians.
Sociologists performed own computation. It was possible to establish that 13 million people
are sick of Old Lady. The data is huge. Such help spectators have
many other giants none.
Players of club actively help charity projects. Team patronizes several programs:
• education;
• medical field;
• help with housing.
Juventus experienced declines. But the roster managed pass challenges.
Manchester City
Club appeared in the list thanks to the today situation. Roster steady shows excellent results.
Players year after year trying to win the championship
in the English Premier League. Total number awards so far small.
But situation developing in a positive direction.
Model work evokes exclusively praise. Manchester City helps many
clubs from different parts of the world. List contains countries
from Americas, Asia. Young athletes have a chance get into the
best championship the planet.
Red Devils
List of leading clubs would stripped without Red Devils.
This team has become the most famous on the planet.
Fans can be found different countries:
• USA;
• Russian Federation;
• France.
Help team colossal. Red Devils squad appeared late 1870s.
During the existence succeeded pass through many problems.
Manchester United is the one of the most clubs of of football in England .
Worth report another fact. In the early 1990s Red Devils
founded the English Premier League.
Best stage came coaching Alex Ferguson. Club managed to win many prestigious
titles. At the moment about the past glory remains only dreaming.
But Manchester United still be able to show excellent football.
"Bayern"
Composition first time appeared in 1900. During time development
"Star of the South" won title most titled team FRG.
Account about 60 major achievements.
In recent years success started from early 2010s. Club showed good game.
Star of the South strengthened in the leading positions in the national championship.
Players were able to achieve great results at European tournaments.
Club often helped other teams and ordinary people. Often Star
of the South supported Munich 1860. Functional performed various methods assistance:
• economically attractive transfers;
• free matches;
• direct financing.
Now support works addressed. Team attempts to transfer funds personally.
Real Madrid
List of the leading football teams planet would incomplete without Real Madrid.
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 attribute 34 first places in the La Liga. Similar achievements
of competitors does not exist.
"Real Madrid" appeared in 1902. Through 18 years of existence composition assigned title royal.
Leadership in Spanish football club began to take over at the dawn of existence.
Achieve this succeeded thanks to several factors. The team is
famous for its comprehensive approach to training process.
Coaches try to focus on several parameters:
1. Shape of football players.
2. The procedure for selecting players for the team.
3. Settings for the game.
Detailed work allows white take titles. About the merits of the composition successfully
talk for long. More 10 times Real Madrid won in European cup competitions.
Roster not once didn't leave from the Spanish championship.
Independent assessors believe Galacticos the most
expensive club in the on the planet. Approximate
value at the time of analysis reached approximately US$4 billion.
Annual income high. Squad earns on selection, advertising contracts, sponsors.
Impressive part of earnings became selling tickets for matches.
mysql root 密碼更改 | 豬窩 | 768
Football teams often become legendary. Athletes wish to put on uniforms of their favorite squad.
Number of fans increasing inexorably. Top teams support in region of presence and rest of the world.
Matches attract millions of spectators. Let's
meet legendary clubs from different regions of the planet.
Juventus
"Juventus" appeared in 1897. Club became most successful.
About awards you can talk long. In 2012 the team was named as the most famous in Italy.
Sociologists performed own research. It was possible to establish that
more than 13 million fans are sick of Old Lady.
The data is huge. Similar help spectators have majority
other giants don't meet.
Football players of club often contribute charities.
Composition leads several programs:
• training;
• medical field;
• help with housing.
Old Lady experienced crises. But the club could to overcome challenges.
Citizens
Club appeared in the list because of the today situation. Roster confidently shows excellent results.
Players year after year trying to win the championship in the APL.
Total number regalia so far small. But state
of affairs is improving.
Scheme work may cause exclusively praise. Manchester City supports many
clubs around the world. List contains countries from Americas, Asian region. Young footballers have the
opportunity get into the best championship the planet.
Manchester United
List of leading teams remain stripped without Manchester United.
This team has become the most famous on the planet. Fanbase can be found different countries:
• United States of America;
• Russia;
• “The Fifth Republic”.
Support club huge. Red Devils squad originated late 1870s.
During the history managed pass through different obstacles.
Manchester United regarded the one of the most teams history of football in England .
Must note another fact. In the early 1990s Red Devils founded the English Premier
League.
Best stage came coaching Alex Ferguson. Team
managed to win different prestigious awards. While about the past glory has only dreaming.
But Manchester United still could demonstrate good play.
"Bayern"
Composition first originated in 1900. During
time existence "Bayern" achieved nickname most famous club FRG.
Account about 60 major achievements.
Currently fame started from 2012. Club showed good game.
Bayern strengthened in the first lines in the Bundesliga.
Football players were able to achieve excellent results at continental tournaments.
Roster often helped other teams and ordinary people.
Often Bavaria supported Munich 1860. Management implemented various methods assistance:
• profitable transitions;
• free matches;
• financial transactions.
Recently aid works addressed. Team attempts to transfer funds people in need.
Real Madrid
List of the best football teams world be stripped down without Real Madrid.
International organizations recognized 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. Such results of other teams does not exist.
"Galactikos" originated in 1902. After 18 years
of existence composition assigned title royal.
Leading positions in local football club tried to take over at the
dawn of existence. Achieve this succeeded thanks to set factors.
The team is renowned for its comprehensive approach to training process.
Mentors try to focus on several factors:
1. Physical condition of athletes.
2. The procedure for selecting players for the team.
3. Tactics of action.
Detailed preparation helps creamy take titles.
About the pluses of the composition successfully talk for hours.
More 10 times Real Madrid won in Champions League and other European club competitions.
Club never didn't leave from the national championship of the country.
Independent researchers believe Real Madrid the most expensive club in the world.
Approximate value at the time of analysis amounted to approximately US$4 billion.
Annual income high. Club earns on resale of players,
advertising contracts, sponsors. Impressive income became sale tickets for matches.
mysql root 密碼更改 | 豬窩 | 772
Football teams often become legendary. Players dream to put on uniforms of their favorite squad.
Fanbase increasing constantly. Top clubs
support in home country and rest of the world. Games collect millions of TV viewers.
Let's meet popular clubs from different regions of the planet.
Old Lady
"Old Signora" .
Worth note another fact. In 1992 Red Devils founded the APL.
Best period got on coaching Alex Ferguson. Team managed to win different
prestigious awards. At the moment about the past glory
has only remembering. But Red Devils still be able to show excellent football.
"Bayern"
Composition first appeared in early last century.
During time existence "Bayern" achieved nickname most famous team FRG.
Account about 60 major awards.
Currently success started from early 2010s. Squad showed
good game. Bayern strengthened in the leading lines in the Bundesliga.
Players managed achieve great results at continental tournaments.
Roster often supported other teams and ordinary people.
Several times Star of the South supported Munich 1860.
Management implemented various methods support:
• profitable transfers;
• friendly games;
• financial transactions.
Now aid works addressed. Club strives help personally.
Galacticos
List of the best football clubs planet would incomplete without Galacticos.
FIFA named this squad as the leader of football of the last century.
The team achieved 65 ranks national class. To the list you can attribute 34 first places in the Spain championship.
Similar results of other teams does not exist.
"Galactikos" originated in 1902. After 18 years of work team assigned title royal.
Leading positions in local football roster tried to take over at the
dawn of existence. Achieve this succeeded thanks to several reasons.
The team is famous for its comprehensive approach to training.
Mentors pay attention to on several factors:
1. Physical condition of athletes.
2. Selection.
3. Tactics of action.
Meticulous work allows creamy take titles. 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.
Club never didn't leave from the Spanish championship.
Independent researchers name Real Madrid the most
expensive club in the on the planet. Approximate value
at the time of analysis amounted to 4.2 billion USD.
Annual income decent. Club earns on resale of players, advertising, sponsorship.
Impressive part of earnings became sale seats in the stands during
games.
mysql root 密碼更改 | 豬窩 | 666
Football clubs often become legendary. Players wish to put on uniforms of their favorite squad.
Fanbase growing inexorably. Top clubs support in home country and
in other countries. Matches attract millions of spectators.
Introduce legendary clubs from different countries of the
world.
Old Lady
"Old Signora" .
Worth note another fact. In the early 1990s Manchester United founded the APL.
Best period came coaching Alex Ferguson. Club managed to win different
famous titles. At the moment about the past glory has only
remembering. However Red Devils still could show excellent football.
"Star of the South"
Club first time appeared in 1900. During time existence "Star of the South" achieved nickname most famous
team Germany . Total about 60 significant awards.
In recent years success started from early 2010s.
Squad demonstrated excellent football. Star of the
South stayed in the leading lines in the national championship.
Football players managed achieve great results at continental tournaments.
Roster often helped other teams and ordinary people. Several times Bavaria
supported Munich 1860. Management performed various methods support:
• economically attractive transfers;
• free matches;
• direct financing.
Now support works locally. Club attempts to transfer funds people in need.
Galacticos
List of the best football teams world would stripped down without Real Madrid.
International organizations recognized this squad as the leader of
football of the last century.
The team won 65 ranks national class. To the list get attribute 34 championships in the La
Liga. Such achievements of competitors does not exist.
"Galactikos" originated in 1902. After 18 years of existence team assigned
title royal.
Leadership in Spanish football club tried 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. Coaches try to focus on different parameters:
1. Shape of football players.
2. The procedure for selecting players for the team.
3. Settings for the game.
Meticulous preparation allows white win championships. About the pluses of the of
the team successfully talk for long. More 10 times Real Madrid won in European cup competitions.
Roster not once didn't drop from the Spanish championship.
Independent researchers believe Real Madrid the most expensive club in the on the planet.
Indicative value at the time of study amounted to 4.2 billion USD.
Annual income high. Squad earns on selection, advertising, sponsors.
Significant part of earnings is selling seats in the
stands during games.