Maintenance snippets

Snippets.md

Start/Restart/Stop MySQL

mysql.server [stop|start|restart]

Create a MySQL database

create database db_name;

Create a new MySQL user

create user 'username'@'localhost' identified by 'password';

Give a MySQL user access to a DB

grant all privileges on 'username'@'localhost' to 'username'@'localhost' with grant option;