mysql 1045 access denied with phpMyAdmin

[gijsbert]

One of my users is unable to connect to his database using phpMyAdmin. The query is:

LOAD DATA INFILE '/tmp/phpYXZFfZ' INTO TABLE `count` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'

And mysql reports:

#1045 - Access denied for user '<USERNAME>'@'%' (using password: YES)

The funny part is that I can connect without any problems from a shell like this:

mysql -u <USERNAME> -p<PASSWORD> -D <DATABASE_NAME>

Any ideas? This server has been recently migrated from plesk9 to plesk11.5, running on a centos6 OS.

Kind regards,

Gijsbert

 

[UFHH01]

If a database - user should have the rights to use the "LOAD DATA INFILE" - options, he/she MUST have the "File" privilege. You can set this additional option over the user rights management in phpmyadmin ( admin/root rights required to change it ).