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 密碼更改 | 豬窩
What's up everyone, it's my first pay a visit at this web page, and piece of writing is really fruitful in support of me, keep
up posting these articles.
mysql root 密碼更改 | 豬窩
This is my first time visit at here and i am really impressed to read all at
single place.
mysql root 密碼更改 | 豬窩
My programmer is trying to persuade me to move to .net from PHP.
I have always disliked the idea because of the expenses.
But he's tryiong none the less. I've been using Movable-type on various websites for about a year
and am concerned about switching to another platform.
I have heard very good things about blogengine.net. Is there
a way I can import all my wordpress content into
it? Any kind of help would be greatly appreciated!
mysql root 密碼更改 | 豬窩
Making money may be difficult in other places, but it's easy and
easy online. You can make money on the Internet with your computer and internet
connection in a variety of ways. Online casino games are an excellent method to earn money.
Especially the game of roulette online is one of the most well-known within the gaming world because it
makes making money online simple and convenient.The benefit of playing roulette
games in comparison to all other types of games is that it is one of the games that provides the best chance of
winning over other games. Roulette players have never lost 100% of
their games. When you trade with caution and with a bit of discretion, you could have
a easy and straightforward methods of making a lot of money.
This is possible with minimal effort when playing
games at a casino online. It is possible to make
a small investment and not to put too much effort into the roulette game.
It is possible to earn a decent amount of money with time and cost economy.
mysql root 密碼更改 | 豬窩
Thanks very nice blog!