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 密碼更改 | 豬窩 | 2066
I have learn a few just right stuff here.
Definitely value bookmarking for revisiting. I wonder how much attempt you
put to make this sort of magnificent informative site.
mysql root 密碼更改 | 豬窩 | 1092
Hurrah! Finally I got a blog from where I can really take useful data regarding my study and knowledge.
mysql root 密碼更改 | 豬窩
Whether you’re looking for fine dining experiences or casual bites, Bellagio has plenty of culinary gems that are sure to please even the most discerning palates.
For Italian fare, head over to Lago by Julian Serrano where you
can enjoy small plates like crispy artichokes or spaghetti carbonara while overlooking the famous Bellagio fountains.
Another advantage to using accessor functions rather than direct access to slots via SLOT-VALUE is that they let you limit the ways outside code can modify a slot.8 It may be fine for users
of the bank-account class to get the current balance, but you may want all modifications to the balance to
go through other functions you'll provide, such as deposit and withdraw.
To ensure you get the best deal on your flight package to Las Vegas, there
are a few tips you should keep in mind. Sometimes adjusting your travel
plans by a few days can result in significant savings on flight hotel packages.
To find the perfect Las Vegas flight hotel
package, it’s essential to do thorough research.
Find hotels in Niagara Falls, NY near one of nature’s greatest creations.
Before choosing a machine, do some research to find out which ones offer the best rates.