MySQL / cmd - most useful commands

In this article, we would like to show you the most useful cmd commands for MySQL.

Quick solution:

xxxxxxxxxx

mysql -u root -p

Full command: 

xxxxxxxxxx

mysql --user=<username> --password=<password>

Note:

If you didn't specify password during mysql installation use the following command:

Copy

xxxxxxxxxx

 

1

mysql --user=root --password=

Quick solution:

xxxxxxxxxx

SHOW databases;

Quick solution:

xxxxxxxxxx

CREATE DATABASE database_name;

xxxxxxxxxx

DROP DATABASE database_name;

Quick solution:

xxxxxxxxxx

USE database_name;

Note:

To switch database simply use the above command with a different database_name.

Quick solution:

xxxxxxxxxx

SHOW tables;

Quick solution:

xxxxxxxxxx

CREATE TABLE table_name;

xxxxxxxxxx

DROP TABLE table_name;