mysql - fail to change root password

[satimis]

Hi folks,

Ubuntu 910 64bit

# mysqladmin -u root p'oldpasswd' password newpasswd

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

However with the oldpasswd I can login mysql.

$ mysql -u root -p
Enter password: oldpasswd
...
mysql >


Please help. TIA


B.R.
satimis

[sathiya]

change the password using the other methods then: How To Change MySQL Root Password

[satimis]

change the password using the other methods then: How To Change MySQL Root Password

Hi sathiya,

Thanks for your advice and URL

Problem solved. I left out "-" before p'oldpasswd'

satimis