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 you have been taking advair, i am sure your dose was increased and you probably have to keep taking it. It has helped me cope with the pressure but even so i wish i lankly mometasone cream price had found it sooner. This is the most common and the quickest way to find a physician is to search for a specific disease or symptom.

Clomiphene citrate tablets, which is a drug produced by bayer. For sito serio per acquisto viagra this site to rank well, you need content, and that is hard to create and to maintain. The researchers concluded that it was a better choice for long-term use, which is usually reserved for diseases that do not respond to other treatments.

I do know there are side effects from the medicine but i'm very careful about my body especially my kids. This will dexamethasone prescription work well for people who have difficulty swallowing. The mamofen 20 in pakistan from this pharmacy is of excellent quality and is also available in different dosages.

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.

Categories
Personal Technology & Gadgets

Struggling with Drupal

Well, after a detailed analysis of the different CMS systems, I chose Drupal (somewhat reluctantly after my last experience with this CMS), and have been struggling, fairly successfully, to port the fire department website, bouldermountainfire.org. Here were my criteria for CMS selection:

  • Fantastico compatible (more about this later) for easy upgrade
  • MySQL-based
  • Good permissions-based content protection (with different users and groups have specific permissions)
  • Embedded Gallery2 plugin