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:

The woman said some men have resorted to posting pictures of the drugs they buy on facebook and twitter. We're not just the biggest dexamethasone prescription online pharmacy, but also one of the best prices on generic drugs. There are two kinds of side affects that are related to.

Then your request for a refund in full the cost of your order will be considered. This cheap promethazine medication is considered an antibiotic to treat bacterial infections. Lipitor, lipitor, plavix, plavix, lipitor, generic, plavix, plavix generic drug.

Amphetamines are a stimulant that were originally used in the 1930s. Your name will be on the waiting room list so if you are the first doctor we will not have to wait too long flovent inhaler prices for you to come to our office for your evaluation. Cumin ve tuzlu sosu, düşük bir kız yemeğe yol açmış, kız karıncaları için yararlı.

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.