CREATE USER 'sammy'@'localhost/ip-of-server' IDENTIFIED BY 'password';

GRANT (PRIVILEGE) ON [database].[table] TO 'username'@'host/ip';

GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD ON *.* TO 'sammy'@'localhost' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'sammy'@'localhost' WITH GRANT OPTION;

FLUSH PRIVILEGES;

REVOKE type_of_permission ON database_name.table_name FROM 'username'@'host';

SHOW GRANTS FOR 'username'@'host';

DROP USER 'username'@'localhost';

mysql> system clear;

CREATE DATABASE [IF NOT EXISTS] database_name;

USE database_name;

DROP DATABASE [IF EXISTS] database_name;

SHOW DATABASES;

DESCRIBE animal;

SHOW TABLES;

CREATE TABLE [IF NOT EXISTS] table_name (
  column_list
);

ALTER TABLE animal RENAME pet;

ALTER TABLE table 
ADD [COLUMN] column_name;

ALTER TABLE table_name
DROP [COLUMN] column_name;

DROP TABLE [IF EXISTS] table_name;

DESCRIBE table_name;

DESCRIBE table_name column_name;

DELETE FROM table_name;

mysqldump -u [username] -p [database_name] > data_backup.sql

mysql -u [username] -p [database_name] < data_backup.sql

sudo apt install mysql-server

sudo mysql_secure_installation

sudo mysql

mysql -u username -p

mysql -u root -p
USE database_name;

mysql> help;