Solved MySQL backup user

[fred974]

Hello,

I am trying to create a simple MySQL user to execute all my backups.

CREATE USER 'dbbackup'@'localhost' IDENTIFIED BY 'MySecretPassword';
GRANT SELECT ,
RELOAD ,
FILE ,
SUPER ,
LOCK TABLES ,
SHOW VIEW ON * . * TO  'dbbackup'@'localhost'k IDENTIFIED BY 'MySecretPassword' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

When I run my backup script, I get the following error:

Warning: Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'dbbackup'@'localhost' (using password: YES

This is the script that I use: backupDatabases.sh

Have I missed something obvious here?

Thank you
Fred

 

[fred974]

Found the problem..

I forgot to add SHOW DATABASES

CREATE USER 'dbbackup'@'localhost' IDENTIFIED BY 'MySecretPassword';
GRANT SELECT ,
RELOAD ,
FILE ,
SUPER ,
LOCK TABLES ,
SHOW DATABASES ,
SHOW VIEW ON * . * TO  'dbbackup'@'localhost'k IDENTIFIED BY 'MySecretPassword' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;