I made the mistake of using special characters as my MySQL password during the Perfect Server install for CentOS 5.2. I was able to successfully reset my password as Till explains here. Unfortunately, when I do: Code: mysqladmin -h server1.mydomain.com -u root password mynewpassword I get: Code: mysqladmin: connect to server at 'server1.mydomain.com' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' I AM using the correct password as I have reset it 3 times to confirm, yet I still cannot connect. Please help...
The above command is only used when no password is set. The password mynewpassword is not the current password. to change a password, use this command: mysqladmin -p -h server1.mydomain.com -u root password mynewpassword the command asks then for the current password.
