How to reset MySQL root password from command line

Because you will mess this up and need to reset the password from the command line. SSH into your server and: su - sudo service mysqld stop sudo mysqld_safe --skip-grant-tables That's stopping MySQL on Red Hat family. If you have something else, just go lie in the road and…

Google to decouple Google+ and YouTube, sort of

In a move that's only several years too late, Google has announced that they will no longer force users to have a Google+ account in order to use YouTube. At first this seems like great news, but then this sinks in: ...[I]n the coming months, a Google Account will…

Why you (probably) don't want to run your own email server

I just finished four years of running a corporate email server, and here are my thoughts on why I'd never do it again within the context of a young SME. Before I start: I'm not saying don't learn how to set up an email server, because there is definitely a…

2013 World Chess Championship on GitHub

Here's my Git repository of .pgn files for the 2013 World Chess Championship between Viswanathan Anand and Magnus Carlsen.…

Cleaning up and formatting your database query results in CodeIgniter

This is actually an old post that was on my old blog. But people have been searching for it a lot and now they can't find it, so I'm reposting it. For the record, I don't think anyone should be doing new sites in CodeIgniter 2.x, but I know…

Dodgy advertising on Facebook

There have recently been several articles posted around the web on whether or not Facebook advertising is a good value for advertisers, given how many clicks and likes seem to come from fake accounts and botnets. But here's an advert I came across on Facebook this afternoon: This immediately struck…