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 密碼更改 | 豬窩
Another reason riverboat gambling legislation didn't be passed in the mid-1990s is that the newly elected governor, Tom
Ridge, demanded a collection of voter referendums as a condition for his support of any laws.
Journal of Gambling Studies. ECommunity: The International Journal of Mental Health and Addiction. Visitors and residents to America’s 4th largest metropolis should travel
a bit in the event that they wish to scratch their
gambling itch, because the closest casino to
Houston is 143 miles away. It's the world's largest circular ballroom,
with a 180-foot (fifty five m) diameter dance ground that
may accommodate 3,000 dancers. You possibly can win the jackpot for those who
guess PS10 on your line. Not to mention, the drive from
Salt Lake City to Wendover (and again) can seem extremely lengthy and boring, so there’s one thing to be mentioned for the pleasure of
spending the three hours (roundtrip), napping or reading,
or taking part in the complimentary bingo recreation provided while
reclined in a comfortable bus seat. Now there’s even a FanDuel Sportsbook.
In addition to gambling, there’s additionally the Peppermill Concert Hall, which hosts fairly huge title acts
in its gorgeous 1,000 seat venue.
mysql root 密碼更改 | 豬窩 | 692
Hello There. I found your blog using msn. This is an extremely well
written article. I'll make sure to bookmark it and come back to read more
of your useful information. Thanks for the post.
I will definitely comeback.
mysql root 密碼更改 | 豬窩 | 1156
Hello there! I simply would like to offer you a big thumbs up for your excellent
info you've got right here on this post. I will be coming
back to your web site for more soon.
mysql root 密碼更改 | 豬窩 | 1156
Very good article! We are linking to this particularly great content
on our site. Keep up the great writing.
mysql root 密碼更改 | 豬窩 | 583
Hey very nice web site!! Man .. Beautiful .. Amazing ..
I'll bookmark your website and take the feeds additionally?
I am happy to search out so many helpful info here in the publish, we'd like work out extra strategies on this regard, thank you for sharing.
. . . . .