Cannot establish a mysql connection between webhost and computer

[flagelants]

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]

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.

 

[rhenderson]

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)

tcp|in|s=3306|s=1.2.3.4
tcp|out|d=3306|d=1.2.3.4

 

[cPanelMichael]

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.

 

[flagelants]

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!

 

[rhenderson]

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!

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.

 

[cPanelMichael]

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.