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 密碼更改 | 豬窩 | 1222
Very good blog! Do you have any suggestions for aspiring writers?
I'm planning to start my own site soon but I'm a little
lost on everything. Would you suggest starting with a free platform like Wordpress or go for a paid option? There are so many options out there that I'm
completely confused .. Any recommendations?
Appreciate it!
mysql root 密碼更改 | 豬窩 | 1270
Wow, superb blog layout! How long have you been blogging for?
you make blogging look easy. The overall look of your website is great,
let alone the content!
mysql root 密碼更改 | 豬窩 | 1241
I know this web page offers quality depending articles
and additional data, is there any other web page
which presents these data in quality?
mysql root 密碼更改 | 豬窩
I go to see day-to-day a few web pages and information sites
to read content, however this website provides quality based articles.
mysql root 密碼更改 | 豬窩
Apostas esportivas, apostas eSports - Ganhe até X2000 jogos de aviador por
dinheiro
apostas de futebol da euroliga