Hey all. Trying to connect to a hosted mySQL server and it's not working.
1. Both local and hosted mySql Server have old_passwords turned on.
2. Both servers generate the exact same 16byte Hash code on a SELECT Password('mypassword'); SQL Query.
3. I've tried an old libmysql.dll on my local side
4. SQLyog can connect just fine
Yet I still get this error when I try to connect using a PHP script:
An Error Occured!
Error Number: 2
Error Description: mysql_connect() [function.mysql-connect]: Premature end of data (mysqlnd_wireprotocol.c:554)
Error In File: X:\xampp\htdocs\PHP\8KCoxxxxxxxxxx3.php
Error On Line: 13
An Error Occured!
Error Number: 2
Error Description: mysql_connect() [function.mysql-connect]: OK packet 1 bytes shorter than expected
Error In File: X:\xampp\htdocs\PHP\8KCxxxxxxxxxxxxx3.php
Error On Line: 13
An Error Occured!
Error Number: 2
Error Description: 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
Error In File: X:\xampp\htdocs\PHP\8KCxxxxxxxxxxxxxx3.php
Error On Line: 13
z