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 i am kavin, its my first occasion to commenting anywhere, when i
read this piece of writing i thought i could also create comment due to this sensible article.
mysql root 密碼更改 | 豬窩 | 763
I discovered your blog post to be a thought-provoking
and insightful examination of the present state of the realm .
Your scrutiny of the pivotal changes and challenges confronting businesses in this
field was extraordinarily convincing .
As an passionate supporter of this matter , I would
be thrilled to extend this exchange in greater detail .
If you are eager , I would happily encourage
you to delve into the invigorating alternatives
accessible at WM CASINO. Our environment provides a state-of-the-art and safe
context for engaging with aligned professionals and securing a multitude of resources to elevate your comprehension of this transformative
field . I eagerly await the possibility of joining forces
with you in the near time
mysql root 密碼更改 | 豬窩
I am regular reader, how are you everybody? This piece of writing posted at this web site is in fact nice.
mysql root 密碼更改 | 豬窩 | 763
Salutations, peer reader. I must commend the author for their discerning and beautifully-written blog post.
The text was both instructive and pensive, leaving me with a more profound understanding of the issue at hand.
I would hope to extend an suggestion to unite with the renowned PUSSY888 organization. This platform offers a
universe of diversion and exhilaration, welcoming those who revere the more distinguished things in reality.
I exhort you to uncover the varied selections and captivate yourself
in the electrifying experiences that draw you. Your participation would be
most welcomed, and I anticipate with enthusiasm the privilege to interact with you in greater detail within this eminent cyber realm
mysql root 密碼更改 | 豬窩
I was curious if you ever thought of changing
the structure of your website? Its very well written; I love what youve got to say.
But maybe you could a little more in the way of content so
people could connect with it better. Youve got an awful lot of text
for only having one or two pictures. Maybe you could space it out better?