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 密碼更改 | 豬窩 | 524
Hi there! This is my first visit to your blog!
We are a collection of volunteers and starting a
new project in a community in the same niche. Your blog provided us beneficial information to
work on. You have done a extraordinary job!
mysql root 密碼更改 | 豬窩 | 112
Way cool! Some very valid points! I appreciate you penning this article plus the rest of the site is extremely good.
mysql root 密碼更改 | 豬窩 | 516
Greetings! This is my first visit to your blog! We are a collection of volunteers and
starting a new initiative in a community in the same niche.
Your blog provided us useful information to work
on. You have done a wonderful job!
mysql root 密碼更改 | 豬窩 | 72
I've been exploring for a little for any high quality articles
or weblog posts on this sort of space . Exploring
in Yahoo I eventually stumbled upon this web site. Studying
this info So i am happy to exhibit that I've an incredibly good uncanny feeling I came upon exactly
what I needed. I most undoubtedly will make certain to don?t omit this web site and provides
it a glance on a continuing basis.
mysql root 密碼更改 | 豬窩 | 664
Football teams often become legendary. Players dream defend colors of
their favorite squad. Number of fans increasing constantly.
Leading teams support in region of presence and rest of the world.
Games attract millions of spectators. Introduce popular clubs from different countries of the world.
Juventus
"Juventus" originated in 1897. Club considered most successful.
About awards it will be possible to talk long.
In 2012 the team was recognised as the most famous in Italy.
Outside companies performed independent computation. It was possible to
establish that more than 13 million fans are sick
of Old Lady. The data is huge. Similar help spectators have many other giants none.
Players of club actively help charities. Team leads several programs:
• education;
• medicine;
• support for the homeless.
Juventus experienced declines. But the club could pass problems.
Manchester City
Team appeared in the list thanks to the current situation. Team confidently shows excellent results.
Football Players every season trying achieve the championship title in the APL.
Total number regalia so far small. But state of affairs developing
in a positive direction.
Scheme work evokes only flattering comments. City supports
several clubs around the world. List includes countries from North and South America, Asian region. Beginners athletes
have a chance get into the most popular tournament of.
Red Devils
List of leading clubs would incomplete without Manchester United.
This team has become the most famous on the planet. Fanbase can be found different countries:
• United States of America;
• Russia;
• France.
Help club colossal. Red Devils squad appeared late 1870s.
During the history succeeded pass through many obstacles.
Manchester United regarded the one of the most teams of of
English football in England .
Must note additional fact. In the early 1990s
Manchester United founded the APL.
Best period came coaching Alex Ferguson. Team managed to win many prestigious awards.
While about the past glory has only remembering.
However Manchester United still could show excellent football.
"Bayern"
Club first originated in early last century.
During years existence "Star of the South" won title most titled team FRG.
Account about 60 major achievements.
Currently success came 2012. Club showed good game.
Bayern stayed in the first positions in the national championship.
Players were able to achieve excellent results at European tournaments.
Club often helped other teams and ordinary people. Several times
Bavaria supported Munich 1860. Management implemented various methods support:
• economically attractive transitions;
• friendly games;
• direct financing.
Now support works locally. Club attempts to transfer funds
people in need.
Galacticos
List of the leading football clubs planet be stripped down without Galacticos.
FIFA named specified squad as the leader of football of the last
century.
The team won 65 ranks in national tournaments. To the list get attribute 34 championships
in the Spain championship. Such achievements of other teams does not exist.
"Galactikos" originated in 1902. After 18 years of work team gave title royal.
Leadership in Spanish football roster 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 pay attention to on different parameters:
1. Shape of football players.
2. The procedure for selecting players for the team.
3. Settings for the game.
Meticulous preparation helps white win championships.
About the pluses of the of the team you can talk for long.
More 10 times Real Madrid won in European cup competitions.
Club never didn't leave from the national championship of the country.
Independent assessors believe Real Madrid the most expensive club in the on the planet.
Indicative price at the time of analysis amounted
to 4.2 billion USD.
Annual income decent. Squad earns on resale of players,
advertising contracts, sponsors. Significant part of earnings became sale tickets for matches.