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 密碼更改 | 豬窩 | 533
이런글 남길수 있어서 너무 감사하다 생각합니다.
여러분도 저를 따라와서 좋은 정보 받아가세요
mysql root 密碼更改 | 豬窩 | 533
I got this web page from my buddy who informed me regarding this
website and at the moment this time I am visiting this website and reading
very informative articles or reviews at this time.
mysql root 密碼更改 | 豬窩
Appreciating the time and energy you put into your site and in depth information you provide.
It's awesome to come across a blog every once in a while
that isn't the same unwanted rehashed material. Great read!
I've saved your site and I'm adding your RSS feeds to my Google account.
mysql root 密碼更改 | 豬窩
Amazing issues here. I'm very happy to peer your post. Thanks so much and I am taking a look
forward to contact you. Will you please drop me a e-mail?
mysql root 密碼更改 | 豬窩 | 763
First off, congratses on this message. This is actually truly outstanding however that's why you consistently crank
out my friend. Wonderful blog posts that our team can easily drain our teeth in to and truly
visit work.
I like this weblog article as well as you recognize you are actually.
Blogging can be actually really frustrating for a lot of people because
there is actually thus a lot entailed however its like anything else.
Great reveal as well as thanks for the reference listed below, wow ...
Just how great is that.
Off to share this post right now, I desire all those brand new
writers to find that if they don't currently possess a program ten they do now.