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 密碼更改 | 豬窩 | 2066
Hello there, I discovered your blog by way
of Google even as looking for a similar topic, your site came up, it looks good.
I've bookmarked it in my google bookmarks.
Hi there, simply become alert to your weblog thru Google,
and found that it is truly informative. I'm gonna watch out for brussels.
I'll appreciate if you happen to continue
this in future. Numerous people can be benefited from your writing.
Cheers!
mysql root 密碼更改 | 豬窩 | 2066
I'm not sure exactly why but this site is loading incredibly slow
for me. Is anyone else having this problem or is it a issue on my end?
I'll check back later and see if the problem still exists.
mysql root 密碼更改 | 豬窩 | 2066
Everyone loves what you guys tend to be up too. This type of clever work and reporting!
Keep up the fantastic works guys I've incorporated you guys to blogroll.
mysql root 密碼更改 | 豬窩 | 1092
Its such as you learn my mind! You seem to know so much approximately this, like you wrote the ebook in it or something.
I feel that you just can do with a few percent to pressure the message house
a little bit, but other than that, that is great blog.
A fantastic read. I will definitely be back.
mysql root 密碼更改 | 豬窩 | 2066
Awesome blog! Do you have any tips and hints for aspiring writers?
I'm planning to start my own site soon but I'm a little lost
on everything. Would you suggest starting with a free platform
like Wordpress or go for a paid option? There are so many options out there that
I'm completely overwhelmed .. Any ideas? Appreciate it!