remoteMYSQL access issues

[medalto]

I want to download ( for local use ) my DB from my host using mysqldump
eg
mysqldump --user=xxxx -p --host=myhostingco.com -A -v >/tmp/DB.sql

It works with my xx.xx.xx.xx IP entered in the server remoteMySQL config , but not with the FQDN I have that points to my machine.

My hosting support point me to your documentation that says it should work with FQDN . but mysqldump from my local machine isnt allowed access with the FQDN added to the remoteMYSQL config and the xx.xx.xx.xx removed.

Is it
- the documentation
-me
-the hosting setup

that is getting this wrong ?

 

[GOT]

Your hosting provider may have skip-name-resolve enabled, plus I think the mysql treats [email protected] different than [email protected] You could try putting your host name in the rmeote access field, but I am not sure offhand if that takes domains names.

 

[cPanelLauren]

You can add a hostname rather than an IP:
Host (% wildcard is allowed)

And it's noted in the documentation: Remote MySQL | cPanel & WHM Documentation

When you create a user through the cPanel interface, it creates the following automatically

MariaDB [(none)]> select host, user from mysql.user where user like 'imauser%';
+-------------------------+---------+
| host                    | user    |
+-------------------------+---------+
| <MYIPADDRESS>          | imauser |
| remoteserver.com             | imauser |
| localhost               | imauser |
| server.anotherremoteserver.tld | imauser |
+-------------------------+--

But with that being said, it sounds a LOT like your provider may have skip-name-resolve enabled in their my.cnf file as @GOT suggested.