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 密碼更改 | 豬窩
You probably already know why these gaming machines are really popular worldwide
if you haven. Putting such information make album worth buying and keeping as collector's
item. Fifty Dead Men Walking: This film is based on the novel of the
same name that reflects the actual story associated with an undercover agent and how he successfully experienced the IRA.
mysql root 密碼更改 | 豬窩
Make your profile as appealing as is possible, use catchy
phrases and get away from being boring. If things go out of hand then leave immediately and change your username.
You have complete control you want to contact and which you desire
to block from.
mysql root 密碼更改 | 豬窩
People observe the rave reviews and they are touched from the
great need to watch the given movie on big screen. Putting such information increase the risk for album worth buying and keeping as collector's item.
There are corresponding cosplay costumes as
well as the cosplay accessories for each ones at the same time.
mysql root 密碼更改 | 豬窩
Kindly be aware that the team you happen to be hoping to win is called the widely used while the c's you're expecting to lose is named the underdog.
As you will see, binary betting provides investor
many the opportunity to trade within the fast and volatile market movements however, avoiding a similar risk
as other markets. Like recounted before, here is the
spot where sports spread betting will highlight results
profitable ones I mean.
mysql root 密碼更改 | 豬窩
Cheltenham betting pointed in the year 1902 with just a skeleton structure of races
during the period of 3 days, as years pass a number of showpiece races happen to
be combined with the festival and because of this just last 2005 the National Hunt's premiere horse racing
betting event became a four day highlighted event which gives more excitement and
hopes to people horse race enthusiasts. It is incredibly latest internet betting,
which can be finding a lot of popularity among youngsters
from all of parts of society, young adults and older people.
Like recounted before, this can be a spot where
sports spread betting will reveal results profitable ones I mean.