How would you get MySQL access from a remote IP address?

TheCompWiz · Dec 3, 2016

I am trying to set up MySQL access for a remote IP. I have to grante mysql user all privileges for database in cPanel and I have set up to be allowed access for that IP in WHM and cPanel remote access? For some reason its not connecting at all. Any help with detailed steps?

LJSHost · Dec 3, 2016

Sounds like you done everything right, what are you trying to connect with, a script ? What error are you getting from the failed connection ?

nitaish · Dec 29, 2016

Providing the error might help. Also check if the MySQL port is allowed in the Iptables for remote connections or not. If the port 3306 is not open to the outside world, you cannot connect it remotely.

Rectified · Dec 30, 2016

TheCompWiz said:
I am trying to set up MySQL access for a remote IP. I have to grante mysql user all privileges for database in cPanel and I have set up to be allowed access for that IP in WHM and cPanel remote access? For some reason its not connecting at all. Any help with detailed steps?

Check firewall/iptables on host

Also please give what error do you get it might help

TheCompWiz · Dec 30, 2016

LJSHost said:
Sounds like you done everything right, what are you trying to connect with, a script ? What error are you getting from the failed connection ?

I tried to connect from a php script, it didn't work as guides on the web.

nitaish said:
Providing the error might help. Also check if the MySQL port is allowed in the Iptables for remote connections or not. If the port 3306 is not open to the outside world, you cannot connect it remotely.

Rectified said:
Check firewall/iptables on host

Also please give what error do you get it might help

It doesn't give me any errors, like a blank page, I asked my host provider and it said I should turn on error report in php but I don't know more about programming.

hfav · Jan 19, 2017

First:
If you have access to shell or command prompt from where you are trying to connect to mysql server, use following command to verify firewall is not blocking mysql port.

HTML:

telnet mysqlserveraddress 3306

If you get blank screen and then connection to host lost means firewall is not blocking.

Second:
Turn on debugging

How would you get MySQL access from a remote IP address?

TheCompWiz

Well-known member

LJSHost

Well-known member

nitaish

Member

Rectified

Member

TheCompWiz

Well-known member

hfav

Active member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud