Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL Workbench and Remote MySQL Environment

Discussion in 'Database Discussion' started by jamesterror, Aug 13, 2013.

  1. jamesterror

    jamesterror Member

    Joined:
    Feb 28, 2013
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi,

    I know MySQL Workbench isn't supported by cPanel, however we have a remote SQL server environment from main Web/Email servers and we are unable to connect to the MySQL with Workbench - We were curious whether anybody had succeeded with this.

    When we connect to a domain, with the cPanel username and password we get the error "Host ****** is not allowed to connect to this MySQL server" - I then had a browse and of course, added the Wildcard under Remote Hosts on cPanel, tried again. Still no luck.

    We then tried connecting directly to the remote MySQL server, this did not work either - Error 10060.

    We are running CSF Firewall on all servers, but the relevant ports are open to enable SQL connectivity.

    Any suggestions/ideas would be greatly appreciated.

    Thanks,
    James
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,468
    Likes Received:
    1,962
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello :)

    Have you tried adding the specific IP address you are connecting from to the "Remote Database Access Hosts" section in cPanel? Also, try adding the IP to the allow list in your firewall to see if that helps.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. jamesterror

    jamesterror Member

    Joined:
    Feb 28, 2013
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hey Michael,

    Thanks for the reply.

    I'm afraid that hasn't worked unfortunately :( Any other ideas?

    Thanks
    James
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,468
    Likes Received:
    1,962
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Have you tried disabling CSF completely and then attempting to access MySQL remotely to see if that makes a difference? Also, try adding the allowed IP address via:

    "WHM Home » SQL Services » Additional MySQL Access Hosts"

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. ThinIce

    ThinIce Well-Known Member

    Joined:
    Apr 27, 2006
    Messages:
    352
    Likes Received:
    7
    Trophy Points:
    168
    Location:
    Disillusioned in England
    cPanel Access Level:
    Root Administrator
    Just a thought - it doesn't really match up with the error being shown but what happens if you try connecting with a mysql user you've created under the cPanel account in question, rather than with the main account username and password?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice