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
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