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 密碼更改 | 豬窩
Artificial grass is becoming a popular alternative to
natural grass due to the huge improvement in the production techniques.
Artificial grass or Astro Turf used to be limited to
recreation centers and sports. However, thanks to its realistic appearance and feel you will find
it in every backyard. The lawn mowing process
can be a chore you have to do daily during summer. It can take as
long as three hours, depending on how the size
of your garden. In our modern times, it seems that we all nowadays live
at the speed of a hundred miles an hour, and even our private time
for relaxation has become a valuable commodity in the midst of
the demands of our lives and obligations. So, you must ask yourself the question, do you really
want to be spending your time mowing and maintaining your lawn?
mysql root 密碼更改 | 豬窩
Simply wish to say your article is as astonishing. The clarity for your publish is simply spectacular and that
i can suppose you're knowledgeable in this subject.
Well along with your permission let me to grab your feed to stay
updated with impending post. Thanks 1,000,000 and please keep up
the enjoyable work.
mysql root 密碼更改 | 豬窩
Heya just wanted to give you a brief heads up and let you know a few of the
images aren't loading correctly. I'm not sure why but I think its a
linking issue. I've tried it in two different internet
browsers and both show the same outcome.
mysql root 密碼更改 | 豬窩
I know this if off topic but I'm looking into starting
my own weblog and was curious what all is required to get set up?
I'm assuming having a blog like yours would cost a pretty penny?
I'm not very internet smart so I'm not 100% positive.
Any recommendations or advice would be greatly appreciated.
Cheers
mysql root 密碼更改 | 豬窩
When some one searches for his required thing, thus he/she wants to be available that
in detail, therefore that thing is maintained over here.