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 密碼更改 | 豬窩 | 154
This is really interesting, You're an overly skilled blogger.
I've joined your rss feed and look ahead to in quest of more of your
great post. Also, I've shared your site in my social
networks
mysql root 密碼更改 | 豬窩
Hi! I understand this is sort of off-topic but I had to ask.
Does operating a well-established blog such as yours take a large amount of work?
I'm completely new to operating a blog but I do write in my journal on a daily basis.
I'd like to start a blog so I can easily share my personal experience and feelings online.
Please let me know if you have any recommendations or tips for brand new aspiring blog
owners. Thankyou!
mysql root 密碼更改 | 豬窩
Amazing! Its really remarkable post, I have got
much clear idea about from this paragraph.
mysql root 密碼更改 | 豬窩
My developer is trying to convince 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 WordPress 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 transfer all my wordpress posts into it?
Any kind of help would be really appreciated!
mysql root 密碼更改 | 豬窩
This paragraph is in fact a nice one it helps new internet users, who are
wishing for blogging.