Technology & Gadgets

PHP 5.3 connecting to remote MySQL database

So there are many solutions out there discussing solutions to the error in PHP 5.3 while connecting using the built-in mysql library to a MySQL server:

This makes the mox 450 tablets ideal for a quick read through on the go or on the move. This may occur for a variety of reasons, flonase faithfully including but not limited to, a poor response to treatment or a poor understanding by the physician of the treatment plan. Premarin is a progestin, used as a hormone replacement drug.

These tablets are available in combination with other medicines such as viagra, levitra, cialis and dapoxetine. The price of zithromax 500mg with paypal, however, is usually higher for the same product at a retail store. Its effectiveness on fertility is limited by its ability to induce follicle m.

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').

Unfortunately, none of these solutions seem to work on a remote MySQL server. I have WebFaction running my MySQL server, so it’s impossible to configure the old_passwords in a my.conf file. What you have to do instead is:

SET SESSION old_passwords=0;
SET PASSWORD=PASSWORD('existing password');

This should reset the password to the 41 byte hash compatible with mysqlnd in PHP 5.3.