remoteMYSQL access issues

medalto

• February 09, 2020 05:11

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

  • February 09, 2020 19:15

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

  0
• 

  cPanelLauren

  • February 14, 2020 00:10

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

  0

Please sign in to leave a comment.