Cyan Hall C H
Created by 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

# 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