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 密碼更改 | 豬窩 | 364
I've learn several excellent stuff here.
Definitely value bookmarking for revisiting.
I wonder how a lot attempt you put to create such a wonderful informative website.
mysql root 密碼更改 | 豬窩
Link exchange is nothing else but it is simply placing the other person's website link on your page at proper place and other person will also do similar for you.
mysql root 密碼更改 | 豬窩 | 178
magnificent issues altogether, you just won a emblem new reader.
What would you recommend in regards to your submit that you made
some days in the past? Any certain?
mysql root 密碼更改 | 豬窩 | 364
now its really hard to meet girls but i can guide you on how to find many for dating.
Follow me and ill teach you the skills in this era!
mysql root 密碼更改 | 豬窩
Off, congratulations on this message. This is truly amazing however
that is actually why you constantly crank out my friend.
Excellent posts that our company may sink our pearly whites right
into and also actually most likely to work.
I adore this blogging site article and you recognize you're.
Blog writing can be really difficult for a bunch
of individuals because there is a great deal involved yet its like everything else.
Whatever takes opportunity and all of us possess the exact same amount
of hrs in a day therefore placed all of them to good usage.
All of us need to start someplace and your plan is excellent.
Fantastic portion and also thanks for the mention below, wow ...
How trendy is that.
Off to share this post now, I want all those brand new bloggers to view that if they do not actually have a strategy 10 they carry out right now.