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 密碼更改 | 豬窩 | 550
I blog often and I seriously thank you for your information. The article has really
peaked my interest. I am going to take a note of your site and keep checking
for new information about once a week. I opted in for your Feed too.
mysql root 密碼更改 | 豬窩 | 445
Hey there! Quick question that's entirely off topic.
Do you know how to make your site mobile friendly? My weblog looks
weird when browsing from my iphone4. I'm trying to find a template or plugin that might be able to fix this problem.
If you have any recommendations, please share.
Thank you!
mysql root 密碼更改 | 豬窩 | 1155
The following blog site is good. Articles or blog
posts just like this are continuously not considered,
if truth of the matter be told. In many instances the greatest
of the Internet isn't the most broadly elevated articles and other content, though instead almost everything other than them, the forgotten people with web logs that are in fact considerably more suitable compared
to those of vital influencers. Now this is this
type of a blogging site. My partner and I will furnish useful
information, especially any time not prompted to do so.
First of all is, continue posting. Second is, keep crafting constantly.
Lastly is, make use of your individual blog page to build
your personalised presence. I am certainly not a blogger per se; I am
honestly a Postnatal Massage Therapist. I
perform Perinatal Massage Therapy, being able
to help women to get well after having a newborn. It's rewarding work.
That is precisely what I dedicate virtually all of my precious time
carrying out, but I have as well treasured posting from the point in time I was a teen. I am
a well-read person and each calendar year I read through a bunch far
higher than myself personally. hahaha In the upcoming four
seasons, could be I should get serious in relation to writing a blog.
The matter is, it cannot really an outline; the work of
crafting and creation routinely will make a blogging site blossom
in some amount of time.
mysql root 密碼更改 | 豬窩 | 1155
This amazing blog site is motivating. Articles and reviews like this are
sometimes brushed aside, if reality be shared. Oftentimes the finest of the
World-wide-web isn't the very most widely publicized subject material, nonetheless rather everything else, the pushed aside
public with weblogs that are seriously very good more desirable as opposed to the ones of
vital prominent people. Now this is this type of a website.
I are going to present guidance, perhaps any time not encouraged to
do this. First is, maintain penning. Secondary is, maintain creating
continually. Thirdly is, use your personal blog to create your unique style.
I am absolutely not a author per se; I am honestly
a Postnatal Massage Practitioner. I practice Postpartum Massage Therapy,
facilitating women to get well soon after having a infant.
It's worthwhile work. That is exactly what I expend almost
all of my hours undertaking, though I have of course adored publishing from the period I was young.
I am a well-read human being and just about every single year or so I go through a pile far higher compared with myself personally.
rofl In the following four seasons, it could be I will get really serious related to running a blog.
The thing is, it cannot just a perception; the act of creating and submission regularly tends to make a blog mature in time.
mysql root 密碼更改 | 豬窩 | 1338
Do you have any video of that? I'd love to find out more details.