I am unable to access mysqladmin on an Ubuntu server. I have tried these 3 commands and they all fail.
ec2-consistent-snapshot
mysqladmin -u root password 'password'
/usr/bin/mysqladmin -u root password 'password'
Error message:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
I can access via phpMyAdmin using root & password.
netstat -an
returns a listening port
127.0.0.1:3306 0.0.0.0:* LISTEN
I have also restarted the mysql service but that hasn't changed anything.
How can I fix this?