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 密碼更改 | 豬窩 | 553
This is the right site for everyone who would like to
understand this topic. You understand so much its almost hard to argue with you (not that I really would want
to…HaHa). You certainly put a brand new spin on a topic that's been written about for years.
Great stuff, just excellent!
mysql root 密碼更改 | 豬窩 | 763
This design is steller! You obviously know how to keep a reader entertained.
Between your wit and your videos, I was almost moved to start my own blog (well, almost...HaHa!)
Great job. I really enjoyed what you had to say, and more than that, how you presented it.
Too cool!How to make money online?
Copy successful trades of traders in copy binary options and copy
crypto trading. From 100% to 1000% per month can reach your
income.
mysql root 密碼更改 | 豬窩
Thanks very nice blog!
mysql root 密碼更改 | 豬窩 | 529
Greeting yall from busan I really appreciate the information you gave me.
Thanks for showing me the value of this. I will make sure i get you back!
mysql root 密碼更改 | 豬窩 | 763
This post is genuinely a pleasant one it helps new net viewers, who are wishing in favor of blogging.How to make money online?
Copy successful trades of traders in copy binary options and copy crypto trading.
From 100% to 1000% per month can reach your income.