I am running into a bit of a problem here. I have a mysql server setup on an Ubuntu 12.04 distro. After the initial install I have been using MySQL Workbench to do all my db creation and administrative tasks such as backup\restore etc.
My MySQL Version:
mysql Ver 14.14 Distrib 5.5.24, for debian-linux-gnu (i686) using readline 6.2
So now we are trying to automate the backup with a custom service. I logged in with putty to the server and tried to login to the MySQL shell using this format.
myuser@skydb1:~$ mysqldump -u root -p mydb Enter password: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
Initially I went back and tried to re-authenticate with the Workbench to make sure I was using the correct credentials and I was. Going back to the server and attempting to login via the shell I got the same error.
In the screenshot below you can see that the Workbench indicates that the root user has all appropriate privileges.
The password was removed.
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'mypassword' WITH GRANT OPTION GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION