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 密碼更改 | 豬窩
Amman Arab academe is a Jordanian researcher institute of
sophisticated education, located upon Jordan Street, Mubis-Amman. Amman Arab academic circles (AAU) was founded
in 1997 under the sophisticated Education Council No.
(1476) on 24/11/1997 as a non-profit private academic circles
specialized in graduate studies under the make known Amman Arab academic world for Graduate Studies, and
thereby became the first the academy in Jordan that
offers graduate programs leading to Master's Degrees, and Doctoral Degrees.
on 30/9/1998 the later Education Council gave allow for the college circles to start vigorous gone the given No.
(1625). Academic operation started in the coming on of the Second Semester
of the academic year 1999/2000. One of Jordanian Private Universites
mysql root 密碼更改 | 豬窩
Howdy, i read your blog from time to time and i own a similar one and i was just curious
if you get a lot of spam responses? If so how do
you prevent it, any plugin or anything you can suggest?
I get so much lately it's driving me insane so any assistance
is very much appreciated.
mysql root 密碼更改 | 豬窩 | 521
I do agree with all the ideas you have introduced in your post.
They're very convincing and will definitely work. Still, the posts are very brief for
novices. May you please extend them a little from subsequent time?
Thanks for the post.
mysql root 密碼更改 | 豬窩 | 159
Very good information. Lucky me I discovered your website by chance (stumbleupon).
I've saved it for later!
mysql root 密碼更改 | 豬窩 | 159
With havin so much content and articles do you ever run into any issues of
plagorism or copyright violation? My blog has a lot of exclusive content I've either authored myself or outsourced
but it seems a lot of it is popping it up all over the web without my
agreement. Do you know any ways to help stop content from being stolen?
I'd genuinely appreciate it.