Sunday Morning - Install MySQL!

12:20.57 - Sunday 20th November 2005   (Link to This Entry)

What better way to spend a Sunday than to install MySQL, eh? OK sure there probably are better things to do, but right now I'm pressed to think of one if I want to be able to continue developing the Lotto site.

The problem I have is that I am using the MySQL databases located on the webserver. I have the necessary permissions set up so there's no problem there, but for whatever reason the server keeps lockingme out for a few minutes at a time if I do too much with a connection to it. For example, if I check my email, do a large MySQL query and FTP something all within the space of a few minutes, I get blocked.

I've checked the scan protection on the server and even put my IP address in the 'Never block this address' list but all to no avail - I guess it could be the router, but I also reasoned that I really sholdn't be working with live data anyway, hence the install.

Another reason for the local install is that every query has to go over the Internet. While it's OK with one or two, I have one script that checks all the days in a month for due draws and included results, so there's a lotta lotto queries flying. When querying localhost (ie online, when I've uploaded it) it postively flies, but when every query has to go over the net it crawls like a dirty low-down dawg.

Edit:
What's most frustrating is that HTTP isn't blocked, but HTTP to the server admin is, so I can't even see what hte hell's going on while I'm blocked out. Gah.

Edit 2
Well that was a non-event! Seems the installation of MySQL 5 has greatly improved, and it's now as easy as any other program. Excellent stuff. The only problem I had was with the passwords being in the old format, giving me the old 'Client does not support authentication protocol' error, promptly fixed with:

SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('pass');

Job done!