rmote mysql connection
Posted by: bhavlice (---.hsd1.ca.comcast.net)
Date: June 20, 2011 09:21PM

I get the following errors when attempting to connect to a remote Mysql server using:

$con=mysql_connect('remote serve IP and port#','user','password');

The errors are:Warning: mysql_connect() [function.mysql-connect]: Premature end of data (mysqlnd_wireprotocol.c:554) in C:\wamp\www\wordpress\wp-content\plugins\BVDPlugin\index.php on line 253
Call Stack

( ! ) Warning: mysql_connect() [function.mysql-connect]: OK packet 1 bytes shorter than expected in C:\wamp\www\wordpress\wp-content\plugins\BVDPlugin\index.php on line 253
Call Stack

( ! ) 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:\wamp\www\wordpress\wp-content\plugins\BVDPlugin\index.php on line 253
Call Stack

I have tried everything I can think of.
I'm using PHP ver. 5.3.5 and MySQL ver. 5.5.8 which are the latest versions and use the new encryption method.

According to everthing I can find, this should work. Please help!!! This is a ctitical component to my WordPress Plugin.

Options: ReplyQuote
Re: rmote mysql connection
Posted by: stevenmartin99 (---.b-ras1.srl.dublin.eircom.net)
Date: June 20, 2011 09:42PM

mysql client ans server mismatch.

check the mysqlnd extention versoin on the remote host.

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote


Sorry, only registered users may post in this forum.