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 密碼更改 | 豬窩 | 1092
It's awesome for me to have a web page, which
is good in support of my experience. thanks admin
mysql root 密碼更改 | 豬窩
Hey there! Someone in my Myspace group shared this
site with us so I came to look it over. I'm definitely loving the information. I'm book-marking and will be
tweeting this to my followers! Superb blog and outstanding style
and design.
mysql root 密碼更改 | 豬窩 | 763
Hi there! I could have sworn I've visited this website before but after
looking at many of the articles I realized it's new to me.
Anyways, I'm definitely pleased I stumbled upon it and I'll be book-marking it and checking back often!
mysql root 密碼更改 | 豬窩 | 1209
We also feature classic porno zoophilia scenes that are hard to find elsewhere.
Next, explore the deep collection of fuck zoo porno clips we offer.
Immerse yourself in the world of anal porno zoo porno dog video.
adult movie
Watch here:
https://vdrygtort.ru/
mysql root 密碼更改 | 豬窩 | 763
Thanks to my father who stated to me on the topic of this blog, this webpage is truly awesome.