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 密碼更改 | 豬窩
After all, it isn't really difficult for website visitors to pick up on what
you're considering for the Internet just by intercepting the signals.
Answer: Arcada, California - Useless Fact: Brothers Dick and
Mac Mc - Donald open a hot dog stand referred to
as the Airdome in Arcadia, California. There are corresponding cosplay costumes as well
as the cosplay accessories for every ones in the same time.
mysql root 密碼更改 | 豬窩
We are a bunch of volunteers and starting a new scheme in our community.
Your website provided us with valuable information to work on.
You have done an impressive task and our whole neighborhood will probably be grateful
to you.
mysql root 密碼更改 | 豬窩
I am sure this piece of writing has touched all the internet people, its really really good article
on building up new webpage.
mysql root 密碼更改 | 豬窩
Pretty section of content. I just stumbled upon your website and in accession capital to assert that
I acquire actually enjoyed account your blog posts. Anyway I will be subscribing to your augment and even I achievement you access consistently fast.
mysql root 密碼更改 | 豬窩
Cbd oil that works 2020
Hi there, the whole thing is going fine here and ofcourse every one is sharing facts,
that's actually excellent, keep up writing. best cbd oil for pain http://tinyurl.com/cbd-oil-that-works-2020 cbd
oil that works 2020 http://tinyurl.com/cbd-oil-that-works-2020