MySQL

mysql.md

create user

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

grant privilages to user

GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost';
FLUSH PRIVILEGES;

delete user

DROP USER 'username'@'localhost';

user grants

SHOW GRANTS FOR 'user'@'localhost';

create db

CREATE DATABASE dbname;

show dbs

SHOW DATABASES;

use specific db

USE dbname

show selected db tables

SHOW TABLES;

create table

CREATE TABLE tablename(
  c1 type meta,
  c2 type meta,
  ...
);

delete a table

DROP TABLE tablename;

delete a database

DROP DATABASE dbname;

exit from mysql

exit