mysql connect not working with PHP

Question

Any idea why the following code is not working

mysql credentials are correct, have verified from command line.

The second connection fails i.e., $conn1 . I am clueless !!!

$conn = mysql_connect($hostname,
$username, $password) 
    or die("Connecting to MySQL failed" . mysql_error());

$conn1 = mysql_connect($hostname,
$username1, $password1) 
    or die("Connecting to MySQL failed" . mysql_error());

Don't you have an error message that gives more information that "connection fails", as output of mysql_error ? — Pascal MARTIN
– Pascal MARTIN, Commented Mar 11, 2010 at 17:42

Vijay · Accepted Answer · 2010-03-11 18:19:22Z

5

Test it with hardcoded values first to be sure...

//Connect to database from here
$link = mysql_connect("localhost", "dbaadmin", "sqlpassword");
if (!$link) {
    die('Could not connect: ' . mysql_error());
}

answered Mar 11, 2010 at 18:19

Vijay

761 bronze badge

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

Comments

symcbean · Accepted Answer · 2010-03-11 18:29:43Z

2

have verified from command line.

There's so many questions here that you have not answered.

The command line where the PHP script is running?

The same chroot environment where the PHP script is running?

The OS user (not database user) is the same as the webserver runs as?

The hostname you are connecting to is on a seperate machine from where the PHP script (and the CLI) is running? (localhost will use a unix domain socket rather than a network socket)

...and just what is the error message you get?

C.

answered Mar 11, 2010 at 18:29

symcbean

48.4k6 gold badges64 silver badges99 bronze badges

Comments

user132014 · Accepted Answer · 2010-03-11 17:43:12Z

1

It's a guess, but is the second connection supposed to be to $hostname, or perhaps $hostname1 instead.

answered Mar 11, 2010 at 17:43

user132014

Collectives™ on Stack Overflow

mysql connect not working with PHP

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related