MySQL (v5.5) setup

This is how I setup a new MySQL database for a project (using a local HomeBrew root called sw):

unset TMPDIR
sw/bin/mysql_install_db --verbose --user=dnw \
  --basedir=sw/Cellar/mysql/5.5.20 --datadir=sw/var/mysql --tmpdir=/tmp
sw/bin/mysql.server start
create user [username]@localhost identified by '[password]';
create user [username] identified by '[password]';
grant all on *.* to [username]@localhost;
grant all on *.* to [username];

Creating a PostgreSQL database

Postgres is my favorite RDBMS, but I always forget how to setup a database. So this is mostly to remind myself 🙂

createuser --echo --no-createdb --encrypted --pwprompt --no-createrole \
  --no-superuser [ROLENAME]
createdb --echo --owner=[ROLENAME] [DBNAME]

Which echoes something like:

CREATE ROLE [ROLENAME] ENCRYPTED PASSWORD '[encrypted-password]' \
  NOSUPERUSER NOCREATEDB NOCREATEROLE INHERIT LOGIN;
CREATE DATABASE [DBNAME] OWNER [ROLENAME];

To connect use:

psql [DBNAME] [USERNAME]

That’s all 😀