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 密碼更改 | 豬窩
Thanks for finally writing about >mysql root 密碼更改 | 豬窩
mysql root 密碼更改 | 豬窩
Great post. I used to be checking constantly this weblog and I'm
inspired! Very helpful info specially the final part :)
I deal with such info a lot. I was seeking this
certain information for a very lengthy time. Thank you and best of luck.
mysql root 密碼更改 | 豬窩
Does your blog have a contact page? I'm having problems locating it but, I'd like to shoot you an e-mail.
I've got some recommendations for your blog you might be interested in hearing.
Either way, great blog and I look forward to seeing it
develop over time.
mysql root 密碼更改 | 豬窩
You actually make it seem so easy with your presentation but I find this matter to be actually something that
I think I would never understand. It seems too complicated and
extremely broad for me. I am looking forward for your next post, I'll try to get the
hang of it!
mysql root 密碼更改 | 豬窩
It's true that people nowadays are educated in the subject of sexual activity but there are some who require a little
of guidance in the area. If you're just beginning to get sexually active or are already in a relationship with a dwindling sex life, sex instructional videos may
just be the thing you need. Sex can be quite sexually enjoyable and enjoyable when it is clear what you're doing and why that you're performing it.
Sex instructional videos can teach you something or
two maybe, and who knows? You might just discover as the whole new
side of you.Sex instructional videos are great since they will allow you to spice up your bedroom routine with your love.
With the various tips and tricks that you will learn from these videos you'll be able improve your relationship with your partner.
The videos can aid you in letting go your inhibitions
and your partner's too, and help you to feel more comfortable in your own appearance,
regardless of what shape or body type you've got.
It is highly recommended that you watch sex instructional videos with your partner and partner, it could assist in strengthening your relationship.You might be thinking, how are sex instructional videos distinct from porn videos?
Though both videos depict sexual activity however, you'll gain something from instructional videos
as they generally include an account of the story or a step-by-step guide.
The purpose of sex instruction videos is to provide
you with a greater understanding of the body and
how it can make it work during sex, porn on the contrary, will
simply depict people who are having sexual encounters.
If you believe that sex is similar to the porn films, you'll be shocked to discover
that there's something more involved than the action itself.
There's foreplay, there's romance and there are techniques which can assist you
in making the whole act amazing.