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 there, just became aware of your blog through Google,
and found that it is really informative.
I'm going to watch out for brussels. I'll be grateful if you continue this in future.
Many people will be benefited from your writing. Cheers!
промокоды для 1xbet на бесплатную ставку
mysql root 密碼更改 | 豬窩
WOW just what I was searching for. Came here by searching for www.wholesalejerseysfreeshippingfromchina.com
mysql root 密碼更改 | 豬窩
What's Happening i'm new to this, I stumbled upon this I've discovered It
positively helpful and it has helped me out loads. I am hoping to
give a contribution & aid different users like its
helped me. Great job.
mysql root 密碼更改 | 豬窩
I believe what you said was actually very logical. But, think about
this, suppose you typed a catchier post title? I mean,
I don't want to tell you how to run your blog, but what if you added a title that makes people desire more?
I mean mysql root 密碼更改 | 豬窩 is kinda boring.
You should peek at Yahoo's front page and see how they create post
titles to get viewers to open the links. You might try adding a video or a related picture or two to grab readers excited about what you've
got to say. In my opinion, it could bring your website a little livelier.
mysql root 密碼更改 | 豬窩 | 178
Hi there it's me, I am also visiting this website on a regular basis, this site is in fact good and the people are genuinely sharing good thoughts.