Password Issues with PHP4 and MySQL

I have struck this a couple of times now so thought I’d put a reference here, if not for anyone else then at least for me!

Recent versions of MySQL 4 use passwords that are not compatible with PHP4. If you have received an error like this, you’ll know what I’m talking about…

Client does not support authentication protocol requested by server; consider upgrading MySQL client

To fix it, log into MySQL via the command line and use OLD_PASSWORD to change it so that’s it’s compatible.

Some Priorities Have Changed

Been a couple of weeks since I posted here.

  1. Went on holdays to Perisher! Fortunately, I did not break any bones!
  2. Jamie (our programmer) packed his bags and moved to Brisbane. I knew that was coming – but was hoping it would be later rather than sooner.

So after being away for a bit over a week and then coming back to be a man down, things have been somewhat busy. And given the serious skills shortage we have here at the moment, it will probably stay that way for the short term at least.

So basically – my plans to work on NetOffice have to be shelved for the time being. Once things settle down I may be able to pick this up again, but I expect that will take some time.

Thanks to all who have commented and offered assistance, and especially to Kemie who emailed me a couple of designs. I hope to get back to this one day, but in the meantime it might be best if you check out the Dwins version which seems to be fairly active.