Login 1. mysql -u myusername -p OR mysql (root user) 2. enter password 3. mysql> SHOW DATABASES; Create&Drop database 1. mysql> CREATE DATABASE database_name; 1.1. mysql> CREATE DATABASE db_name CHARACTER SET utf8 COLLATE utf8_general_ci; 2. mysql> DROP DATABASE database_name; Show grants 1. mysql> SHOW GRANTS; 1. mysql> SHOW GRANTS username; Grant database - from root user 1. mysql> GRANT ALL PRIVILEGES ON db_name.* TO 'username'@'localhost'; ALL PRIVILEGES: CREATE, DELETE DB etc mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost'; p.s. always write ; at the end https://linuxize.com/post/how-to-show-databases-in-mysql/ https://www.mysqltutorial.org/mysql-create-database/