Cyan Hall C H
Created by CyanHall.com. Last updated: 12/03/2020 👉  

1. CLI Login

    mysql -h localhost -u root -p
  

2. import an SQL file

    mysql -u username -p database_name < file.sql
  

3. List all databases

    show databases;
  

4. List all tables in a database

    use [db name];
show tables;
  

5. List all users

    SELECT User, Host, authentication_string FROM mysql.user;
  

6. Create user and database

    # 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';
  

7. Delete user and database

    # Delete database
DROP DATABASE example_db;

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

8. Quit CLI

    quit