SQL Cheatsheet(MySQL, PostgreSQL)

    mysql -h localhost -u root -p
// /usr/local/Cellar/[email protected]/x.xx.xx/bin/mysql -h localhost -u root
  

    mysql -u username -p database_name < file.sql
  

    show databases;
  

    use [db name];
show tables;
  

    SELECT User, Host, authentication_string FROM mysql.user;
  

    # Create a user
CREATE USER 'db_user'@'localhost' IDENTIFIED BY 'password';

# Create a database
CREATE DATABASE example_db;

# Grant privileges
GRANT ALL ON example_db.* TO 'db_user'@'localhost';
  

    # Delete database
DROP DATABASE example_db;

# Delete user
DROP USER 'db_user'@'localhost';
  

    quit