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 excellent blog! Does running a blog like this require
a massive amount work? I have virtually no knowledge of programming however
I had been hoping to start my own blog soon. Anyways, if
you have any recommendations or tips for new blog
owners please share. I understand this is off topic nevertheless I simply needed to ask.
Appreciate it!
mysql root 密碼更改 | 豬窩
Hiya! Quick question that's totally off topic. Do you know how to make your site mobile
friendly? My bblog looks weird when browsing from my apple iphone.
I'm trying to find a theme or plugjn that might be able to resolve this
problem. If you have any suggestions, please share.
Appreciate it!
mysql root 密碼更改 | 豬窩 | 763
Good day I am so glad I found your site, I
really found you by accident, while I was browsing on Bing for something
else, Regardless I am here now and would just like
to say cheers for a fantastic post and a all round interesting blog (I also love the theme/design), I don’t have time
to read through it all at the moment but I have bookmarked it and also
added in your RSS feeds, so when I have time I will be back to read more, Please do keep up the
fantastic jo.
mysql root 密碼更改 | 豬窩
Hello! I could have sworn I've been to this website before but after browsing through some
of the post I realized it's new to me. Anyhow, I'm
definitely delighted I found it and I'll be book-marking
and checking back often!
mysql root 密碼更改 | 豬窩 | 102
Hello, Neat post. There is a problem along with your site in web
explorer, would check this? IE nonetheless is the marketplace chief and a big
component of folks will pass over your wonderful writing due to this problem.