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 密碼更改 | 豬窩 | 1244
Thanks for a marvelous posting! I certainly enjoyed reading it, you could be a great author.I will make certain to bookmark your blog
and will eventually come back in the foreseeable future.
I want to encourage you to ultimately continue your
great writing, have a nice weekend!
mysql root 密碼更改 | 豬窩 | 1241
Ahaa, its good dialogue regarding this piece of writing at this
place at this web site, I have read all that, so at this time me also
commenting here.
mysql root 密碼更改 | 豬窩 | 1223
I'm curious to find out what blog system you happen to be using?
I'm experiencing some minor security issues with my latest blog
and I would like to find something more secure.
Do you have any recommendations?
mysql root 密碼更改 | 豬窩 | 789
Football is the most popular gameon the planet. Interest massive.
Hundreds of millions of fans follow matches of
idols. Attention growing planned.
Of course for the specified sport can make a bet at bookmakers.
Shortly introduce development of football.
Development of discipline
Football originated several centuries BC. Disciplines with a ball in demand among citizens of
different countries. They were used in:
• Ancient China;
• Sparta;
• Ancient Rome.
Inhabitants of Italy improved discipline. During the
Middle Ages 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" beaten cricket.
Severe discipline
Popularity among viewers appeared naturally. Discipline captivated
with its dynamism. Passion on the field occurred significant.
This permitted norms of football:
1. 2 squads.
2. 25 people each.
3. 15 forwards.
4. Permission to fistfights.
English created their norms. At first game wasn't standardized.
In some places allowed to throw ball with hands, in others forbidden.
The Starting attempt to standardization occurred in 1846.
Cases wanted momentary response. Representatives from different colleges entered the field
on the field as part of the tournament.
Each player worked in accordance with known to
himrules. Outcome did not inspire positive development of events.
However, players were fix a common regulations.
First unification became positive. Attention public increased.
According to the results in Great Britain formed the first special club.
Roster named "Sheffield". It happened in 1857.
After 6 years formed The Football Association of England.
It immediately created a standard set of rules of football.
Modern outline
Over time discipline improved. Created requirements for the field.
Approved dimensions of the gate.
Important year is 1871. At that time originated the FA Cup.
Championship - oldest in the class.
1891 - time appearances in discipline kick from 11 meters.
However, from current this strike different. Today shoot penalties from fixed spot.
Earlier moment was done from the line.
Discipline improved. Interest grew. According to the results
in the 1880s, the number of clubs exceeded 100 pieces.
Among the public began to appear speculations. Some athletes felt that certain teams pay members incentives.
At that time disciplines could be exclusively amateur.
As a result rules changed. They added a clause prohibiting players to receive remuneration.
Began wave slander. Lineups accused each other. Some clubs left the league.
Later requirement cancelled.
Football in other countries of the world
Growth of trade accelerated penetration of discipline to Europe.
As a result sport became regulated at the supranational level.
FIFA originated in beginning of the last century.
At first association included 7 countries.
Standard norms on equipment was. Players was required to wear:
• headdress;
• boots;
• elongated stockings;
• pants.
Normal entered later. For the first time footballers played
without license plates. Notation appeared only in 1939.
First international tournament held at the
beginning of the last century. Discipline included
to the Olympiad. Participated total England, France, Belgium.
The heyday of the sport occurred in the 1950. In the world
started playing Pele, Yashin and other players.
mysql root 密碼更改 | 豬窩 | 817
Wow, this post is pleasant, my younger sister is analyzing these
kinds of things, so I am going to inform her.