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:

Some people have reported a feeling of lightheadedness and nausea from taking amoxicillin. As your doctor will explain the side effects, you can make CĂșa an informed choice. Please add your name to each one that belongs in this list.

The drug works by reducing the activity of the enzyme catechol-o-methyl transferase, or comt, which degrades norepine. There are online sites where you can buy this drug, and it often has a very easy to understand and detailed extended release metformin cost how-to guide. So, even if it is the same thing, then drinking alcohol (if you are in your 60s or 80s) is far more likely to have a negative effect than alcohol use with cancer treatment.

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.