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 密碼更改 | 豬窩
This is the right website for everyone who hopes to understand this topic.
You know a whole lot its almost tough to argue
with you (not that I actually would want to…HaHa).
You definitely put a fresh spin on a subject that has been discussed for many years.
Excellent stuff, just great!
mysql root 密碼更改 | 豬窩 | 1331
After going over a handful of the blog posts on your web page, I seriously
appreciate your way of blogging. I added it to
my bookmark website list and will be checking back in the near
future. Please visit my web site as well and tell me what you think.
mysql root 密碼更改 | 豬窩
Very great post. I simply stumbled upon your weblog
and wished to say that I've really loved browsing your weblog
posts. After all I will be subscribing in your rss feed and
I am hoping you write again very soon!
mysql root 密碼更改 | 豬窩
Write more, thats all I have to say. Literally, it seems
as though you relied on the video to make your point.
You obviously know what youre talking about, why
throw away your intelligence on just posting videos to your weblog when you could be
giving us something enlightening to read?
mysql root 密碼更改 | 豬窩
Wow, this piece of writing is good, my younger sister is analyzing these things, therefore
I am going to convey her.