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 密碼更改 | 豬窩
An interesting discussion is worth comment. There's no doubt that
that you should publish more on this subject matter, it may
not be a taboo matter but generally people do not talk about
these subjects. To the next! Kind regards!!
mysql root 密碼更改 | 豬窩
Highly descriptive article, I liked that a lot.
Will there be a part 2?
mysql root 密碼更改 | 豬窩
Wow that was strange. I just wrote an extremely
long comment but after I clicked submit my comment didn't appear.
Grrrr... well I'm not writing all that over again. Anyway, just wanted to say
great blog!
mysql root 密碼更改 | 豬窩
It is the best time to make some plans for the future and it's time to be happy.
I have read this post and if I could I wish to suggest you few interesting things or tips.
Perhaps you can write next articles referring to this article.
I desire to read more things about it!
mysql root 密碼更改 | 豬窩
The virtual realm of fun, thrill and money Casinos
online are a popular choice for all. There is no doubt in the fact that online casinos are convenient and offer their own advantages and fun aspects.
However, to pick the ideal online casino among the many is
an issue. It is possible to not think about it before choosing an online gambling site, but I suggest that you do.
More than just thinking, there are steps to be followed
or taken care of while searching for a suitable casino.
It is very important to be aware of what to look out for when choosing to
find an online gambling site. Is it the benefits or is it
the reputation?Before you are aware of the most important points and guidelines for selecting an online casino you must
realize that making money isn't a problem at all, it just takes patience and the right
techniques.The first and foremost factor to consider when choosing an online casino is the credibility.
Is the casino trustworthy and worthy of your time and cash?
The credibility or reliability factor is crucial If you cherish your money as
well as your computer system. There are casinos who believe in tricking and cheating players or customers by not paying the money or by using
rogue software. So, it's prudent to conduct a thorough search to reach
a reliable end. Search engines will provide any information about the casino
as well as its background and services. Find the answer to the question 'is the casino licensed and with who?'
verify the address and phone number to make sure that the casino is
authentic and real. Credibility of an online casino also grows if
it is associated with any land based casino and has an address in the street.
Be sure to read through the conditions and terms of the casino you are enquiring about.
When searching for a casino online instead of using http: use https since the
"s" means a secure line. This signifies that the's' in https is
a way to protect your system from any malicious software or malicious site.Age: The existence of an online casino boosts its credibility, as does its experience
and reputation. Thus if you come across such an online casino,
that is one year older or is not even a year old, it is recommended to move on with your search.