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 密碼更改 | 豬窩
I was suggested this blog by my cousin. I am not
sure whether this post is written by him as nobody else know such detailed about my problem.
You are amazing! Thanks!
mysql root 密碼更改 | 豬窩
I think the admin of this web page is truly working hard for his web
page, as here every material is quality based material.
mysql root 密碼更改 | 豬窩
Hey there this is kinda of off topic but I was wondering if
blogs use WYSIWYG editors or if you have to manually code with HTML.
I'm starting a blog soon but have no coding skills so I wanted to get guidance from someone with experience.
Any help would be enormously appreciated!
mysql root 密碼更改 | 豬窩
Hello there, I found your website by way of Google at the
same time as looking for a comparable matter, your
site came up, it appears to be like great.
I have bookmarked it in my google bookmarks.
Hello there, simply became alert to your blog through Google, and found that it is really informative.
I am going to watch out for brussels. I will appreciate in the event
you proceed this in future. Lots of other people will likely be
benefited out of your writing. Cheers!
mysql root 密碼更改 | 豬窩
For the reason that the admin of this site is working, no question very
quickly it will be famous, due to its feature contents.