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 密碼更改 | 豬窩
A motivating discussion is worth comment. I do believe that you ought to write more about this
topic, it may not be a taboo subject but generally people do not speak
about such subjects. To the next! Kind regards!!
mysql root 密碼更改 | 豬窩
Good info. Lucky me I ran across your website by chance (stumbleupon).
I have saved it for later!
mysql root 密碼更改 | 豬窩
It's true that most people nowadays are well-educated in the field of sex but
there are some that require a little of assistance in this area.
It doesn't matter if you're beginning to be sexually active or are in the midst of
a breakup with a diminishing sexuality, sex educational videos might be just the
answer you've been looking for. Sexually active can be quite sexually enjoyable and enjoyable when you are aware of what you're doing , and why that you're
performing it. Watch sex instructional videos to teach you a
thing or two or maybe You might uncover a an entirely new side
of you.Sex instructional videos are extremely beneficial as they
can allow you to make your bedroom more exciting with your partner.
With the various tips and tricks that you will learn from these videos will help you improve your relationship with your partner.
The videos can assist you in letting go of your fears and anxieties, as well as your partner's as well as help you
how to be comfortable in your own skin, no matter what body type
you have. In addition, because it's strongly
suggested that you go through sex instructional videos with your lover and partner,
it could help strengthen the relationship.You may be thinking, what makes sex instructional vids any
different from porn videos? Though both videos will
show sexual activity however, you'll gain something from instructional videos since they typically include either a narrative or step-by-step
instruction. In contrast, sex instructional videos seek to
give you a better understanding of your body and how you can use it in sex,
porn on the contrary, will only show the sex of those
who are. If you believe that sex is just like what you've
seen in porn films, you'll be surprised to know that there is something more involved than just the process itself.
There's foreplay, there's romance and there are techniques which can assist
you in making the whole thing amazing.
mysql root 密碼更改 | 豬窩
Hey there! I'm at work browsing your blog from my new apple iphone!
Just wanted to say I love reading your blog and look forward to all your posts!
Carry on the outstanding work!
mysql root 密碼更改 | 豬窩
Hi! Someone in my Facebook group shared this website with
us so I came to take a look. I'm definitely enjoying the information. I'm bookmarking and will be tweeting this to
my followers! Excellent blog and wonderful design and style.