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 密碼更改 | 豬窩
Have you been trapped within the harmful grasp of pornography?
It will probably so often feel dark and like there is not any means out.
As someone who is aware of how you're feeling, I might like to supply some
useful hints on how to stop porn addiction from ruining your life.
There IS hope!Be honest. Once we're not honest we so typically damage
ourselves probably the most and we typically do not even notice what we're doing.
Flip inward and ask why you have a look at porn. What causes
do you give to can help you justify it? Look at these reasons.
Are they true? What will you do to live in better concord with yourself?
If you cannot be honest with yourself first you then'll by no means be honest with others.Confide in someone you
trust. There is a powerful bond that severs when the secrecy of your struggles is divulged, the bond that holds you captive to addiction. You
additionally understand that you're worthy of being loved.Know your limits and set barriers.
If you wrestle with alcohol, do not go to the bar.
For those who struggle with web pornography, find constructive methods to limit or hold
yourself accountable on your web use. You realize where your limits are, do not experience close to the cliff.Serve others.
The deep joy that is found from connecting to actual people is amazing.
When someone smiles at you, surprises you with a word of thanks or helps you with your
groceries consider how you feel. Small each day acts of
kindness will assist you to see the difference between the pretend promises of pornography and the promise of real intimacy & love.
mysql root 密碼更改 | 豬窩 | 1222
With havin so much content do you ever run into any problems of plagorism or copyright violation? My blog has a
lot of completely unique content I've either authored myself
or outsourced but it appears a lot of it is popping it
up all over the web without my permission. Do you know any methods
to help prevent content from being stolen? I'd really appreciate it.
mysql root 密碼更改 | 豬窩 | 518
I am now not positive where you're getting your info, but good topic.
I must spend a while finding out more or working out more.
Thank you for wonderful info I used to be looking for this info
for my mission.
mysql root 密碼更改 | 豬窩 | 763
I like the helpful information you provide in your articles.
I will bookmark your weblog and test once more right here
frequently. I'm rather sure I will be informed lots of new stuff proper here!
Best of luck for the next!
mysql root 密碼更改 | 豬窩 | 369
You actually make it seem so easy with your presentation but I find this topic to
be really something which 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!