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 密碼更改 | 豬窩 | 1156
great publish, very informative. I ponder why the other experts of this sector do not understand this.
You must continue your writing. I'm sure, you've a huge readers'
base already!
mysql root 密碼更改 | 豬窩 | 763
My brother suggested I might like this blog. He was once totally right.
This publish truly made my day. You cann't believe just how a lot time
I had spent for this info! Thanks!
mysql root 密碼更改 | 豬窩 | 1338
https://nenekslot.pro/ NenekSlot adalah sebuah login situs judi Nenek slot gacor resmi terpercaya dengan beragam jenis game
terbaik untuk dimenangkan. Situs NenekSlot selalu
akan memberi anda hiburan menarik yang akan membuatnya sangat mengasyikkandan menghasilkan uang.
Jadi, mulailah proses taruhan yang anda miliki di situs game terbaik,terpercaya dan terlengkap.
Bahkan hanya dengan bergabung di login situs judi NenekSlot slot gacor resmi terpercaya
sudah bisa dipastikan proses taruhan anda akan jauh lebih aman,
nyaman dan aman.
mysql root 密碼更改 | 豬窩 | 230
Yes! Finally something about fun88.
mysql root 密碼更改 | 豬窩
of course like your web-site but you need to test the spelling
on several of your posts. Several of them are rife with spelling issues and I find it
very bothersome to inform the reality then again I will definitely come
back again.