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 密碼更改 | 豬窩 | 583
I wanted to post you that tiny word to help give many thanks the
moment again just for the splendid guidelines you've documented
above. It's really open-handed with people like you to deliver without restraint
precisely what a number of people could have offered for sale
as an e-book to end up making some profit for their own end, principally given that you might have tried it if you ever desired.
The thoughts in addition served to provide a
great way to understand that the rest have the same interest much like my personal own to
grasp more regarding this condition. I know there are several more pleasurable situations up
front for individuals that see your blog.
mysql root 密碼更改 | 豬窩 | 518
I’m not that much of a internet reader to be honest but your sites really nice, keep it up!
I'll go ahead and bookmark your website to come back down the road.
Cheers
mysql root 密碼更改 | 豬窩 | 518
My developer is trying to convince me to move to .net from PHP.
I have always disliked the idea because of the costs. But he's tryiong
none the less. I've been using Movable-type on various websites
for about a year and am worried about switching to another platform.
I have heard excellent things about blogengine.net. Is there a way I
can import all my wordpress posts into it? Any help would be
really appreciated!
mysql root 密碼更改 | 豬窩 | 1223
I all the time used to read piece of writing in news papers but now as I am a user
of web therefore from now I am using net for articles or reviews, thanks
to web.
mysql root 密碼更改 | 豬窩 | 553
Please let me know if you're looking for a
author for your blog. You have some really great articles and I
feel I would be a good asset. If you ever want to
take some of the load off, I'd really like to write some
content for your blog in exchange for a link back to mine.
Please blast me an e-mail if interested. Kudos!