Connect to an online MySQL database from localhost

Question

I am trying to connect to my MySQL database on my online server via PHP on my localhost.

$con = mysql_connect("$hostname", "$username", "$password");
if (!$con) {die('Could not connect: ' . mysql_error());}
mysql_select_db($databasename, $con);

When I upload the script to the server it connects to the database fine. However, when I load the script on my localhost it will not connect to the online database. I shut off my firewall to make sure it was not blocking it.

Is the connection above formatted correctly to do this? Any other suggestions?

Does mysql_error() report an error when you try to connect on your localhost? — John Conde
– John Conde, Commented Jan 17, 2010 at 23:59
Can't connect to MySQL server on '(mysql host was here)' (10060) — Marcus
– Marcus, Commented Jan 18, 2010 at 0:01
Then it's definitely protected by a firewall on the server end. — Pekka
– Pekka, Commented Jan 18, 2010 at 0:33

Alix Axel · Accepted Answer · 2010-01-18 00:00:31Z

7

Your MySQL server needs to have your IP address (or % as wild card) specified in the allowed hosts.

answered Jan 18, 2010 at 0:00

Alix Axel

155k100 gold badges406 silver badges509 bronze badges

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

Comments

Ignacio Vazquez-Abrams · Accepted Answer · 2010-01-17 23:59:49Z

2

Does the host allow this? Many won't let external clients connect.

answered Jan 17, 2010 at 23:59

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

Comments

Tor Valamo · Accepted Answer · 2010-01-18 00:08:05Z

2

As the others say you need to allow that particular host (in this case your IP) to connect. This is in your user table in the mysql database. If you don't have access to this database (or don't have grant privileges) then you can't change this.

answered Jan 18, 2010 at 0:08

Tor Valamo

33.9k11 gold badges75 silver badges82 bronze badges

Comments

svens · Accepted Answer · 2010-01-18 00:23:10Z

2

Your code is ok.

As others stated the MySQL server has to allow connections from remote machines. Also make sure your provider's firewall isn't blocking the request and double check the hostname, because it may differ from the one you use on your server.

If you didn't set up your server yourself, you'll probably have to speak with th user support of your hoster, because they have the permissions to change settings and more accurate info on this topic.

answered Jan 18, 2010 at 0:23

svens

11.6k6 gold badges41 silver badges55 bronze badges

Comments

Elyor · Accepted Answer · 2015-08-26 03:47:27Z

0

It is time to move to mysqli_* or PDO

Documentation

answered Aug 26, 2015 at 3:47

Elyor

5,59210 gold badges55 silver badges78 bronze badges

Collectives™ on Stack Overflow

Connect to an online MySQL database from localhost

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related