Working with databases

Useful commands when working with databases

Published November 2, 2026 1 min read Updated November 2, 2026

On this page

mysql -u root -p

Show all databases

show databases

CREATE DATABASE database_name;

use database_name;

SELECT DATABASE();

DROP DATABASE IF EXISTS database_name;

SHOW TABLES;

DESCRIBE table_name;

use db_name;

source path/to/file.sql