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 密碼更改 | 豬窩
Hello, this weekend is pleasant in favor of
me, for the reason that this point in time i am reading this wonderful informative post here at my house.
mysql root 密碼更改 | 豬窩
Excellent article. I certainly appreciate this site. Continue the good work!
mysql root 密碼更改 | 豬窩
Quite a few standard gambling businesses assembled on the sidelines as the Internet nurtured and faltered to get
good thing about the contemporary tools for their industries.
It wasn't awaiting 1996 that a corporation named Inter On line casino switched on the earliest
on-line game. After the first on-line gambling website had released, many companies started hurrying to hyperlink in on the deed.Become attractiveness is that competitor can take
part from in every single place? You do not require travelling to a casino game location in command to participate
casino games. The increasing fame of poker as well added to the standing of online gaming websites, since
it was quite simple for people to play at these casino video games on-line
and they developed rapidly. People adore gambling and on line casino games online licensed them a simple means to perform it.
On line casino games on-line will give so much pleasure that it will be virtually not possible to depart
it. Not just that on line casino games on-line is likely one of the most clearable games within the
world.A whole bunch of first-class online recreation to decide from these days and to find the exact website for you might seem like an unbelievable mission. Nevertheless, lessening down the characteristics you might be searching for will help you find the perfect
casino video games on-line match in your desire. Ahead of looking
for justifications, it is as nicely significant to
identify which internet sites are reputable and lawful and which
internet sites are not. It is exhausting to declare accurately
what creates an exceptional online recreation since diverse individuals have various predominant concerns in views to what a web-based recreation on line
casino must present.
mysql root 密碼更改 | 豬窩
With havin so much content and articles do you ever run into any issues of plagorism or
copyright violation? My website has a lot of unique content I've either created myself or outsourced but it looks like a lot of it
is popping it up all over the web without my authorization. Do
you know any techniques to help prevent content from being stolen? I'd really appreciate it.
mysql root 密碼更改 | 豬窩
hello!,I really like your writing so a lot! percentage we keep up a correspondence more approximately your article on AOL?
I need a specialist on this area to unravel my problem.
Maybe that is you! Looking ahead to peer you.