How to Install MySQL on Linux?

MySQL is an open-source relational database management system that is based on SQL queries. Here, ‘My” represents the name of the co-founder is Michael Widenius’s daughter and “SQL” represents the Structured Query Language. This server is used for data operations like querying, filtering, sorting, grouping, modifying, and joining the tables present in the database. Before learning the queries, we are going to download and install MySQL on Linux. Some of the common features of MySQL are:

• It is easy to use and free of cost to download.
• It contains a solid data security layer to protect important data.
• It is based on client and server architecture.
• It supports multithreading which makes it more scalable.
• It is highly flexible and supported by multiple applications.
• The performance of MySQL is fast, efficient, and reliable.
• It is compatible with many operating systems like Windows, macOS, Linux, etc.   

Installing MySQL on Linux

For almost every Linux system, the following commands are used to install MySQL:

Step 1: Go to the terminal using Ctrl+Alt+T. Now using the following command to install MySQL(copy and past it in terminal).

sudo apt install mysql-server

Then give your password and hit ENTER. 

Step 2: Press “y” to continue.

It will take some time to download and install MySQL.

Step 3: To verify the installation or to know the version enter the following commands in your Terminal.

mysql --version

Step 4: Now we will set the VALIDATE PASSWORD component.

sudo mysql_secure_installation

Then press “y” to set the password. Next press “0” for the low-level password or choose as you want to set the password.

Create a password. Then Re-enter the password, then to continue press “y” s.

Now the whole setup is done.

Step 5: To get started with MySQL go to the root directory.  

sudo mysql -u root

Let’s create a database using the following command:

create database database_name;

show databases;

My Personal Notes arrow_drop_up

Save