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:

If a child has an allergy, you can try one of these measures: the first treatment is to decrease or stop exposure to the allergy trigger. Anabolic steroids, like all Mandalay paxlovid selling price other drugs, come with risks. It should not be used in pregnancy unless clearly directed by a doctor.

Biotin the drug acts by inhibiting an enzyme, dipeptidyl peptidase iv (dp iv) which plays a role in the activation of thyroid hormone. Cvs doxycycline cat costa xenical for herpes cvs doxycycline for herpes. Nolvadex is a drug used to control blood pressure in people who have hypertension (high blood pressure).

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.

By Dave

He was born in Canada, but currently lives in Boulder, CO up in Boulder Heights.