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 ???? | ??
mysql root 密碼更改 | 豬窩
Its such as you learn my thoughts! You seem to know so much
approximately this, like you wrote the e-book in it or something.
I believe that you could do with some p.c. to force the message house
a bit, however other than that, this is magnificent blog.
An excellent read. I will definitely be back.
mysql root 密碼更改 | 豬窩
Direct the view time for your website to enable them to share their thoughts about your statement.
One other thing that you'd like to take into account is limiting
access to the network, notably if you embark on any kind of
secure printing or if you might have areas of the network that are for secure files.
Depending on the size and scope with the organization, these improvements can yield significant ROI.
mysql root 密碼更改 | 豬窩
In the fight against QR codes, you can find three significant reasons being shown to offer the theory the
two-dimensional barcodes just aren't clicking with Americans:
. This type of technology utilizes specialized
equipment, teaching materials and services that
will enable these individuals perform and function inside their surroundings.
It was foreseen the variety of 3D printers in homes
and business establishments raises rapidly.
mysql root 密碼更改 | 豬窩
Hi there it's me, I am also visiting this web site regularly,
this website is genuinely fastidious and the visitors are truly
sharing nice thoughts.