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 密碼更改 | 豬窩 | 536
Why users still make use of to read news papers when in this technological world all is existing on net?
mysql root 密碼更改 | 豬窩 | 534
Hi there, I found your site by means of Google at the same time as searching for a related matter,
your web site came up, it appears great. I have bookmarked it in my google bookmarks.
Hi there, simply changed into alert to your blog thru Google, and located that it's truly informative.
I'm going to watch out for brussels. I will be grateful if you
proceed this {in future}. A lot of other folks might be benefited out of your writing.
Cheers!
mysql root 密碼更改 | 豬窩
Paragraph writing is also a fun, if you be acquainted with
after that you can write or else it is complicated to write.
mysql root 密碼更改 | 豬窩
Hi there excellent website! Does running a blog like this require a
great deal of work? I have absolutely no expertise in programming but I had
been hoping to start my own blog in the near future. Anyhow, should you
have any recommendations or tips for new blog owners
please share. I know this is off subject
but I simply had to ask. Kudos!
mysql root 密碼更改 | 豬窩 | 523
If you desire to obtain much from this paragraph then you have to
apply such methods to your won web site.