MySQL for beginners

A summary of commands to get beginners started with MySQL or MariaDB.

To start the MySQL monitor type

mysql or sudo mysql

The mysql monitor will start.



Use the exit command to leave the MySQL monitor.

mysql> exit

Show databases

Show all databases currently in use:

mysql> show databases;

| Database                           |
| information_schema      |
| database1                           |
| database2                          |

3 rows in set (0.01 sec)

Create database

To create a database use the create database command

mysql> create database new_database_name;
Query OK, 1 row affected (0.00 sec)

Drop database

To drop or delete  a database us the drop database command

mysql> drop database new_database_name;
Query OK, 0 rows affected (0.01 sec)

Create user

To create or add a user to MySQL use the create user command

mysql> create user 'new_user'@'localhost' IDENTIFIED BY 'user_password';
Query OK, 0 rows affected (0.01 sec)

Drop user

To remove or drop a user from MySQL use the drop user command

mysql> drop user 'new_user'@localhost;
Query OK, 0 rows affected (0.00 sec)

Grant privileges

To give read write access and connection rights to users use the grant privileges command.
To give all privileges use:

mysql> grant all privileges on new_database_name.* to 'new_user'@'localhost';
Query OK, 0 rows affected (0.00 sec)

Revoke privileges

To revoke all access read and write privileges for a user use revoke all privileges

mysql> revoke all privileges, grant option from 'new_user'@'localhost';
Query OK, 0 rows affected (0.00 sec)