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