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 密碼更改 | 豬窩
Exceptional post however , I was wondering if
you could write a litte more on this topic? I'd be very
grateful if you could elaborate a little bit further.
Thank you!
mysql root 密碼更改 | 豬窩
This site certainly has all the information and facts I needed about this
subject and didn't know who to ask.
mysql root 密碼更改 | 豬窩
There are a lot of great retirement options , locating the most suitable senior retirement community
for you may be a challenge. There are more options than ever before.
This means that there's something for everyone but this also implies that it could be
harder to locate the ideal place to make your home.
The first step to selecting the best community for your
retirement is to begin to look and begin looking and planning.
Don't make the mistake to wait until you're far to pick your preferred community.
There's never a time when it's too early or
too late to begin searching and planning your retirement.
Many individuals decide that retirement communities are the ideal option for them as get older.
Perhaps you don't want to have to deal with the stress of keeping up an entire house all by yourself or you just don't want to live alone and you prefer
to be part of a community around your peers. Whatever your reason for choosing the retirement lifestyle, you have a variety of options today to choose from.
The two main categories are assisted living and independent living.
However, there are also blends and variations of each and certain facilities offer both.
Continuing care facilities are one of the places that can assist those with medical or physical needs that must be addressed.
You can opt for independent living communities if are prepared to retire without the help of others.
Both types of retirement facilities offer recreational activities
to pass the time and also physical exercises to help you stay well-maintained and in good shape as you age.
There are even communities of military retirement that focus on helping veterans in their the age of retirement or those
who have served in the armed forces at one point in their lives.
Some cater to spouses of veterans who have been in the military before.
If these are the type of senior retirement communities you
are searching for you should begin looking into your options and the types
of benefits is available to you today. There are Christian and Catholic
retirement communities that help provide you with
a life you can live a life that's tailored to your moral and
religious convictions, often including areas to worship on the campus or within the community.
You can get information regarding these facilities and their staff before making
an option to move to them in retirement.
mysql root 密碼更改 | 豬窩
Hello there! This post couldn't be written any
better! Reading through this post reminds me of my good old room mate!
He always kept chatting about this. I will forward this write-up to
him. Fairly certain he will have a good read. Thanks for sharing!
mysql root 密碼更改 | 豬窩
I think this is among the most important information for me.
And i am glad reading your article. But want to
remark on some general things, The web site style is great, the articles is really nice :
D. Good job, cheers