James Titcumb

Posted by mobile phone:

The engines are going and we’ve started moving!

If you’ve been following my Twitters/blog for a few days you should notice I’m getting hyped for Hellfest. Well this is my last regular blog post until at least next Monday. I’ll try and keep this up to date with Twitter updates, and I’ll try and post a blog if I’m not too passed out. Anyway, the ferry is at 11:30pm tonight, we’ve gotta be there at 9:30pm (silly, I know!) so I’d better get a move on!

Farewell to thee all, fair readers, temporarily anyway.

Oh, and get some tickets for Frosthold!

Everyone already knows about the server downtime when they were trying to break the record blah blah.

The botch I’m talking about is my experience of downloading it this morning and trying it out.

My experience was about 15 minutes…

• 1 minute to download Firefox 3
• 1 minute to install Firefox 3
• 1 minute to find out half of my add-ons don’t work
• 1 minute to try and hack the MaxVersion to work and fail miserably
• 2 minutes to locate a Firefox 2 installer
• 3 minutes to download it from the stupidly slow FTP
• 1 minute to uninstall Firefox 3 and install Firefox 2
• 2 minutes to find out Firefox 2 kept crashing because the Firebug I upgraded to crashes it
• 1 minute to uninstall Firefox 2 and re-install it
• 2 minutes to set it up back to the way I like and restore my previous profile

I think I’ll leave Firefox 3 for a little while to get rid of teething issues.

At lunch, I asked Sii (one of our design guru’s here at Netbasic) to see what he thought of my new theme. He said pretty much straight away to get rid of the solid black lines, so I’ve replaced them all (except the date by the post titles as I stupidly put the border in the image itself…) with more subtle greys. So if you’re still seeing solid black lines around stuff, clear your cache and enjoy the new easier-on-the-eye greys. Cheers Sii!

I’ve always used fancy tools like PhpMyAdmin to create users in mysql etc. as I don’t normally remember the syntax.

Here it is:

CREATE USER 'username'@'hostname'
     IDENTIFIED BY 'password';
GRANT USAGE ON * . * TO 'username'@'hostname'
     IDENTIFIED BY 'password'
     WITH
          MAX_QUERIES_PER_HOUR 0
          MAX_CONNECTIONS_PER_HOUR 0
          MAX_UPDATES_PER_HOUR 0
          MAX_USER_CONNECTIONS 0 ;

For each database you want the user to access, do:

GRANT ALL PRIVILEGES ON `databasename` . * TO 'username'@'hostname';

This basically means: create a user, with password “password”, don’t allow them to access anything except USAGE. Then, allow them to do anything they want in database “databasename”.