[root@testlinux ~]# mysqladmin -u root password mysql
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user
'root'@'localhost'
(using password:
NO)'
出現(xiàn)這種提示表明無法修改密碼...那究竟如何才能修改密碼...
以下介紹的方法...修改roota密碼....即使root密碼忘了 也適用。。。。
step1:停止mysql服務(wù)
step2：啟動mysqld服務(wù)，加上--skip-grant-tables選項
step3:用root用戶連接mysql（這時不用輸入密碼即可進(jìn)入）
step4:為root用戶設(shè)置新密碼
Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.
mysql> use mysql;
Reading table
information for completion of table and column names
You can turn off this
feature to get a quicker
startup with -A
Database changed
mysql> update user set
password=PASSWORD("hello")where user="root";
Query OK, 3 rows affected (0.03
sec)
Rows matched: 3
Changed: 3 Warnings: 0
mysql> flush
privileges;
Query OK, 0 rows affected (0.01 sec)
mysql>
quit
step5:重啟mysql服務(wù)
OK...現(xiàn)在用root連接你會發(fā)現(xiàn)密碼已經(jīng)改過來了。。^_^