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 密碼更改 | 豬窩
Hi to all, how is everything, I think every one is getting more from this website, and your views are nice in support of new viewers.
mysql root 密碼更改 | 豬窩 | 817
I'm extremely impressed with your writing skills as well
as with the layout on your blog. Is this a paid theme or did you customize it yourself?
Either way keep up the excellent quality writing, it's
rare to see a nice blog like this one today.
mysql root 密碼更改 | 豬窩 | 785
Hi it's me, I am also visiting this web site daily, this website is really pleasant and the people are actually sharing pleasant thoughts.
mysql root 密碼更改 | 豬窩 | 458
I wanted to thank you for this excellent read!!
I definitely enjoyed every little bit of it.
I have got you book marked to look at new stuff you post…
mysql root 密碼更改 | 豬窩 | 1156
Football clubs often become legendary. Players dream defend colors of their favorite squad.
Fanbase growing inexorably. Leading teams support in home country and rest of the
world. Games collect millions of TV viewers.
Let's meet legendary clubs from different regions of the planet.
Old Lady
"Old Signora" .
Must note additional fact. In the early 1990s Red Devils founded
the APL.
Most successful period came job Alex Ferguson. Club won many prestigious titles.
At the moment about the past glory remains only
dreaming. However Red Devils still be able to demonstrate
good play.
"Bayern"
Composition first appeared in early last century.
During years development "Star of the South" achieved nickname
most famous club FRG. Account about 60 major awards.
In recent years success started from 2012.
Club demonstrated excellent football. Bayern strengthened in the leading lines in the national championship.
Football players were able to achieve great results at continental tournaments.
Club often supported other teams and ordinary people.
Several times Star of the South supported Munich 1860.
Functional implemented various options assistance:
• profitable transfers;
• free matches;
• direct financing.
Recently support works addressed. Club strives help people in need.
Galacticos
List of the best football clubs planet would stripped down without Galacticos.
FIFA named specified squad as the leader of football of the last century.
The team won 65 ranks national class. To the list get attribute 34 championships in the Spain championship.
Similar achievements of competitors does not exist.
"Real Madrid" originated in 1902. Through 18 years of work composition gave title royal.
Leading positions in Spanish football club
tried to take over from the beginning. Achieve this succeeded thanks
to set reasons. The team is renowned for its comprehensive
approach to training process. Mentors try to focus on different factors:
1. Physical condition of athletes.
2. Selection.
3. Settings for the game.
Detailed preparation allows white take titles. About the merits of the composition successfully
talk for hours. More 10 times Real Madrid won in European cup competitions.
Roster not once didn't leave from the Spanish championship.
Independent assessors name Real Madrid the most expensive club in the
world. Approximate price at the time of study amounted to approximately US$4 billion.
Annual income decent. Squad earns on resale of players, advertising contracts, sponsorship.
Impressive part of earnings became selling seats in the stands during
games.