Connecting to MySQL database on a hosted server - need incoming server IP/domain
We have a hosted MySQL database siting on our website hosting service (Dreamhost).
I've created a MySQL connection in reports with the credentials for the database, but the connection fails with "
Access denied for user zohoreports. Login failed.".
I know the credentials are correct, because when I connect to the database using the 'MySQLWorkbench' off my laptop, it connects just fine (I Whitelisted my laptop's IP address).
The Dreamhost service restricts access based on the inbound IP address or domain. I've added '*.zoho.com' as a Whitelisted server, but I suspect that the reports cube accesses our dreamhost service via another domain.
Is is possible to find out the IP address, host or domain name of the Zoho Reports server that is attempting the connection to our MySQL database?
That way I can whitelist the server...