MySQL Server Installation and Initial Configuration on CentOS/RHEL
MySQL is the world's most popular open source relational database management system that runs as a server providing multi-user access to a number of databases.
This guide explains how to install and perform the initial secure configuration of MySQL Server on CentOS/RHEL based systems.
MySQL Server Installation
Install MySQL Server and MySQL Client using 'yum' command.
Set the MySQL server daemon to start at boot.
MySQL Server Initial Configuration
Run MySQL secure installation script.
Perform the next steps :
- [Y] - Set the root password;
- [Y] - Remove anonymous users;
- [Y] - Disallow root login remotely;
- [Y] - Remove test database and access to it;
- [Y] - Reload privilege tables.
Once these steps are complete you would be able to log into MySQL Server console with the following command :