[root@server1 ~]# /usr/bin/mysqladmin -u root -p password mypassword
Enter password:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
service mysqld stop
mysqld_safe --skip-grant-tables &
use mysql
UPDATE user SET password=PASSWORD('新密码你设的') WHERE user='root';
FLUSH PRIVILEGES;
quit
service mysqld start
现在执行
/usr/local/mysql/bin/mysqladmin -u root -p password mypasswd //mypasswd为自己的密码
后,说
connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'