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 密碼更改 | 豬窩 | 1341
Wow that was odd. I just wrote an extremely
long comment but after I clicked submit my comment didn't show up.
Grrrr... well I'm not writing all that over again. Regardless, just
wanted to say superb blog!
mysql root 密碼更改 | 豬窩 | 1224
Thank you for the auspicious writeup. It in fact was a amusement account it.
Look advanced to more added agreeable from you!
By the way, how could we communicate?
mysql root 密碼更改 | 豬窩 | 763
Hello, I enjoy reading through your post. I like to write a
little comment to support you. https://promokod-dlya-1xbet.xyz/
mysql root 密碼更改 | 豬窩 | 1335
Go to Photos, select your photographs and click Export.
If a company known as "Malevoware" is asking you to fairly please click the "accept" button on their popup so you can surf
the web with ease, greatest you do some internet searching to see what individuals are saying about the corporate.
Your peer-to-peer network might recommend one, or you'll
be able to search the Internet for one. There can be an excellent
bit of "finish of the world" rhetoric floating round on the web.
With a paring knife, make four or 5 lengthwise
cuts, almost to the stem end. Spiral-roll about 1-1/2 inches right
into a tight circle; depart the rest of the chenille stem straight.
The queen conch can stay so long as forty years and grow up
to 12 inches lengthy. Folks writing software in 1970 had no motive to consider
the software would nonetheless be in use 30 years later.
The tomatoes and lettuce will keep growing, and the folks that pick it can keep choosing, and the
cannery will still can it, the truck drivers will still drive their trucks and the grocery stores will nonetheless sell it.
mysql root 密碼更改 | 豬窩
Hey! I realize this is somewhat off-topic but I had to ask.
Does running a well-established blog such
as yours take a lot of work? I'm completely new to running a blog but I
do write in my diary daily. I'd like to start a blog so I
can share my own experience and thoughts online. Please let me know if you have any suggestions or tips
for brand new aspiring bloggers. Appreciate
it!