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 密碼更改 | 豬窩
Hi my loved one! I wish to say that this article is amazing, great written and
include almost all vital infos. I'd like to look extra posts like this .
mysql root 密碼更改 | 豬窩 | 763
This content of this blog article is really
compelling. I appreciated the way you scrutinized the
different issues so thoroughly and unambiguously.
You enabled me procure new perspectives that I never previously deliberated
before. Thank you for disseminating your mastery and expertise - it has empowered me to
improve myself further .
I uniquely appreciated the ground-breaking perspectives you
revealed, which enlarged my awareness and intellect in worthwhile
trajectories . This blog is organized and compelling , which is essential for information of this
caliber .
I look forward to review supplementary of your
compositions in the times ahead , as I'm
confident it will continue to be informative and
enable me continue improving. I offer my appreciation !
mysql root 密碼更改 | 豬窩
Hi there! This post couldn't be written any better! Reading through this post
reminds me of my previous roommate! He continually kept preaching about this.
I am going to send this information to him. Pretty sure he will have a very good read.
I appreciate you for sharing!
mysql root 密碼更改 | 豬窩
I go to see daily a few websites and sites to read articles,
but this weblog presents quality based articles.
mysql root 密碼更改 | 豬窩
「1280 × 720」の画質なら無料でダウンロードできるので、こちを選択して「ビデオを録画」をクリックします。