Cannot establish a mysql connection between webhost and computer

flagelants

• March 25, 2014 10:11

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!

• 

  MilesWeb

  • March 26, 2014 12:39

  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.

  0
• 

  rhenderson

  • March 27, 2014 02:44

  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) [QUOTE]tcp|in|s=3306|s=1.2.3.4 tcp|out|d=3306|d=1.2.3.4
  

  0
• 

  cPanelMichael

  • March 31, 2014 15:07

  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.

  0
• 

  flagelants

  • April 01, 2014 09:00

  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! [COLOR="silver">- - - 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!

  0
• 

  rhenderson

  • April 01, 2014 22:38

  [quote="flagelants, post: 1609382">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! [COLOR="silver">- - - 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!
  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.

  0
• 

  cPanelMichael

  • April 04, 2014 18:34

  [quote="flagelants, post: 1609382">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?
  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.

  0

Please sign in to leave a comment.