How to Install MySQL on CentOS 7
Install MySQL on CentOS 7
MySQL is one of the most popular opensource database management systems. MySQL is a relational database system. It is part of LAMP (Linux, Apache, MySQL, PHP) stack and LEMP (Linux, Apache, MySQL, PHP) stack. In this tutorial, you are going to learn how to install MySQL on CentOS 7.
Before you start to install MySQL on CentOS 7. You must have the root user account credentials of your system.
Following are the steps to install MySQL on CentOS. First, you need to enable mysql repository and then you can install MySQL-Server on CentOS.
First you should enable the MySQL 8.0 repository running following command:
sudo yum localinstall https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
Now to install
mysql-server package run below command:
sudo yum install mysql-community-server
Now confirm the installation and check MySQL version typing following command:
After completing installation MySQL will start automatically. Check MySQL version by typing:
sudo systemctl status mysql
The output should be:
● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: active (running) since Wed 2018-06-20 11:30:23 PDT; 5min ago Main PID: 17382 (mysqld) Tasks: 27 (limit: 2321) CGroup: /system.slice/mysql.service `-17382 /usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid
You can log in to MariaDB by typing
mysql -u root -p
Setting Up MySQL
After installation, we have to improve MySQL security by typing the following:
The above command will take you to different prompts. In the first prompt, it will ask you to configure
Validate Password Plugin which is used to set password validation strength and the levels are low, medium and high. You can prefer any of the strength levels you want to set. If you don’t want to set up the
Validate Password Plugin just press
ENTER. In the next prompts, you will be asked questions about increasing Security of MySQL. It is recommended to answer ‘Y’ for all questions asked during secure installation.
You have successfully learned how to install MySQL on CentOS 7. If you have any queries please don’t forget to comment out.
How to Remove Docker Images, Networks, Containers and Volumes
How to Install PyCharm on Ubuntu 18.04
How to Mount and Unmount Filesystems in Linux with Examples
Chown Command in Linux
Ping Command in Linux with Examples
How to Create New User and Grant Permissions in MySQL
How to install Node.js with npm on CentOS 7
How to Change Hostname on Debian 9
How to install Python on Ubuntu 18.04
Copy Files using cp command in Linux
How to Install VirtualBox on CentOS 7
How to Install PhpStorm on Ubuntu 18.04