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 密碼更改 | 豬窩 | 817
Hey I know this is off topic but I was wondering if you knew
of any widgets I could add to my blog that automatically tweet my newest twitter updates.
I've been looking for a plug-in like this for quite some time and was hoping
maybe you would have some experience with something like this.
Please let me know if you run into anything. I truly enjoy reading your blog and I look
forward to your new updates.
mysql root 密碼更改 | 豬窩 | 509
It's in point of fact a nice and helpful piece of information. I am glad that
you simply shared this useful information with us.
Please stay us up to date like this. Thank you for sharing.
mysql root 密碼更改 | 豬窩 | 713
Football is the most famous gamein the world. Demand massive.
Hundreds of millions of people follow games of idols.
Demand growing constantly.
Of course for the specified sport you can make bets
at bookmakers. Quickly introduce development of football.
Development of game
Football originated in antiquity. Games with a ball were popular among citizens of many states.
They were used in:
• Asian countries;
• Sparta;
• Ancient Rome.
Italians developed sport. In the 16th century they created the game "Calcio".
With the development of trade relations, it came to the United Kingdom.
Love in sport formed instantly. By Popularity "Calcio" surpassed cricket.
Severe discipline
Interest public appeared not by chance. Game impressed with its dynamics.
Passion on the court were significant. This allowed rules of football:
1. 2 teams.
2. 25 people each.
3. 15 offensive players.
4. Right to fight.
English made own rules. At first discipline didn't unify.
In some places allowed to throw ball with hands, in others forbidden.
The first attempt to standardization occurred in 1846.
Cases wanted immediate response. Representatives from different
colleges entered the field on the field as part of the tournament.
Each player worked in accordance with acceptedrules.
Result did not inspire positive development of events.
However, players were fix a single regulations.
Starting unification turned out positive. Participation viewers increased.
As a result in England formed the first specialized
club. Roster named "Sheffield". It happened in 1857.
After 6 years appeared The Football Association of England.
Organization quickly created a standard code of
rules of football.
Modern outline
Gradually discipline improved. Created requirements
for the stadium. Approved dimensions of the gate.
Significant time is 1871. Then appeared the FA Cup. Tournament - oldest in the class.
1891 - year appearances in discipline penalty. However, from
current specified strike is. Now shoot penalties from fixed spot.
Earlier moment was done from the line.
Discipline evolved. Love grew. According to the results in the 1880s, the number of teams passed over a hundred.
In society began arise speculations. Many players felt that certain teams give players incentives.
In those days disciplines could be only amateur.
As a result norms changed. They added a clause prohibiting players to receive remuneration.
Began wave denunciations. Teams accused each other. Some clubs left the league.
Later norm cancelled.
Football in other countries of the world
Growth of trade accelerated penetration of discipline to Europe.
Following the results game became regulated at the
supranational level. FIFA appeared in 1904. At first organization included
7 countries.
Unified norms on equipment was. Players required
to wear:
• hat or top hat;
• boots;
• long stockings;
• pants.
Normal entered later. Initially footballers played without license plates.
They appeared only in 1939.
First international championship held in 1900.
Football included to the Olympiad. Participated total England, France, Belgium.
Football flourished in the 1950. In the world started playing Pele, Yashin and other players.
mysql root 密碼更改 | 豬窩 | 667
Football is the most famous disciplinein the world.
Demand huge. Millions of people follow matches of favorite
teams. Demand growing constantly.
Of course for this discipline can make a bet at bookmakers.
Shortly tell development of football.
Development of game
Football appeared in antiquity. Games with a ball were popular among inhabitants of
many states. They were applied in:
• Asian countries;
• Ancient Greece;
• Ancient Rome.
Italians improved discipline. During the Middle Ages they introduced to the world the game "Calcio".
With the development of trade, it came to the United Kingdom.
Interest in sport formed instantly. By Popularity "Calcio" beaten cricket.
Severe discipline
Popularity public appeared not by chance. Discipline captivated
with its dynamics. Passion on the court were serious.
This permitted rules of football:
1. 2 squads.
2. 25 athletes each.
3. 15 forwards.
4. Right to fight.
Inhabitants of Foggy Albion created own norms. At first discipline wasn't standardized.
In some places allowed to throw projectile with hands,
in others forbidden.
The first attempt to standardization occurred in 1846. Cases wanted momentary
response. Representatives from several colleges entered the field on the field during the competition. Each athlete
acted in accordance with known to himnorms. Outcome did not inspire optimism.
However, players managed to create a single regulations.
Starting unification became positive. Participation public intensified.
As a result in England there was the first special club.
Roster renamed "Sheffield". It happened in 1857.
In 1863 formed The Football Association of England. It immediately
adopted a standard set of norms games.
Phased improvement
Gradually discipline developed. Created requirements for
the stadium. Standardized dimensions of the gate.
Important year is 1871. At that time appeared the FA Cup.
Tournament - oldest in the class.
1891 - year appearances in football kick from 11
meters. However, from current specified strike is. Today take penalties from point.
Earlier penetration was done from the line.
Discipline evolved. Interest grew. According to the results in the 1880s, the number of teams passed
over a hundred. In society began to arise speculations.
Many players felt that a number of rosters give players incentives.
In those days disciplines could be only amateur. As a result norms changed.
They added a clause prohibiting players to receive remuneration.
Began wave slander. Teams accused each other. Some clubs left the league.
Later norm cancelled.
Football in other countries of the world
Growth of trade increased penetration of football to Europe.
As a result game became regulated at the supranational level.
FIFA originated in beginning of the last century.
At the start organization included 7 countries.
Standard requirements on equipment did not exist. Players required to wear:
• hat or top hat;
• boots;
• elongated stockings;
• pants.
Standard entered later. Initially athletes played without license
plates. Notation appeared only in 1939.
Starting international championship held at the
beginning of the last century. Discipline included to the Olympiad.
Participated total England, France, Belgium.
Football flourished in the middle of the last century. On the planet started playing high class stars.
mysql root 密碼更改 | 豬窩 | 836
I do believe all of the ideas you've introduced in your post.
They are really convincing and can definitely work. Nonetheless, the posts are very quick for starters.
Could you please extend them a little from next time?
Thank you for the post.