MySQL- Helpline (commands)

If you are on Linux or using the Windows MySQL shell, you can follow the commands below:

If you are completely brand new to SQL, I highly recommend checking our free SQL tutorial, downloading a sample database and learning a little about SQL. (click here)

Login to MySQL Shell

mysql -u root #Windows, no password

sudo mysql -u root #Linux, no password

sudo mysql -u root -p #If you have a password set
Password: [password-here]

Display ALL Databases

mysql> SHOW DATABASES;

+--------------------+
| Database           |
+--------------------+
| information_schema | #Default
| mysql              | #Default
| performance_schema | #Default
| sys                | #Default
| webapp_01          | #Created Database
+--------------------+
5 rows in set (0.00 sec)

Create Database

mysql> CREATE DATABASE testdb;
Query OK, 1 row affected (0.01 sec)

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema | #Default
| mysql              | #Default
| performance_schema | #Default
| sys                | #Default
| testdb             | -> Our New Database
| webapp_01          | -> Other Database
+--------------------+
6 rows in set (0.00 sec)

USE / SELECT Database

If you want to add any changes or send queries to your database, we have to select it, USE [dbname]`

mysql> USE webapp_01;
Database changed

mysql> DESCRIBE users;
+-----------+--------------+------+-----+---------+----------------+
| Field     | Type         | Null | Key | Default | Extra          |
+-----------+--------------+------+-----+---------+----------------+
| id        | int          | NO   | PRI | NULL    | auto_increment |
| username  | varchar(50)  | YES  |     | NULL    |                |
| email     | varchar(90)  | YES  | UNI | NULL    |                |
| password  | varchar(255) | YES  |     | NULL    |                |
| otp_code  | int          | YES  |     | NULL    |                |
| role      | int          | YES  |     | NULL    |                |
| is_active | int          | YES  |     | NULL    |                |
+-----------+--------------+------+-----+---------+----------------+
7 rows in set (0.05 sec)


mysql> SELECT * FROM users;
+----+----------+-------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+------+-----------+
| id | username | email             | password               | otp_code | role | is_active |
+----+----------+-------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+------+-----------+
|  1 | admin    | [e-mail]   | pbkdf2:sha512:1000000$ |      278 |    1 |         1 |
|  2 | testing  | [e-mail] | pbkdf2:sha512:1000000$ |     NULL |    3 |         0 |
|  3 | user     | [e-mail]   | pbkdf2:sha512:1000000$ |     NULL |    5 |         1 |
|  5 | user5    | [e-mail]     | pbkdf2:sha512:1000000$ |     NULL |    5 |         1 |
+----+----------+-------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+------+-----------+
4 rows in set (0.00 sec)