How to remotely connect to your DigitalOcean mySQL database with HeidiSQL

Since I prefer to keep my DigitalOcean droplets als lean as possible, I never install phpMyAdmin but instead connect using HeidiSQL.

HeidiSQL is a free and open source client, or frontend for MySQL that makes managing your MySQL databases a breeze.

In this post I shall explain how to remotely connect to your DigitalOcean mySQL database with HeidiSQL over an SSH connection. Continue reading

Misconceptions about commercial WordPress themes

WordPress theme marketplaces where you can buy commercial WordPress themes are rapidly gaining popularity, and must admit that I have bought and used some commercial themes myself. Unfortunately many people are under the impression that these cheap themes are the perfect solution for all their needs. While a $30 might seem good value, this is not necessary the case.

At WordCamp Chicago 2011 Andy Stratton gave a presentation called “Diet Pills, SEO, and Theme Frameworks”. He talked about WordPress themes, frameworks, marketplaces and a lot of related misconceptions, and some of the many problems with commercial themes including SEO, customization, child themes.

So while there are some cases where a commercial $30 theme could work, usually these themes are slow, bloated with unnecessary options and will require a lot of expensive customization.