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 密碼更改 | 豬窩
I am really impressed together with your writing
talents as neatly as with the layout for your blog. Is this a paid subject matter or did
you modify it yourself? Anyway keep up the excellent high quality writing, it is uncommon to peer a great
blog like this one nowadays..
mysql root 密碼更改 | 豬窩
With havin so much content do you ever run into any problems of plagorism or copyright infringement?
My site has a lot of exclusive content I've either written myself or outsourced but it looks like a lot of it is popping it up all over the internet without my agreement.
Do you know any methods to help reduce content from being ripped
off? I'd truly appreciate it.
mysql root 密碼更改 | 豬窩
What's up every one, here every one is sharing these kinds of familiarity, therefore it's fastidious to read
this weblog, and I used to go to see this blog
all the time.
mysql root 密碼更改 | 豬窩
Hello my family member! I wish to say that this article is awesome, nice written and include almost all vital infos.
I'd like to peer more posts like this .
mysql root 密碼更改 | 豬窩
This article will assist the internet visitors for building up new website or even a weblog from start to end.