Category: SysAdmin

Do Not Fear the Command Line

A year and a half ago and the Mac terminal¬†scared me spitless. I didn’t know how to do anything with it and I didn’t know of anything that I really wanted to do with it. Then I started working with Vagrant, and then Git, and then Grunt, and pretty soon the command line didn’t seem so frightening any more. In fact, once I got down a few basic commands I started helping with server administration and other command liney things at the agency I worked for. Read more

Fighting with MySQL

Feel free to skip ahead to the conclusion.

Recently I just set up a new droplet on DigitalOcean for managing client staging sites. Since I already have a droplet setup there for my blog, I figured I’d just create a new droplet from my existing backups.

This worked great for the first 15 minutes until I started messing with MySQL. I chalked up the first issue to a faulty VM creation sequence and proceeded to destroy and recreate the droplet.

Once setup, I went in to start managing my databases like I had done the previous time and received the same error: “ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)”. Disheartened I Googled the issue and after coming up empty, decided to destroy and re-create the droplet a third time only this time I would leave the existing databases and only add new ones.

Success! Or so I thought. That strategy worked well for the first day, but as I went in to add another client site today I again came up with the same error. Now I am not a MySQL wiz and barely know enough to keep my server going. So I was scared. I realized this was an issue that I would have to face.

Read more