The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Cannot establish a mysql connection between webhost and computer

Discussion in 'General Discussion' started by flagelants, Mar 25, 2014.

  1. flagelants

    flagelants Registered

    Joined:
    Mar 25, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello, i want to establish a MySQL connection (link) between my computer, and a web-host mysql database (puma.arvixe)

    I have done the following:

    1: Logged in to the web-host (puma.arvixe) and created a MySQL database and a user to the MYSQL database
    2: Input my computers ip address to the remote database acess hosts.
    3: Downloaded MYSQL workbench, and tried to establish a connection, with hostname (puma.arvixe.com), the port, and the user i created as username, and the users password as the password. Still it doesn't work, no specifics in the error message, i'm sure i'm using the correct password and username, and i have an internet connection on my computer!

    I have no idea what to do now, i'm extremly grateful for any kind of help!
     
  2. MilesWeb

    MilesWeb Well-Known Member
    PartnerNOC

    Joined:
    May 23, 2012
    Messages:
    174
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Can you check if you can telnet the server IP on MySQL Port from your local machine ? If yes, try using some software like SQLYog and check if you can connect.
     
  3. rhenderson

    rhenderson Well-Known Member

    Joined:
    Apr 21, 2005
    Messages:
    785
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Oklahoma
    cPanel Access Level:
    Root Administrator
    Are you running CSF? If so you have to add your ip address and port to csf.allow to allow this to happen (even after you set it up in the remote hosts file)

     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    667
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Yes, it sounds like the IP address may be restricted by some firewall rules. I suggest using the instructions in the prior post to see if that makes a difference (assuming you are using CSF).

    Thank you.
     
  5. flagelants

    flagelants Registered

    Joined:
    Mar 25, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    The problem is that when i connect from ODBC i get the error message 10060, when i google this it is because i'm denied access. But i have allowed both my computers and % to the allow host access list!

    - - - Updated - - -

    I don't know what CSF is, and i don't think i'm using it. In case i have to anything csf related, can you explain to me a little bit more simply what needs to be done?

    Thank you very much for your help!
     
  6. rhenderson

    rhenderson Well-Known Member

    Joined:
    Apr 21, 2005
    Messages:
    785
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Oklahoma
    cPanel Access Level:
    Root Administrator
    CSF is a firewall, sounds like your not the server administrator. CSF will block those connections even if it is allowed in cPanel. You will need to contact the server administrator and see if a firewall is blocking you.
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    667
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    CSF is a firewall management utility. If you are just using standard iptables firewall rules, then you may want to temporarily stop the iptables service and see if the issue persists. This assumes you have root access to the system.

    Thank you.
     
Loading...

Share This Page