Cannot establish a mysql connection between webhost and computer

flagelants

Registered
Mar 25, 2014
2
0
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!
 

MilesWeb

Well-Known Member
PartnerNOC
May 23, 2012
173
2
68
India
cPanel Access Level
Root Administrator
Twitter
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
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

Registered
Mar 25, 2014
2
0
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!
 

rhenderson

Well-Known Member
Apr 21, 2005
785
2
168
Oklahoma
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!
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

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
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.