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 密碼更改 | 豬窩 | 550
Hi there would you mind letting me know which webhost you're
working with? I've loaded your blog in 3 completely different internet browsers and
I must say this blog loads a lot faster then most.
Can you suggest a good web hosting provider at a fair price?
Many thanks, I appreciate it!
mysql root 密碼更改 | 豬窩 | 625
I was able to find good information from your content.
mysql root 密碼更改 | 豬窩 | 625
Thanks for your marvelous posting! I certainly enjoyed
reading it, you're a great author. I will be sure to bookmark your blog and will eventually come back someday.
I want to encourage yourself to continue your great posts, have a nice afternoon!
mysql root 密碼更改 | 豬窩 | 1240
Hmm it looks like your blog ate my first comment
(it was extremely long) so I guess I'll just sum it up
what I submitted and say, I'm thoroughly enjoying
your blog. I too am an aspiring blog blogger but I'm still new to
everything. Do you have any tips and hints for novice blog writers?
I'd genuinely appreciate it.
mysql root 密碼更改 | 豬窩 | 763
First thing, congratses on this message. This is definitely
fantastic yet that's why you constantly crank out my close
friend. Great articles that our company can easily drain our teeth in to as well as definitely head to work.
I like this blogging site post as well as you understand you're.
Considering that there is so much included yet its own like
just about anything else, blogging can easily be actually extremely difficult for a
whole lot of folks. Whatever takes opportunity as well as most of us possess
the very same volume of hrs in a day thus put
all of them to excellent use. All of us must begin someplace and also
your plan is actually perfect.
Wonderful reveal and also thanks for the reference below, wow
... Exactly how awesome is that.
Off to share this message now, I really want all those brand-new blog owners to observe that if they
do not currently have a planning 10 they carry out now.