Connect to server database from localhost

Question

What I'm trying to do is connecting to server database from localhost.

$host = 'http://www.my-domain.com/phpmyadmin/';
$user = 'u5er';
$pass = 'pa55w0rd';
$db = 'db_name';

$con = mysqli_connect($host,$user,$pass,$db) or die("Error " . mysqli_error($con));
$sql = "SELECT col FROM test WHERE id = '1'";

$result = mysqli_query($con,$sql);

Errors

Warning: mysqli_connect(): in C:\xampp\htdocs\sp_concord\cenova_nabidka\page\vytvor.php on line 362

Warning: mysqli_connect(): in C:\xampp\htdocs\sp_concord\cenova_nabidka\page\vytvor.php on line 362

Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in C:\xampp\htdocs\sp_concord\cenova_nabidka\page\vytvor.php on line 362
Error

Is it possible to resolve it? How to find out if my server allows external connections? And how to define from which IP addresses it should allow access to database?

Thank you for any suggestion.

EDIT: Ok, I have changed the host to my-domain.com and now it reports the following errors. My IP has no acces to MySQL server...

Warning: mysqli_connect(): (HY000/1130): Host '88.146.210.54' is not allowed to connect to this MySQL server in C:\xampp\htdocs\sp_concord\cenova_nabidka\page\vytvor.php on line 362
Failed to connect to MySQL: Host '88.146.210.54' is not allowed to connect to this MySQL server
Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in C:\xampp\htdocs\sp_concord\cenova_nabidka\page\vytvor.php on line 368

very unlikely that host string is correct. phpmyadmin is NOT a data base — user557846
– user557846, Commented May 25, 2014 at 23:32

Reids Meke Meke · Accepted Answer · 2014-05-26 05:10:16Z

2

if you upload your localhost file to web server, some host provider, use "localhost" too as hostname

$host = 'localhost';
$user = 'u5er';
$pass = 'pa55w0rd';
$db = 'db_name';

"Host 'XXX.XXX.XXX' is not allowed to connect to this MySQL server" appear when you didn't configure host to grant accessing database

answered May 26, 2014 at 5:10

Reids Meke Meke

3574 silver badges14 bronze badges

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

1 Comment

falcon Over a year ago

Hi, I tried to configure an access to dababase for my IP address, but with no success yet. As soon as I have time for this, I will fix it. Thank you.

Martin Konecny · Accepted Answer · 2014-05-25 23:35:07Z

1

Your logging has an error is on the following line:

$con = mysqli_connect($host,$user,$pass,$db) or die("Error " . mysqli_error($con));

$con is never assigned a value (base mysqli_connect failed) and you are passing it to mysqli_error().

Try the following instead - it will give you the information you need about why you cannot connect:

$con = mysqli_connect($host,$user,$pass,$db);
if (mysqli_connect_errno())
{
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

As user Dagon mentioned, your host string should be something like my-domain.com or even more likely, localhost and not http://www.my-domain.com/phpmyadmin/

answered May 25, 2014 at 23:35

Martin Konecny

59.9k20 gold badges144 silver badges159 bronze badges

3 Comments

Martin Konecny Over a year ago

Is the MySQL database running on the same server the PHP script? In that case you can just change the host to localhost instead of my-domain.com. If it's not you will need to configure MySQL to allow connections from remote machines - take a look at the link here: stackoverflow.com/questions/8348506/…

falcon Over a year ago

No, it's not and I'm going to check your suggestions. Thank you.

Martin Konecny Over a year ago

Prosim :). BTW, here's a better link: rackspace.com/knowledge_center/article/…

Kinnectus · Accepted Answer · 2014-05-25 23:38:09Z

1

Most external databases are connected to via an IP or domain/subdomain with correct port number. You have put "http" which is port 80. Most MySQL are 3306. Your host/extremal provider should have given you an IP of the database server and logon details...

answered May 25, 2014 at 23:38

Kinnectus

8997 silver badges14 bronze badges

Comments

user3674632 · Accepted Answer · 2014-05-25 23:39:25Z

1

Your IP address must be registered to your host in order to connect to the database

answered May 25, 2014 at 23:39

user3674632

191 bronze badge

1 Comment

mclaassen Over a year ago

What do you mean by "must be registered to your host"?

bitfhacker · Accepted Answer · 2014-05-25 23:41:42Z

1

Yes, it's possible to resolve that. Change the variable $host to the right hostname (localhost or other).

To find out if your server allows external connections you can use an online port scan to see if you have the mysql port (default is 3306) open to the outside world.

To define which IP addresses can access your database you should use an firewall rule.

answered May 25, 2014 at 23:41

bitfhacker

2921 silver badge14 bronze badges

Comments

DMCoding · Accepted Answer · 2014-05-25 23:37:17Z

0

The host string is wrong. A valid mysql URL will be of the form 'mysql://hostname.tld/database'. However its very unusual that administrators make SQL databases available over the internet. Most likely you should try to run your php application from the same server or network as the database server.

answered May 25, 2014 at 23:37

DMCoding

1,2452 gold badges17 silver badges31 bronze badges

1 Comment

falcon Over a year ago

Hi, thank you, but it's not possible. This is local application and I need to use some data from server my-domain.com

Collectives™ on Stack Overflow

Connect to server database from localhost

6 Answers 6

1 Comment

3 Comments

Comments

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

3 Comments

Comments

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related