How to Use MySQL from the Command Line on Ubuntu Server 20.04

Louis SanchezAugust 14th 2021, 9:38

Step 1 : First, we will need to connect to the MySQL server

mysql -u admin -h localhost -p

Replace admin with a user account on the MySQL server

Step 2 : Enter the password for the admin account

Step 3 : Create a database with the following query.

mysql> create database blog;

Step 4 : Check all databases with a show databases query.

mysql> show databases;

Step 5 : Select a database to work with

mysql> use blog;

Step 6 : Create a table to store our data. Use the following query to create a table

mysql> CREATE TABLE `persons` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `last_name` varchar(255) NOT NULL,
    `first_name` varchar(255) NOT NULL,
    `address` varchar(255) NOT NULL,
    `city` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1;

Step 7 : You can check tables with the show tables query

mysql> show tables;

Step 8 : let’s insert some data in our table.

mysql> INSERT INTO `persons` (`id`, `last_name`, `first_name`, `address`, `city`)
    VALUES (NULL, 'Santos', 'Matt', 'Kelley Road', 'Gulfport');

Step 9 : The following query will select all records from the articles table

mysql> Select * from persons;

Step 10 : Retrieve the selected records from the table

mysql> Select * from persons where id = 1;

Step 11 : Update the selected record

mysql> Update persons set last_name="New last_name" where id=1;

Step 12 : Delete the record, using the following command

mysql> Delete from persons where id = 1;