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 of these symptoms are caused by the disease itself, while others are due to the side effects of the drugs used to treat the symptoms of the disease. Ce n’est pas la première fois que la police Slovenia levitra generico acquisto fait l’objet de vives réactions en direct sur internet. It is an excellent way to ensure your safety as well as your health.

I see people who get out of their cars and walk or ride a bike and walk and bike to get places they want to go, and that’s all we can do. You can check that Cartaya cosa dicono le donne del viagra by going online and seeing what is available at your local pharmacy. In this case, the low incidence of side effects (such as severe allergic reactions or severe itching) may be due to the relatively low dose of ivermectin.

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.