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 密碼更改 | 豬窩
I am actually delighted to glance at this website posts which consists of plenty of useful information, thanks for providing these kinds of statistics.
mysql root 密碼更改 | 豬窩
I like reading an article that will make people think.
Also, thank you for allowing me to comment!
mysql root 密碼更改 | 豬窩
Today, online porn is a highly profitable business.
A web crawler has discovered porn websites offer free content that can be used to
promote more expensive adult content. The large number of free
websites are a great way to gain new members or visitors.
According to comScore Media Metrix research, there
were 63.4 million unique users on porn sites in December
2005. That's 37.2 percent of all Internet users.
According to John E Dunn from techworld research, researchers were able to buy traffic 49,000 unique
visitors from websites that were not owned by third parties for just $161.
This indicates how simple it is for porn webmaster to find audience.Online porn sites are also a source
of malware distribution. What is malware? Malware is a
malicious program that is designed to invade the computer system.
It is able to take passwords, credit card numbers,
login data and passwords, or to cause damage to the operating system of a computer.
Malware could include trojan horses, trojan horses, viruses, spyware, adware, as well as other
undesirable software. That's why porn sites were infected with malware.
The site can earn money through illicit methods.
mysql root 密碼更改 | 豬窩
Online casinos are the fastest-growing online business
today. Online casinos are a copy version of the traditional land-based casino.
In the last year, they improved their offerings by allowing gamblers to play various casino games with better payouts
that aren't available at their physical competitors.
Online casinos offer a great way to make money while
having enjoyable. Online casinos that are most well-known are reliable and proficient using the top casino software.
For the most efficient strategies for gambling online,
players should make it a point of reading through
the online casino's guide. It is also important to be aware of the fact that reliable reviews are available about
casinos online and the designers of the different games offered
by online casinos. An online casino guide together
with a large number of reviews about a particular suite of online casino games and casinos
is usually available on a single website. The information contained in the online casino guide and reviews ought
to directly inform users about the casinos online and their
games. Information and information can be easily gathered online, unlike traditional casinos that are located in the land.
mysql root 密碼更改 | 豬窩
This is really interesting, You're a very skilled blogger.
I have joined your feed and look forward to seeking more of
your wonderful post. Also, I have shared your web site in my
social networks!