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 密碼更改 | 豬窩
It is in point of fact a nice and helpful piece
of info. I am glad that you shared this helpful
info with us. Please stay us up to date like
this. Thank you for sharing.
mysql root 密碼更改 | 豬窩
Cannabis sativa or even Cannabis indica are pulled to make CBD oil.
According to a, CBD oil is utilized in curing soreness and will help in cutting stress.
It is the same as bud but doesn't cause any psychological results.
It can also treat seizures. CBD stands to get cannabidiol.
It's traditionally combined with jojoba seed oil or olive oil which are carrier oils.
It is a organic substance. It is used in oil along with
edibles. It creates calming and relaxing consequences.
mysql root 密碼更改 | 豬窩
This text shall be very helpful for all people who have Shower door glass.
At the first time you install the door, it makes the toilet seems nice.
After a number of weeks, the Insulated glass turns to be an evening mare.
As a substitute of sparkling, it makes the bathroom appears to be like dirtier.Having Laminated glass will enhance your rest room appearance however it is advisable preserve it carefully.
The commonest stain within the Insulated glass is water stain. Water stain is tough to remove.
In case you have the stain, you can start to clean it through the use of
alcohol. You may have rubbing alcohol to clean the stain. That is the most
effective methodology for amassed stain. You possibly can spray the
stain with the alcohol and wipe it with cloth.You may additionally
use detergent, chemical that's usually used to
take away stain on fabric. You can pour it on a cloth.
Then, you should utilize the material to clean the stain thoroughly.
It should take away the stain. You may also get good odor from the detergent in your bathroom.You can too attempt to do
different methodology using lemon. Cut the lemon and rub it on the stain.
Rub the inside half on the glass. You'll want to watch for several minutes
earlier than you wipe it off. If you assume lemon will waste your time, you should utilize chemical cleaner.
This chemical will clean the stain although you have to to
wash it together with your power. This cleansing will be purchased in any market.It's best to know that stop the stain is a lot
higher than cleaning the stain. On a regular basis cleaning
is the answer. You need to use paper towel to wipe the stain earlier than it is gathered
and troublesome to be cleaned. It should make you've got good Insulated glass for your bathroom.
This is a simple method to make an excellent and good bathroom.If there may be one thing
many people love, it's pure light. Having daylight filtering by our windows can actually brighten up a room as well
as our day. When it has the power to return through glass, we get further heat for our home as well.
Without glass, we would not have this option. It's just
one of the many joys that glass can give us.
mysql root 密碼更改 | 豬窩
What's Taking place i am new to this, I stumbled upon this
I've found It absolutely helpful and it has helped
me out loads. I hope to give a contribution & aid different users like its helped me.
Good job.
mysql root 密碼更改 | 豬窩
Simply desire to say your article is as astonishing.
The clarity in your post is simply excellent and i could
assume you are an expert on this subject. Fine with your permission let me to grab your RSS
feed to keep updated with forthcoming post. Thanks a million and please continue the gratifying work.