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 密碼更改 | 豬窩 | 182
Buat kamu yang ingin mempermainkan permainan judi online pragmatic play, kamu bakal enggak berasa bosan karena kamu tidak hanya mempermainkan satu game saja
bakal tapi juga beberapa macam permainan judi
pragmatic play. Tetapi awalnya bermain situs pragmatic play ada saatnya kamu perlu kenali apa taktik pas buat memenangkan permainan judi online ini karena oleh pahami trik mainkan kamu tentu saja bisa bermain game pragmatic play dengan sangat sederhana.
mysql root 密碼更改 | 豬窩
Pretty! This has been a really wonderful post.
Thanks for supplying these details.
mysql root 密碼更改 | 豬窩
Good article. I will be going through many of these issues aas well..
mysql root 密碼更改 | 豬窩
It's very trouble-free to find out any topic on web as compared to books, as I found this paragraph at this web
page.
mysql root 密碼更改 | 豬窩
Very good website you have here but I was wondering if you
knew of any user discussion forums that cover the same topics talked about here?
I'd really love to be a part of community where
I can get feedback from other experienced individuals that share the same
interest. If you have any suggestions, please let me know.
Thanks!