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 密碼更改 | 豬窩
Hello, I believe your site may be having web browser compatibility
issues. Whenever I look at your blog in Safari, it looks fine however,
when opening in Internet Explorer, it has some overlapping issues.
I merely wanted to give you a quick heads up!
Besides that, wonderful blog!
mysql root 密碼更改 | 豬窩
Nice post. I was checking constantly this blog and I am impressed!
Very useful info specially the last part :
) I care for such information a lot. I was looking for this
certain info for a long time. Thank you and good luck.
mysql root 密碼更改 | 豬窩
you're in reality a just right webmaster. The web site loading velocity is incredible.
It kind of feels that you're doing any distinctive trick.
Furthermore, The contents are masterpiece. you've performed
a wonderful activity in this matter!
mysql root 密碼更改 | 豬窩
Although it's evident that people nowadays are educated in the subject of sexuality however,
there are still people who require a assistance in this area.
If you're just beginning to become sexually active,
or are in a relationship with a dwindling sexual life,
sex-related instructional videos could be just the thing you need.
Sex can turn into sexually enjoyable and sensual when you know exactly what you're doing and why you're doing it.
There are a few things from the sex-related instructional videos.
You may just find an entirely new side of yourself by watching sex instructional videos.
Through the different techniques and tips that you can pick up
from these videos will help you become a better sexual partner.
These videos can also help you let go of your inhibitions and your partner's as well .
They can also help you to feel more comfortable
in your own appearance, no matter what body
type you have. It's a good idea to take a look at sex-related videos together.
This will help to improve your relationship. Although both videos show sexual activity the instructional videos
are much more detailed. They typically contain a narrative or step-by-step instructions.
While sex-related instructional videos are designed to provide you with a
greater understanding of the body and how it can use it in sexual activity, porn on the other hand will just show people having sex.
Some people think that sex is like porn, however, there's more
than the obvious. There's foreplay, romance, and
many techniques that can make sex a memorable experience.
mysql root 密碼更改 | 豬窩
Hello, all is going sound here and ofcourse every one is sharing data, that's actually excellent,
keep up writing.