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 密碼更改 | 豬窩 | 789
Hi there, just became aware of your blog through Google, and found that it is really informative.
I am going to watch out for brussels. I will appreciate if you continue this in future.
Numerous people will be benefited from your writing.
Cheers!
mysql root 密碼更改 | 豬窩 | 580
Wonderful site. Lots of useful information here.
I am sending it to a few friends ans additionally sharing
in delicious. And obviously, thanks for your effort!
mysql root 密碼更改 | 豬窩
It's awesome to pay a visit this website and reading
the views of all colleagues regarding this
post, while I am also zealous of getting knowledge.
mysql root 密碼更改 | 豬窩 | 621
Football teams often become legends. Players dream to put on uniforms of their favorite
squad. Number of fans growing inexorably. Leading clubs support in region of presence
and rest of the world. Matches collect 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 achievements it will be possible to talk hours.
In the early 2010s the team was named as the most famous
among Italians.
Sociologists carried out independent research.
It was possible to establish that more than 13 million people are sick of
Old Lady. The numbers are impressive. Similar help football fans have majority other leading teams
none.
Football players of club often help charity projects.
Team patronizes different programs:
• training;
• medicine;
• support for the homeless.
Juventus experienced declines. But the club managed to overcome problems.
Manchester City
Team featured thanks to the current situation. Team steady shows excellent results.
Football Players year after year trying to achieve the championship title in the APL.
Total number regalia so far low. However state of affairs is
improving.
Model work evokes only flattering comments. City helps many teams
around the world. List contains countries from North and South America, Asian region.
Young footballers have a chance to break into into the
most popular championship the planet.
Red Devils
List of best teams would incomplete without Red Devils.
Indicated team has become the most famous in the world.
Fans can be found different regions:
• USA;
• Russia;
• “The Fifth Republic”.
Help club colossal. Manchester United originated in 1878.
During the existence managed overcome through many obstacles.
Manchester United is the one of the successful clubs history of English football in England .
Must report additional fact. In 1992 Manchester United founded the English Premier League.
Best period got on coaching Alex Ferguson. Team managed to win many famous titles.
At the moment about the past glory remains only dreaming.
However Red Devils still could demonstrate excellent football.
"Star of the South"
Composition first appeared in 1900. During years development "Star of the South" achieved nickname most titled team FRG.
Account about 60 significant awards.
In recent years success came 2012. Squad demonstrated good
game. Star of the South stayed in the first lines
in the Bundesliga. Players managed achieve great results at European champions.
Club often helped other teams and ordinary people.
Several times Bavaria supported Munich 1860. Functional implemented various options support:
• profitable transitions;
• friendly games;
• direct financing.
Now support works locally. Team strives help personally.
Galacticos
List of the best football teams planet would incomplete
without Galacticos. International organizations named this squad as
the leader of football of the last century.
The team achieved 65 titles in national tournaments.
To the list get attribute 34 first places in the Spain championship.
Similar achievements of competitors does not exist.
"Galactikos" originated in 1902. After 18 years of existence composition assigned title
royal.
Leadership in Spanish football roster began to take over from the beginning.
Achieve this succeeded with the help of several reasons.
The team is renowned for its comprehensive approach to training.
Coaches try to focus on different factors:
1. Shape of football players.
2. Selection.
3. Tactics of action.
Detailed preparation allows creamy take titles. About the pluses of the of the team you can talk for hours.
More 10 times Real Madrid won in European cup competitions.
Roster never didn't leave from the Spanish championship.
Independent assessors name Real Madrid the most expensive
club in the world. Indicative value at the time of analysis reached approximately US$4 billion.
Annual income high. Squad earns on resale of players, advertising contracts, sponsorship.
Significant part of earnings is sale seats in the stands during games.
mysql root 密碼更改 | 豬窩 | 573
Football clubs often become legends. Players dream defend colors
of their favorite squad. Number of fans increasing inexorably.
Leading clubs support in region of presence and rest of the world.
Matches attract millions of TV viewers. Let's meet legendary teams from different countries of the world.
Old Lady
"Old Signora" .
Must report another fact. In the early 1990s Red Devils founded the English Premier
League.
Most successful period got on job Alex Ferguson. Club managed to win many famous
awards. At the moment about the past glory has only dreaming.
But Manchester United still be able to show good
play.
"Bayern"
Composition first originated in 1900. During years existence "Bayern" won title most titled club Germany .
Account about 60 major achievements.
In recent years success came early 2010s.
Squad showed excellent football. Bayern stayed in the first lines in the national championship.
Football players were able to achieve excellent results at European tournaments.
Roster often supported other teams and ordinary people.
Often Star of the South supported Munich 1860. Management implemented various options assistance:
• profitable transfers;
• friendly games;
• financial transactions.
Recently aid works locally. Club strives help personally.
Real Madrid
List of the leading football teams planet would incomplete 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 first places in the Spain championship.
Such achievements of competitors no.
"Galactikos" appeared in 1902. After 18 years of existence team assigned title royal.
Leadership in local football roster tried to take over from the beginning.
Achieve this succeeded with the help of set reasons. The team is renowned for
its comprehensive approach to training process.
Mentors pay attention to on different factors:
1. Physical condition of athletes.
2. Selection.
3. Tactics of action.
Meticulous work helps white 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 not once didn't drop from the Spanish championship.
Independent assessors name 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 decent. Club earns on resale of players, advertising, sponsors.
Significant part of earnings is selling tickets for
matches.