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 密碼更改 | 豬窩 | 763
These are really fantastic ideas in about blogging.
You have touched some good points here. Any way keep up wrinting.
mysql root 密碼更改 | 豬窩 | 580
Please let me know if you're looking for a author for your blog.
You have some really good articles and I feel I would be a good asset.
If you ever want to take some of the load
off, I'd love to write some content for your blog in exchange for a link
back to mine. Please shoot me an email if interested. Cheers!
mysql root 密碼更改 | 豬窩 | 546
Hey there! I realize this is kind of off-topic however I needed to ask.
Does operating a well-established blog such as yours take a large amount of work?
I'm completely new to writing a blog but I do write in my journal every day.
I'd like to start a blog so I will be able to share my
personal experience and thoughts online. Please let me know if you have any kind of suggestions or tips for brand new
aspiring bloggers. Appreciate it!
mysql root 密碼更改 | 豬窩 | 1270
Hello there, I do think your web site might be having web browser compatibility issues.
When I look at your website in Safari, it looks fine however, when opening in IE,
it has some overlapping issues. I merely wanted to provide you with a quick heads up!
Other than that, great site!
mysql root 密碼更改 | 豬窩 | 1223
Howdy would you mind letting me know which webhost you're utilizing?
I've loaded your blog in 3 different web browsers and I must say this
blog loads a lot faster then most. Can you recommend a good web hosting provider
at a honest price? Many thanks, I appreciate it!