PHP connect to external MySQL Database

Question

im trying to connect to my external sql database but I keep getting this error:

mysql_connect(): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. in C:\wamp\www\zconnect.php on line 10
Unable to connect to database! Please try again later.

This is the PHP script:

<?php
$hostname='111.11.111.11'; #this is not my real ip address
$username='root';
$password='password';
$dbname='database';
$usertable='users';
$yourfield = 'admin';

mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
mysql_select_db($dbname);

$query = 'SELECT * FROM ' . $usertable;
$result = mysql_query($query);
if($result) {
    while($row = mysql_fetch_array($result)){
        print $name = $row[$yourfield];
        echo 'Name: ' . $name;
    }
}
else {
print "Database NOT Found ";
mysql_close($db_handle);
}
?>

Tried this but didn't work also:

Alias /phpmyadmin "c:/wamp/apps/phpmyadmin4.1.14/"

# to give access to phpmyadmin from outside 
# replace the lines
#
# Require local
#
# by
#
# Require all granted
#

Any help is appreciated!

do you can connect in this server by any tool on your machine? — Gouda Elalfy
– Gouda Elalfy, Commented Jan 3, 2016 at 16:15
Is the remote database accessible remotely? For example the server may have restrictions for remote access and only allows connections from specified IP addresses. — segFault
– segFault, Commented Jan 3, 2016 at 16:16
Stop using mysql. It's deprecated and as of php 7 completely gone. I recomment using PDO. Else, you can use MYSQLi — Chris G
– Chris G, Commented Jan 3, 2016 at 16:25
Please stop using mysql_* functions. These extensions have been removed in PHP 7. Learn about prepared statements for PDO and MySQLi and consider using PDO, it's really pretty easy. — Jay Blanchard
– Jay Blanchard, Commented Jan 3, 2016 at 16:49

Jefrey Sobreira Santos · Accepted Answer · 2016-01-03 16:38:28Z

1

First, I suggest SSH-ing your server and TCPing-ing or Netcat-ing (ok, I'm stopping) your remote MySQL server, so you see if it really can be accessed. Some hosts - mainly shared - require you to ask them to enable remote MySQL first (some have this option on CPanel).

Second, some MySQL servers whitelist some clients to access itself, exclusively. phpMyAdmin can help you in reading and setting this configuration.

answered Jan 3, 2016 at 16:38

Jefrey Sobreira Santos

6724 silver badges17 bronze badges

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

2 Comments

Jeroen Over a year ago

Can't seem to connect. I've tried changing this: gyazo.com/5d33a22beeb91fadf7ed21a12f6b2dd2 But didnt work :(

Jefrey Sobreira Santos Over a year ago

I see you've fixed this by setting permission. It's what I said on "Second" :P

Collectives™ on Stack Overflow

PHP connect to external MySQL Database

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related