I have a remote MySQL server. I can log in from the client machine using:
mysql -h 172.16.0.7 -u mysqlUser -p
and it connects fine.
When I use a simple DBH connection in Perl, with same credentials, the MySql server comes back with
Access denied for user 'mysqlUser'@'172.16.0.5'.
That IP has been explicitly granted access in the database.
Both servers are running Centos 6.3. Perl is 5.10.1; MySQL is 14.14.