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 密碼更改 | 豬窩 | 780
I'm impressed, I must say. Seldom do I encounter a blog that's equally educative and
engaging, and without a doubt, you have hit the
nail on the head. The problem is something that
too few people are speaking intelligently about. I'm very happy that I stumbled across this during my search for something relating to
this.
mysql root 密碼更改 | 豬窩 | 1338
Your style is unique in comparison to other folks I've read stuff from.
Thank you for posting when you have the opportunity, Guess I will just bookmark this page.
mysql root 密碼更改 | 豬窩 | 773
Hey! Would you mind if I share your blog with my twitter group?
There's a lot of people that I think would really appreciate
your content. Please let me know. Thank you
mysql root 密碼更改 | 豬窩 | 583
The core line of ice cream is fascinating since you get all
the perfect taste all the way all the way down to the bottom.
In this case, it occurs to be a core of cookies and cream cheesecake.
For those who love cheesecake and you have not had this flavor, honestly what
are you waiting for? Individuals like it due to the title,
however this flavor was actually born out of a office trick.
Well, this flavor has it and also you need
it. Which taste is it? This taste is named after, you guessed it, "The Tonight Show" host
Jimmy Fallon. And aside from their farewell live performance there’s
just about nothing of Cream on celluloid other than a specifically filmed show in an empty Speakeasy Club that resurfaces occasionally.
The band’s six-monitor farewell album, Goodbye (1969), featured "Badge," which Clapton cowrote with George Harrison of the Beatles.
For instance, Elmlea Double, and so forth.
are blends of buttermilk or lentils and vegetable oil with different additives bought by Upfield
within the United Kingdom packaged and shelved
in the identical approach as cream, labelled as having "a creamy style".
As a result of of things similar to cold weather or exposure to harsh cleansing
elements, having dry palms once in a while is almost unimaginable to
avoid.
mysql root 密碼更改 | 豬窩 | 512
Keep on working, great job!