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 密碼更改 | 豬窩
Dreaming is a completely natural experience, and is a fundamental element of
being human. Each and every person experiences the state of dreaming when we
are asleep. Some of us are adept at recollecting and preserving the experience
of dreaming, while others say that they "Do Not Dream" due to the completely absent dreams.
Regardless of whether we recall our dreams or not, every one person experiences
a variety of dreams during the course of our nightly
sleep. The dreams that we each have come to
us in a wide range of forms and styles. The dreams
we have can be focused on anything from mundane to the exciting and thrilling.
A lot of people experience something terrifying in their sleep; the frightening dreams are often described as nightmares or night
terrors. At other times we experience fantasies that are thrilling and thrilling, and even erotic.
Most of our dreaming is routine or insignificant.
A lot of people view dreams as a way of "sorting out"
of the events found in their daily lives. Others believe that dreams are a gift from God or a superior power.
They can assist us to comprehend our lives and also forecast the future.
Others believe their dreams are simply a reflection of their subconscious thoughts.
Scientific studies show that people all dream regularly.
What distinguishes us is the ability to remember our dreams.
Certain of us are able to quickly and accurately recall a number of dreams from one
night. Others have trouble recalling even the smallest dream image.
Some individuals go above and beyond just dream recall and are able to even control things that happen in their dreams.
Lucid Dreaming is a form of dream control. A Lucid Dream is a dream
where the person who is dreaming realizes that they are in the actual process of dreaming, and achieves an experience of "Conscious Awareness" within the dream.
This allows the person dreaming to be in control of
the dream and control what happens in the
dream. Lucid Dreams allow us to experience what we
see when we sleep. Lucid Dreaming allows one to control the events in the
dreams. The amount of control you are able to exercise is contingent on your dreams and who you
are. Sometimes you're more in control than others in your dreams.
Two things that are consistent within Lucid Dreams are: Lucid Dream are:
mysql root 密碼更改 | 豬窩
Wow, fantastic blog layout! How long have you been blogging for?
you make blogging look easy. The overall look of your site is magnificent,
let alone the content!
mysql root 密碼更改 | 豬窩
My family all the time say that I am killing my time here at web,
however I know I am getting knowledge everyday by reading thes good content.
mysql root 密碼更改 | 豬窩
An outstanding share! I've just forwarded this onto a coworker
who had been doing a little research on this.
And he in fact ordered me breakfast due to the fact that I stumbled upon it
for him... lol. So allow me to reword this.... Thanks for the meal!!
But yeah, thanx for spending some time to talk about this topic here on your web site.
mysql root 密碼更改 | 豬窩
Hey there would you mind letting me know which webhost you're utilizing?
I've loaded your blog in 3 completely different internet browsers and I must say this blog loads a lot faster then most.
Can you suggest a good web hosting provider at a honest
price? Cheers, I appreciate it!