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 密碼更改 | 豬窩 | 2066
Somebody essentially lend a hand to make significantly posts I would state.
That is the first time I frequented your web page and to this point?
I amazed with the analysis you made to make this particular put up
extraordinary. Fantastic task!
mysql root 密碼更改 | 豬窩 | 763
Please let me know if you're looking for a writer for your blog.
You have some really good articles and I think I would be a good asset.
If you ever want to take some of the load off, I'd
love to write some articles for your blog in exchange
for a link back to mine. Please send me an e-mail if interested.
Many thanks!
mysql root 密碼更改 | 豬窩 | 1092
Os melhores caça-níqueis para jogar com Pix.
Horários pagantes e dicas comprovadas.
mysql root 密碼更改 | 豬窩 | 763
В Турции квартиры продаются с обозначением системой X+1:
3+1 — три спальни и общая зона. Типичная площадь 3+1 — 110–160 м².
Стоимость квадратного метра отличаются от 1 200 € в Алании.
Бюджетные — Паяллар и Авсаллар.
Топ-локации — Босфор.
Поиск объектов: международная недвижимость.
Полный каталог с красным Тапу и Исканом — в любом бюджете.
mysql root 密碼更改 | 豬窩 | 1092
Do you have a spam problem on this blog; I also am a blogger, and I was wanting
to know your situation; many of us have developed some nice methods and
we are looking to trade techniques with other folks, why not shoot me an email
if interested.