Skip to content

Instantly share code, notes, and snippets.

@kapillamba4

kapillamba4/mariadb_basics.md

Forked from Garbee/mariadb_basics.md
Created January 12, 2018 21:16
Show Gist options
  • Save kapillamba4/613d24e976b20802d06f57bb65b4ca60 to your computer and use it in GitHub Desktop.
Save kapillamba4/613d24e976b20802d06f57bb65b4ca60 to your computer and use it in GitHub Desktop.
Download ZIP
MariaDB basics
Raw
mariadb_basics.md

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