Categories
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 http://pajuriovingis.lt/4991-levitra-online-opinioni-38652/ 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.