Skip to content

Instantly share code, notes, and snippets.

@Garbee
Created July 2, 2014 10:18
Show Gist options
  • Save Garbee/3b9250ba36f99cbf9d3a to your computer and use it in GitHub Desktop.
Save Garbee/3b9250ba36f99cbf9d3a to your computer and use it in GitHub Desktop.
MariaDB basics

Create Database

CREATE DATABASE {table name};

Create User

CREATE USER '{user name}'@'localhost' IDENTIFIED BY '{pass}';

Give user DB access

GRANT ALL ON {table name}.* TO '{user name}'@'localhost';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment