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 密碼更改 | 豬窩 | 1092
Quality articles is the key to be a focus for the people to pay a visit the web site, that's what this website is
providing.
mysql root 密碼更改 | 豬窩 | 2066
I'm curious to find out what blog platform you are working with?
I'm having some small security issues with my
latest blog and I would like to find something more safeguarded.
Do you have any solutions?
mysql root 密碼更改 | 豬窩 | 763
Hi! My name is Sarah. I am browsing online tonight and stumbled upon this amazing place called [bubichat.com](https://bubichat.com)! í ¾íµ°
To be honest, I'm feeling a little lonely, and I thought it would be
super exciting to meet some cute guys instead of
just watching Netflix.
At [bubichat.com](https://bubichat.com), it's so easy to join a private conversation right away.
Loads of girls online at the moment for sexy chats.
í ½í¸˜
Should you wish getting to know me, you’ll find me hanging
out there! Who knows we can flirt a little together?
í ½í¸ˆ
The best part is — it doesn't cost anything to join, and you can be
as naughty as you want. í ½í¹ˆ
So, stop hesitating!
Come find me, sweetheart, I'm waiting at [bubichat.com](https://bubichat.com)! ❤️
See you soon! í ½í¸˜
XOXO,
Emily
mysql root 密碼更改 | 豬窩 | 2066
I have read a few just right stuff here. Certainly worth bookmarking
for revisiting. I surprise how much effort you place to create this kind
of wonderful informative web site.
mysql root 密碼更改 | 豬窩 | 1092
If some one desires to be updated with most up-to-date technologies then he must be go
to see this website and be up to date every day.