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 密碼更改 | 豬窩
When someone writes an paragraph he/she maintains the plan of a user in his/her mind
that how a user can be aware of it. Thus that's why this
article is outstdanding. Thanks!
mysql root 密碼更改 | 豬窩 | 518
I've been exploring for a little bit for any high-quality articles or
weblog posts in this sort of house . Exploring in Yahoo I finally stumbled upon this website.
Studying this info So i am satisfied to exhibit that I've an incredibly just right uncanny feeling I found out exactly what I needed.
I such a lot for sure will make sure to do not fail to remember
this site and provides it a glance on a continuing
basis.
mysql root 密碼更改 | 豬窩 | 772
Wow, wonderful blog layout! How long have you been blogging
for? you made blogging look easy. The overall look of your site is wonderful, as well as the content!
mysql root 密碼更改 | 豬窩
Merely wanna remark that you have a very decent web site, I love the design and style it really stands out.
mysql root 密碼更改 | 豬窩
I must thank you for the efforts you have put in writing this blog.
I really hope to see the same high-grade content by
you in the future as well. In truth, your creative writing
abilities has inspired me to get my very own website now ;
)