Sysadmin
Mon, Feb 10, 2014
When I was starting out as a sysadmin I would hear and read “don’t use kill -9” all the time. But rarely did anyone explain that to do instead. I saw this the other day and liked it. Randal Schwartz, who wrote many of the Perl books those of us who were sysadmins in the 90s and 00s lived by, would post this to lists. No no no. Don’t use kill -9.

Sat, Mar 30, 2013

Another one I never remember the exact syntax for (nor how to spell privileges correctly). Simple thing - creating a user for MySQL and grant privileges. Less is more.

CREATE USER '%USER%'@'%HOST%' IDENTIFIED BY '%PASSWORD%';
GRANT %PRIVILEGES% ON %DATABASE%.* TO '%USER%'@'%HOST%';
FLUSH PRIVILEGES