An Easier Way to Set Up Remote Git Repositories for Lightweight Deployment

In an earlier post, I wrote about how I do very, very lightweight deployment with git. I found myself doing this over and over again, so here is a little script that does it for you. Now getting your local code on your server is as easy as: server$ python create_repo.py repo.git /your/checkout/directory/ local$ git … Continue reading An Easier Way to Set Up Remote Git Repositories for Lightweight Deployment

Create MySQL Database and Give User Permissions

I always find myself needing to look up this exact syntax. mysql> create database MY_DATABASE character set utf8; Query OK, 1 row affected (0.04 sec) mysql> grant all privileges on MY_DATABASE.* to ‘MY_USERNAME’@’localhost’ identified by ‘MY_PASSWORD’; Query OK, 0 rows affected (0.06 sec)