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 密碼更改 | 豬窩
umitkoy implant
umitkoy implant Üzerinde Bu Rapor inceleyin
mysql root 密碼更改 | 豬窩
Terrific post however , I was wanting to know if you could write a litte more on this
topic? I'd be very thankful if you could elaborate a little bit more.
Many thanks!
mysql root 密碼更改 | 豬窩
Hi there! Would you mind if I share your blog with my facebook group?
There's a lot of folks that I think would really enjoy your content.
Please let me know. Thanks
mysql root 密碼更改 | 豬窩
Good day! I just wish to give you a huge thumbs up for your excellent
info you have got right here on this post. I will be coming back to your site for more soon.
mysql root 密碼更改 | 豬窩
Sex-related videos can greatly improve your love life as well
as your sexual experience in more ways than one. They won't just impress your partner,
but can also bring you closer together when they are willing to join in the excitement.
You can search on the internet to find the most popular titles so you can choose the best
instructional video for you.So there you are. The most important
information you need to know about how sexual instructional videos can be used to help sort out your sex lifestyle for you.
Don't be a think about it until you've tried it yourself.
It might just be what you're looking for to make a difference in your
relationship.Men like to have sexual intimacy, and if a partner isn't readily accessible,
men may just have sex with himself. However, to accomplish that, many men turn to
a virtual lover that they see on their computer screen or between the pages of an adult-themed magazine.
In fact, taking matters to themselves is well-known as the best way to
take care of your penis and the majority of men have no penis problems at all by dipping into porn from time to the time.