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

TheCompWiz

Well-known member
Registered
Joined
Apr 20, 2016
Messages
130
Points
18
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

Well-known member
Hosting Provider
Registered
Joined
Jul 5, 2016
Messages
1,031
Points
63
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

Member
Registered
Joined
Dec 27, 2016
Messages
39
Points
0
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

Member
Registered
Joined
Dec 28, 2016
Messages
54
Points
0
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

Well-known member
Registered
Joined
Apr 20, 2016
Messages
130
Points
18
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.

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.
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

Active member
Registered
Hosting Provider
Joined
Jan 18, 2017
Messages
83
Points
8
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
 
Newer Threads
Recommended Threads

Latest Hosting OffersNew Reviews

Sponsors

Tag Cloud

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top