mysql - "Premature end of data" error with PHP

Question

I've just started using WAMP for a PHP project and I get the next errors related with this line of code:

$link=mysql_connect("localhost","myuser","mypas");

I read that I had to do the SET PASSWORD again with my old password, but it still does not work after restarting all services. I am using PHP 5.3.4 and MySQL 5.1.53 Any help? THANKS

Warning: mysql_connect() [function.mysql-connect]: Premature end of data (mysqlnd_wireprotocol.c:554) in C:wampwwwCDEincludesaseDatos.php on line 5 
Call Stack 
1 0.0002 667312 {main}( ) ..index.php:0 
2 0.0008 682416 include( 'C:wampwwwCDEincludesseguridad.php' ) ..index.php:2 
3 0.0010 690984 include( 'C:wampwwwCDEincludesaseDatos.php' ) ..seguridad.php:2 
4 0.0014 692368 mysql_connect ( ) ..aseDatos.php:5 

( ! ) Warning: mysql_connect() [function.mysql-connect]: OK packet 1 bytes shorter than expected in C:wampwwwCDEincludesaseDatos.php on line 5 
Call Stack 
1 0.0002 667312 {main}( ) ..index.php:0 
2 0.0008 682416 include( 'C:wampwwwCDEincludesseguridad.php' ) ..index.php:2 
3 0.0010 690984 include( 'C:wampwwwCDEincludesaseDatos.php' ) ..seguridad.php:2 
4 0.0014 692368 mysql_connect ( ) ..aseDatos.php:5 

( ! ) Warning: mysql_connect() [function.mysql-connect]: mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file in C:wampwwwCDEincludesaseDatos.php on line 5 
Call Stack 
1 0.0002 667312 {main}( ) ..index.php:0 
2 0.0008 682416 include( 'C:wampwwwCDEincludesseguridad.php' ) ..index.php:2 
3 0.0010 690984 include( 'C:wampwwwCDEincludesaseDatos.php' ) ..seguridad.php:2 
4 0.0014 692368 mysql_connect ( ) ..aseDatos.php:5 

Answer 1

The above problem occurs because of version in-compatibility between PHP and MySQL. Mostly it may occur during remote access of db.

Kindly check your PHP and MySQL versions.

My versions are PHP-5.3.6 (Local machine) and MySQL 5.1.56 (Live DB).

My MySQL is placed in live domain and I kept my PHP files in local machine. I faced the same password rest problem.

Then I replace my XAMPP with older version it changed my PHP version to 5.3.0. Now the above problem was solved and I am able to access the live db from local.