Issues with mysql_connect and PHP 5.3

[calmcajun]

I would like to use both PHP 5.3 and the mysql functions but it appears the PHP 5.3 configuration(which is hosted on Brinkster) is somehow amiss. I talked to the Brinkster tech and all he did was switch the PHP version from 5.3 to 5.2 which breaks my PHP website as I am using some datetime functions. Here are the errors I am getting:

 

Warning: mysql_connect() [function.mysql-connect]: Premature end of data (mysqlnd_wireprotocol.c:554) in C:\Sites\Single47\aurawind2k\webroot\crankygamer\dbTest.php on line 8

 

Warning: mysql_connect() [function.mysql-connect]: OK packet 1 bytes shorter than expected in C:\Sites\Single47\aurawind2k\webroot\crankygamer\dbTest.php on line 8

 

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:\Sites\Single47\aurawind2k\webroot\crankygamer\dbTest.php on line 8

 

[fenway]

Well, the last warning is "real" -- and should be addressed -- you have old client libraries.

[munna]

Hey! calmcajun,

 

 

Try this!

http://lampsailesh.blogspot.com/2011_05_01_archive.html#5294498109303285481