Snippets of code or commands that I refer to occasion.

MySQL

CREATE USER 'username'@'localhost' IDENTIFIED BY 'wrong mule fire paperclip';
GRANT ALL ON dbname.* to 'username'@'localhost';
FLUSH PRIVILEGES;