Someone sent me this a while back and I thought it was very good – posting here so others can benefit! Every programmer has to have something to program, whether it’s work related, hobby related, for a friend, or even just a quick script for an automation. We will discuss hobby pro-gramming. When sitting at home and pondering upon ideas to program you sometimes get stumped and feel halted. This is a term in the programming world called “coders block”, yes… exactly like a “writers block”. I can speak from experience and from other documentation on steps to overcome this block, I will try and combine the both. The first thing to do is get focused, you don’t want to… Continue reading »

After MySQLFront repeatedly crashing on me – it was time to look for another MySQL frontend…. I’d downloaded and installed MySQL Control Center and found it refreshingly useful.. Although I’m not disappointed to find I can’t export any tables….. So, after reading this post at the MySQL bugs reporter I’ve just installed MySQL Adminstrator which looks very nice!!! Along with MySQL Query Browser (Download here) but the export functions available in this are only CSV, XML, HTML or XLS!!!! Looks like it’s back phpMyAdmin for now for exporting data. I now seem to have more MySQL programs installed than is entirely necessary but what the hell, if one goes wrong at least I’ve got a backup!!!!

For some unknown reason I decided to install MySQL 4.1 rather than an older version which is on my server… But none of my PHP scripts would connect to it… Resulting in the following error: Client does not support authentication protocol requested by server; consider upgrading MySQL client What the hell does that mean!?!? A little digging on the MySQL website produces the following piece of useful information: The password hashing mechanism was updated in MySQL 4.1 to provide better security and to reduce the risk of passwords being intercepted. However, this new mechanism is understood only by the 4.1 server and 4.1 clients, which can result in some compatibility problems. A 4.1 client can connect to a pre-4.1 server,… Continue reading »