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 密碼更改 | 豬窩
You can definitely see your skills in the work you write.
The arena hopes for more passionate writers such as you who aren't afraid to mention how they believe.
Always go after your heart.
mysql root 密碼更改 | 豬窩
Tea tasting events are similar to wine tasting.
Teas are examined for nearly the same things as wine such as color, aroma and flavor.
Many of the same terms used to describe wine can also be applied to tea.
These terms include body, bouquet and mellow along with many other descriptive phrases.
Similar methods are used for tasting. It requires time and organization to prepare for tea testing.
You should prepare no more than six different teas - otherwise you overload your palate.
It is possible to try a variety of teas, including
green, white as well as black, oolong, and white.
It is also possible to try six different tea blends to get
a more complex tasting. From the most basic flavor to
the strongest tea, the tea that has the most flavor is
the one that you first taste.
mysql root 密碼更改 | 豬窩
Wonderful beat ! I wish to apprentice at the same time as you amend your web site,
how could i subscribe for a blog website? The account aided
me a acceptable deal. I had been a little bit familiar of this your broadcast
provided brilliant transparent idea
mysql root 密碼更改 | 豬窩
What's up, I read your new stuff daily. Your story-telling style is awesome,
keep up the good work!
mysql root 密碼更改 | 豬窩
Wow, incredible blog layout! How long have you been blogging
for? you make blogging look easy. The overall look
of your site is excellent, as well as the content!