To Install Mysql And Create Database,Tables,Dump and Restore Mysql On Linux Mint 20.2

Introduction :

In a corporate network, databases can be anything from simple shopping lists to picture galleries. A relational database is a digital store that collects and organizes data according to a relationship model. A table in this model consists of rows and columns, and all relationships between elements follow a logical structure.

Installation Procedure:

Step 1 : Check the OS version by using the below command

root@linuxhelp:~# lsb_release -a
No LSB modules are available.
Distributor ID:	Linuxmint
Description:	Linux Mint 20.2
Release:	20.2
Codename:	uma

Step 2 : Install the mysql-server packages by using the below command

root@linuxhelp:~# apt install mysql-server mysql-client -y
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following NEW packages will be installed:
  mysql-client mysql-server
0 upgraded, 2 newly installed, 0 to remove and 16 not upgraded.
Need to get 19.0 kB of archives.
After this operation, 225 kB of additional disk space will be used.
Get:1 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 mysql-client all 8.0.27-0ubuntu0.20.04.1 [9,424 B]
Get:2 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 mysql-server all 8.0.27-0ubuntu0.20.04.1 [9,548 B]
Unpacking mysql-server (8.0.27-0ubuntu0.20.04.1) ...
Setting up mysql-server (8.0.27-0ubuntu0.20.04.1) ...
Setting up mysql-client (8.0.27-0ubuntu0.20.04.1) ...

Step 3 : To see the secure installation process by using the below command

root@linuxhelp:~# mysql_secure_installation

Securing the MySQL server deployment.

Connecting to MySQL using a blank password.

Press y|Y for Yes, any other key for No: y

There are three levels of password validation policy:

Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 1
Please set the password for root here.

New password: 

Re-enter new password: 

Estimated strength of the password: 25 
Success.

All done! 

Step 4 : Enter into the mysql shell by using the below command

root@linuxhelp:~# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.27-0ubuntu0.20.04.1 (Ubuntu)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Step 5 : List the database by using the below command

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

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

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| linuxhelp          |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

mysql> use linuxhelp;
Database changed

mysql> create table employe(empno int,name varchar(20),salary int);
Query OK, 0 rows affected (0.02 sec)

mysql> insert into employe values(101,'alex',10000);
Query OK, 1 row affected (0.01 sec)
mysql> insert into employe values(102,'richard',15000);
Query OK, 1 row affected (0.02 sec)
mysql> insert into employe values(103,'michel',20000);
Query OK, 1 row affected (0.00 sec)

mysql> select*from employe;
+-------+---------+--------+
| empno | name    | salary |
+-------+---------+--------+
|   101 | alex    |  10000 |
|   102 | richard |  15000 |
|   103 | michel  |  20000 |
+-------+---------+--------+
3 rows in set (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| linuxhelp          |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

mysql> use linuxhelp;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;
+---------------------+
| Tables_in_linuxhelp |
+---------------------+
| employe             |
+---------------------+
1 row in set (0.00 sec)

mysql> quit
Bye

root@linuxhelp:~# mysqldump -u root -p linuxhelp > linuxhelbkp.sql
Enter password: 

root@linuxhelp:~# ls
linuxhelbkp.sql

root@linuxhelp:~# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 8.0.27-0ubuntu0.20.04.1 (Ubuntu)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> drop database linuxhelp;
Query OK, 1 row affected (0.03 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql> create database linuxhelp;
Query OK, 1 row affected (0.01 sec)
Step 20 : Quit the mysql shell by using the below command
mysql> quit;
Bye

root@linuxhelp:~# mysql -u root -p -h localhost linuxhelp < linuxhelbkp.sql 
Enter password: 

root@linuxhelp:~# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 15
Server version: 8.0.27-0ubuntu0.20.04.1 (Ubuntu)

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| linuxhelp          |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

mysql> use linuxhelp;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A


Database changed

mysql> show tables;
+---------------------+
| Tables_in_linuxhelp |
+---------------------+
| employe             |
+---------------------+
1 row in set (0.00 sec)