Remote Mysql Server connection by PHP

Question

While i execute following code:

$db_host = "<IP>";  // Host name
$db_user = "<usr>";  // User name of your database
$db_password = "<pass>";     // Password of your database
$db_name="<db name>";   // Database name

$con = mysql_connect($db_host,$db_user,$db_password);
mysql_select_db($db_name) or die("Cannot select database...");

It shows following errors:

Warning: mysql_connect() [function.mysql-connect]: OK packet 6 bytes shorter than expected in C:\wamp\www\limosbusesjets\connection.php on line 21

Warning: mysql_connect() [function.mysql-connect]: mysqlnd cannot connect to MySQL 4.1+ using old authentication in C:\wamp\www\limosbusesjets\connection.php on line 21 Cannot select database...

The errors shown are missing. Could you please add them?

Vegard Larsen
– Vegard Larsen

2009-12-09 05:09:24 +00:00
Commented Dec 9, 2009 at 5:09 — Vegard Larsen
– Vegard Larsen, Commented Dec 9, 2009 at 5:09

Community · Accepted Answer · 2017-05-23 12:19:37Z

3

These errors generally happen when one is using PHP 5.3, and its new mysqlnd driver to connect to MySQL (which is often the case with PHP 5.3, as it's one of the new stuff introduced with 5.3 -- and "mysqlnd" is mentionned in your second error) : with those, you cannot connect to a MySQL database using the old-passwords system.

Which means you'll have to change the way your MySQL server deals with passwords, to switch to the "new" authentication system.

See, for instance :

Not sure it's what is causing the problem in your case, but that's one common MySQL related thing, with PHP 5.3, for those errors...

edited May 23, 2017 at 12:19

CommunityBot

11 silver badge

answered Dec 9, 2009 at 5:13

Pascal MARTIN

402k82 gold badges665 silver badges666 bronze badges

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

Collectives™ on Stack Overflow

Remote Mysql Server connection by 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