mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication
Hello friends,
I have a problem, i have installed ms4w 3.0 that i need for a new application that im doing, when i put in php this sentence $con = mysql_connect("host:port","user","password"); this return me:
Warning: mysql_connect(): Premature end of data (mysqlnd_wireprotocol.c:554) in C:\ms4w\apps\test\test.php on line 8 Warning: mysql_connect(): OK packet 1 bytes shorter than expected in C:\ms4w\apps\test\test.php on line 8 Warning: 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:\ms4w\apps\test\test.php on line 8
I can't modify nothing of the server. All our applications connect here in my work with the server correctly, but my new application with ms4w 3.0 not. I need connect with $con = mysql_connect("host:port","user","password"); successful with the new ms4w 3.0 . I can't do the command "SET PASSWORD...." because It can affect to the connections that we have in the others applications.
Please i need your help. Im waiting your answer soon.
Thank you very much.
Subject
Written By
Posted
mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication
January 18, 2011 06:38AM
February 28, 2011 04:39PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.