Connect to 2 diffrent server at same time

Question

I want to connect 2 diffrent DB, but I get that error:

Warning: mysqli::mysqli() [mysqli.mysqli]: (28000/1045): Access denied for user '*username*'@'localhost' (using password: YES) in......

my code:

$mysqli2 = new mysqli('localhost',$db_user,$db_pass, $db_name);
$mysqli2 = new mysqli('localhost',$db_user2,$db_pass2, $db_name2);

And I try to excute queries like this:

$result=$mysqli->query("select ......
$result=$mysqli2->query("select ......

How can I fix this?

Seems like the connection data is wrong – Miguel G. Flores May 08 '13 at 11:37 — Miguel G. Flores, May 08 '13 at 11:37
the user and password is 100% correct. – DevShaked May 08 '13 at 11:39 — DevShaked, May 08 '13 at 11:39
Then your user doesn't have permission to connect. – Glitch Desire May 08 '13 at 11:43 — Glitch Desire, May 08 '13 at 11:43

score 1 · Answer 1 · answered May 08 '13 at 11:39

1

Your username or password is wrong.

answered May 08 '13 at 11:39

Glitch Desire

14,632
7
43
55

score 1 · Answer 2 · edited May 23 '17 at 12:13

1

Your mysql user may not have the right privileges to connect over the network.

See here : How to grant remote access permissions to mysql server for user?

edited May 23 '17 at 12:13

Community

1
1

answered May 08 '13 at 11:42

Tom Macdonald

6,433
7
39
59

score 0 · Answer 3 · answered May 08 '13 at 11:43

check password and adress and username

use next code to connect

$connect1 = new mysqli(...);
$connect2 = new mysqli()
if ($connect1->connect_error)
  echo "error in 1 connection message: " . $connect1->connect_error;
if ($connect2->connect_error)
  echo "error in 2 connection message: " . $connect2->connect_error;

where you see a problem ?

Connect to 2 diffrent server at same time

3 Answers3