Posts tagged MySQL

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:

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.

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, 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


Go to Top