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 密碼更改 | 豬窩
I am really delighted to glance at this webpage
posts which contains lots of valuable facts, thanks for providing
these kinds of data.
mysql root 密碼更改 | 豬窩 | 419
Wow, this post is good, my younger sister is analyzing such things, so I am going to let know
her.
mysql root 密碼更改 | 豬窩 | 523
Heya this is kind of of off topic but I was wanting
to know if blogs use WYSIWYG editors or if you have to manually code with HTML.
I'm starting a blog soon but have no coding experience so I wanted to get advice from someone with
experience. Any help would be greatly appreciated!
mysql root 密碼更改 | 豬窩 | 490
Football teams often become legends. Athletes wish
defend colors of their favorite squad. Number of fans increasing
constantly. Leading clubs support in region of presence and in other countries.
Matches attract millions of TV viewers. Let's
meet popular clubs from different regions of the planet.
Old Lady
"Juventus" appeared in 1897. Roster considered most titled.
About awards you can talk long. In the early 2010s the
club was named as the most famous in Italy.
Outside companies carried out independent research. It was possible to find
out that 13 million fans are sick of Old Lady.
The numbers are impressive. Similar support football fans have many other giants don't meet.
Players of Juventus actively contribute charities.
Composition leads different programs:
• training;
• medicine;
• help with housing.
Old Lady overcome declines. However the roster could pass problems.
Citizens
Team appeared in the list because of the today situation. Roster steady shows excellent results.
Players year after year trying win the championship in the APL.
Total number awards so far small. But state of affairs developing
in a positive direction.
Scheme development may cause only flattering comments.
Manchester City supports many clubs around the world. List includes countries from
North and South America, Asian region. Beginners athletes have the opportunity get into the best
tournament the planet.
Red Devils
List of leading clubs remain incomplete without Red Devils.
Indicated team has considered the most popular in the world.
Fanbase can be found in many regions:
• USA;
• Russian Federation;
• “The Fifth Republic”.
Support team colossal. Red Devils squad originated in 1878.
During the existence managed overcome through
many problems.
Red Devils is the most successful clubs of of football in England .
Must report additional fact. In the early 1990s Red Devils founded the English Premier League.
Best stage came job Alex Ferguson. Club won many famous awards.
While about the past glory has only dreaming. But Manchester United still be able to demonstrate excellent football.
"Star of the South"
Club first originated in early last century. During years existence
"Bayern" achieved nickname most famous club FRG.
Account about 60 major achievements.
Currently fame started from early 2010s. Squad demonstrated excellent
football. Star of the South 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. Functional implemented various options support:
• profitable transfers;
• friendly games;
• financial transactions.
Now support works locally. Club strives help personally.
Real Madrid
List of the leading football teams planet would stripped
down without Galacticos. International organizations named this squad as
the leader of football of the last century.
The team achieved 65 ranks national class. To the list get
attribute 34 first places in the La Liga. Such achievements of competitors does not exist.
"Galactikos" appeared in beginning of the last century. After 18 years of work composition assigned title royal.
Leadership in Spanish football club tried to take over from the beginning.
Achieve this succeeded with the help of several factors.
The team is renowned for its comprehensive approach to training.
Mentors pay attention to on several parameters:
1. Shape of football players.
2. The procedure for selecting players for the team.
3. Settings for the game.
Meticulous preparation allows white win championships.
About the merits of the composition successfully
talk for hours. More 10 times Real Madrid won in Champions League and other European club competitions.
Club never didn't leave from the Spanish championship.
Independent assessors believe Galacticos the most expensive club in the on the planet.
Indicative price at the time of analysis reached 4.2 billion USD.
Annual income decent. Squad earns on resale of players, advertising contracts, sponsorship.
Significant income is selling tickets for matches.
mysql root 密碼更改 | 豬窩
When someone writes an article he/she retains the image of a user in his/her brain that how a user can be aware of it.
Thus that's why this post is great. Thanks!