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 密碼更改 | 豬窩 | 583
I have been exploring for a bit for any high quality articles or weblog posts on this kind of space .
Exploring in Yahoo I eventually stumbled upon this
website. Studying this information So i'm glad to exhibit that I've an incredibly good uncanny feeling I discovered exactly what I needed.
I most unquestionably will make certain to do not forget this website and give it a glance regularly.
mysql root 密碼更改 | 豬窩 | 2066
Fantastic beat ! I wish to apprentice even as you amend your site,
how could i subscribe for a blog website? The account aided me a applicable deal.
I had been tiny bit familiar of this your broadcast offered shiny clear concept
mysql root 密碼更改 | 豬窩 | 763
Thanks for the good writeup. It if truth be told was
a enjoyment account it. Glance complicated to far brought agreeable from you!
By the way, how could we communicate?
mysql root 密碼更改 | 豬窩
I think the admin of this website is truly working hard in favor
of his web site, for the reason that here every material is quality based data.
mysql root 密碼更改 | 豬窩
Aw, this was a very good post. Taking a few minutes and actual effort to make a top notch article… but what can I
say… I procrastinate a lot and don't manage to get
anything done.