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.
Step 4: Now we will set the VALIDATE PASSWORD component.
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;