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 密碼更改 | 豬窩
Simply desire to say your article is as surprising. The clearness to your submit
is simply great and i could assume you're knowledgeable on this
subject. Well together with your permission let
me to grab your RSS feed to stay updated with coming near near post.
Thank you one million and please continue the enjoyable work.
mysql root 密碼更改 | 豬窩 | 763
Incredible Blog Article
Goodness , what an illuminating and meditative piece ! I found myself
affirming as I scanned through your dissection of this
vital issue .
Your assertions were thoroughly investigated and
articulated in a lucid, captivating manner.
I especially appreciated how you were empowered to extract
the core complexities and nuances at play , excluding streamlining or glossing over
the challenges .
This write-up has given me a significant amount to mull over.
You've certainly broadened my understanding and
shifted my mindset in some meaningful forms.
Thank you for devoting the energy to share your expertise on this issue.
Posts like this are extremely a precious input
to the discussion . I look forward to seeing what other thought-provoking information you have
in supply.
mysql root 密碼更改 | 豬窩 | 1094
https://watchnow.gomuviz.com/
Excellent blog you have here but I was wondering if you knew of any community forums
that cover the same topics discussed in this article? I'd
really like to be a part of community where I can get feed-back from other knowledgeable people that
share the same interest. If you have any recommendations, please
let me know. Thanks!
mysql root 密碼更改 | 豬窩 | 763
Amazing! Its actually amazing post, I have got much clear idea on the
topic of from this post.
mysql root 密碼更改 | 豬窩 | 763
I uncovered your blog post to be a thought-provoking
and sagacious examination of the present state of the market .
Your evaluation of the critical shifts and hurdles confronting enterprises in this domain was unusually
powerful .
As an enthusiastic advocate of this issue , I would be to
continue this exchange in more depth . If
you are willing, I would graciously exhort
you to investigate the captivating possibilities open at WM CASINO.
Our system features a advanced and secure atmosphere for
networking with kindred spirit devotees and procuring a abundance
of knowledge to strengthen your comprehension of this fluctuating industry .
I look forward to the potential of joining forces with you in the approaching future