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 密碼更改 | 豬窩 | 763
Have you ever considered about including a little bit more
than just your articles? I mean, what you
say is valuable and all. However think of if you added some great
visuals or videos to give your posts more, "pop"! Your content is excellent but with
pics and video clips, this website could certainly be one of the best in its field.
Terrific blog!
mysql root 密碼更改 | 豬窩 | 2066
whoah this weblog is fantastic i really like reading your posts.
Keep up the great work! You understand, many people are looking around for this information, you
can help them greatly.
mysql root 密碼更改 | 豬窩 | 2066
I couldn't resist commenting. Perfectly written!
mysql root 密碼更改 | 豬窩 | 1092
https://top11au.com
This design is wicked! You certainly know how to keep a
reader amused. Between your wit and your videos, I was
almost moved to start my own blog (well, almost...HaHa!) Wonderful job.
I really loved what you had to say, and more than that, how you presented it.
Too cool!https://top11au.com
mysql root 密碼更改 | 豬窩 | 2066
This is very interesting, You're a very skilled blogger. I
have joined your feed and look forward to seeking more of your excellent post.
Also, I've shared your website in my social networks!