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 密碼更改 | 豬窩
Gambling is obviously adventurous whether it's
in a casinos or some other place. People used to gamble in casinos previously but with the accessibility to online casinos,
people started gambling from their desktops.
One does not need very high configuration of a method to play online casino games.
You can simply play on the internet site of the organization or can download their software.
Moreover, you will get the internet casino bonus on most of the games.
mysql root 密碼更改 | 豬窩
It's a shame you don't have a donate button! I'd certainly donate to this outstanding blog!
I suppose for now i'll settle for bookmarking and adding your RSS feed to
my Google account. I look forward to new updates and will talk about this website with my Facebook group.
Talk soon!
mysql root 密碼更改 | 豬窩
What's up, just wanted to mention, I loved this
article. It was inspiring. Keep on posting!
mysql root 密碼更改 | 豬窩
I was wondering if you ever thought of changing the page layout of your blog?
Its very well written; I love what youve got to say.
But maybe you could a little more in the way of content
so people could connect with it better. Youve got an awful lot of text for only having 1 or 2 images.
Maybe you could space it out better?
mysql root 密碼更改 | 豬窩
Hi there, You have done a fantastic job. I'll certainly digg it and personally suggest to my friends.
I'm confident they'll be benefited from this web site.