Remote MySQL database connection using php

Question

I'm trying to connect to a remote database on a server which is accessed through cPanel.

I created a user name and associated it with a database. I'm using:

I'm confused on the host name to use. I tried using the Main Domain name in the left menu panel in cPanel with the port number 3306 but it wouldn't work. I used the shared IP as well with the port number that that wouldn't work as well. I have added my local machine IP to the remote databases page in the cPanel as was told in a post but finally I'm not able to connect to the database.

On echoing the mysql_error(), I get:

Can't connect to MySQL server on 'host_name' (4)

Any help would be great!

Are you sure the database is listening external? Maybe it's configured to just accept connections from localhost. — Maarkoize
– Maarkoize, Commented Jan 20, 2014 at 12:43
@MarcelBalzer How do I check if database is listening external? I tried $telnet my_shared_ip:3306 And it gives - Could not resolve : Name or service unknown — Amit Nandan Periyapatna
– Amit Nandan Periyapatna, Commented Jan 20, 2014 at 12:46
telnet is throwing an error could not resolve: ip_address:3306/telnet: Name or service not known — Amit Nandan Periyapatna
– Amit Nandan Periyapatna, Commented Jan 20, 2014 at 12:54
You don't resolve IP addresses, do you?? You resolve hostnames to ip addresses, and ips get routed, but not resolved. The only case IP addresses get resolved is in mail spam detectors by the reverse DNS. — Daniel W.
– Daniel W., Commented Jan 20, 2014 at 12:55

Shinto Joseph · Accepted Answer · 2014-01-20 12:48:09Z

1

your hosting site will specify which name should be used for the host

in hostinghood.com they says that to use localhost itself as host name

so check what your hosting site says about it

answered Jan 20, 2014 at 12:48

Shinto Joseph

1,1811 gold badge8 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Amit Nandan Periyapatna Over a year ago

I don't think a remote connection can be achieved by using localhost as the hostname. It is used for the applications hosted on the same hosting provider. What I'm trying to achieve here is a remote connection to the hosting provider's database.

Shinto Joseph Over a year ago

i know it but i said that hostinghood.com says to use it for our easyness thay had made the settings like that.if you have any doubt try hosting in hostinghood.com other hosting sites have different name for the host

Collectives™ on Stack Overflow

Remote MySQL database connection using php

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related