how to create a Mysql db user with read access to filesystem

Question

Hi,

I'm trying to run mysql hot copy and I want to create a user account to run that process. However, whenever I create a user account (granting it specific priviledges) and run mysqlhotcopy there is always the error

Unable to retrieve list of tables in {dbname}: DBD::mysql::db selectall_arrayref failed: Can't read dir of './{dbname}/' (errno: 13) at /usr/bin/mysqlhotcopy line 779.

({dbname} = my db name)

I tried creating the user with all privileges and still didn't work.

Creating with the sql commands:

`CREATE USER 'backup'@'localhost' IDENTIFIED BY  'pass';

GRANT ALL PRIVILEGES ON * . * TO  'backup'@'localhost' IDENTIFIED BY  'pass' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;`

Any help greatly appreciated!

Thanks, nv