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 密碼更改 | 豬窩
At times, we identify ourselves in a flashpoint in everyday life.
One side may be a challenging route which is a whole
lot more rewarding, whereas some other can be the easiest option, or maybe one other path.
Whatever direction you'll take will establish lots of things
with regards to your coming future. Kids massage therapy
is definitely the way which I expend most of my days, and it's also genuinely worthwhile.
Yet, I may nearly as smoothly have picked different things, in particular, life as a accountant or possibly as an oceanic scientist.
We can never appreciate how modifying possibly one single
tiny thing could well shift just about every single portion of our experience.
These are some considerations to question.
mysql root 密碼更改 | 豬窩 | 543
This blog was... how do I say it? Relevant!! Finally I
have found something that helped me. Thank you!
mysql root 密碼更改 | 豬窩 | 1917
Hey I am so happy I found your webpage, I really found you by mistake,
while I was searching on Yahoo for something else, Regardless I am
here now and would just like to say cheers for a fantastic post and a all
round entertaining blog (I also love the theme/design), I
don’t have time to look over it all at the minute but I have
saved it and also included your RSS feeds, so when I have time I will be back to read a great deal
more, Please do keep up the excellent work.
mysql root 密碼更改 | 豬窩
That is very attention-grabbing, You are a very skilled blogger.
I have joined your rss feed and sit up for seeking extra of your excellent post.
Additionally, I've shared your web site in my social networks
mysql root 密碼更改 | 豬窩
Hello, I enjoy reading through your article post. I like to write a little comment to support you.