liamcurry/Snippets.md

Created November 10, 2012 16:26

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/liamcurry/4051577.js"></script>
Save liamcurry/4051577 to your computer and use it in GitHub Desktop.

Maintenance snippets

Raw

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;

Select an option