problem connecting to remote mysql database using php

Question

If I open up a cmd shell and run

>mysql --host=12.34.56.78 --port=1234 --user=myuser --password=mypassword mydb

I can successfully connect to the remote mysql database.

But if I create a php page on my localhost containing

<?php
$hostname = "12.34.56.78:1234";
$username = "myuser";
$password = "mypassword";
$dbname   = "mydb";
$connect = mysql_connect($hostname,$username,$password) or die ("Error: could not connect to database");
?>

I get the following error:

Error: could not connect to database

Can anyone explain what might be causing the problem here?

mysql_error() => mysqlnd cannot connect to MySQL 4.1+ using old authentication

use $connect = mysql_connect($hostname,$username,$password) or die ("Error: could not connect to database (".mysql_error()); and give results here — genesis
– genesis, Commented Jun 22, 2011 at 19:21
I assume --password=mypasword and $password = "mypassword" is a simple typo, yes? — Michael B
– Michael B, Commented Jun 22, 2011 at 19:22
Please enable error reporting and post the error the mysql_connect function gives. — Sjoerd
– Sjoerd, Commented Jun 22, 2011 at 19:23
Could you output the function mysql_error() in your die()? That would give the reason mysql can't be connected to. — hoppa
– hoppa, Commented Jun 22, 2011 at 19:23

Michael B · Accepted Answer · 2011-06-22 19:27:53Z

1

Auth problems are a known issue with PHP 5.3 and older versions of MySQL. Check this:

http://www.bitshop.com/Blogs/tabid/95/EntryId/67/PHP-mysqlnd-cannot-connect-to-MySQL-4-1-using-old-authentication.aspx

answered Jun 22, 2011 at 19:27

Michael B

1,7634 gold badges21 silver badges35 bronze badges

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

Comments

Greenisha · Accepted Answer · 2011-06-22 19:25:09Z

0

maybe in your php.ini parameter sql.safe_mode is "1"?

sql.safe_mode boolean

If turned on, database connect functions that specify default values will use those values in place of supplied arguments. For default values see connect function documentation for the relevant database.

answered Jun 22, 2011 at 19:25

Greenisha

1,44710 silver badges14 bronze badges

Collectives™ on Stack Overflow

problem connecting to remote mysql database using php

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related