How to use multiple database on different host using php?

Question

I have this array that store the connection info and i want to use it when perform the query

$dblist = array();

$dblist[] = array(
        'host'=>'192.168.1.20',
        'username'=>'root',
        'password'=>'root1',
        'database'=>'unsubscribe_1',
        'table'=>'subscribers'
        );

$dblist[] = array(
        'host'=>'192.168.1.5',
        'username'=>'root',
        'password'=>'root2',
        'database'=>'unsubscribe_test',
        'table'=>'subscribers2'
        );


foreach($dblist as $list)
{
$host = $list['host'];
$username = $list['username'];
$password = $list['password'];
$db = $list['database'];
$tb = $list['table'];

$conn1 = mysql_connect($host,$username,$password) or die(mysql_error());
mysql_select_db($db,$conn1) or die(mysql_error());

$sql = "select * from $db";
$query = mysql_query($sql,$conn1) or die(mysql_error());    
}

The problem is i keep getting this error "Host '192.168.1.5' is not allowed to connect to this MySQL server"

What is the problem here?

Host '192.168.1.5' is not allowed to connect to this MySQL server — Your Common Sense
– Your Common Sense, Commented Jan 18, 2011 at 8:55
I am pretty sure it is allowed because i am working in that 192.168.1.5 (localhost) — cyberfly
– cyberfly, Commented Jan 18, 2011 at 8:58
What happens if you swap the order of the array so 192.168.1.5 is connected first? — Matt Asbury
– Matt Asbury, Commented Jan 18, 2011 at 8:59
You cannot be sure! Just because you're watching this error message with your own eyes! So, the only thing you can be sure of - it's that your host isn't allowed! The only thing you really need is to trust your eyes, not fantasies — Your Common Sense
– Your Common Sense, Commented Jan 18, 2011 at 9:11

Community · Accepted Answer · 2017-05-23 12:04:16Z

1

I assume Host '192.168.1.5' is your local machine and you encounter this error when trying to connect to Host .20, You need to enable remote access for Host .5 on Host .20's MySQl server.

HowTo

-michael

edited May 23, 2017 at 12:04

CommunityBot

11 silver badge

answered Jan 18, 2011 at 9:05

Michael

1,32211 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

How to use multiple database on different host using php?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related