Installing MySQL on CentOS 7

MySQL is an open-source relational database management system. It is widely used for managing and storing data in various web applications, including websites, content management systems, and e-commerce platforms.

Step 1: Update Server

Before installing MySQL, it's always recommended to update the server to the latest packages. Open your terminal and run the following command:

sudo yum update -y

Step 2: Install MySQL

To install MySQL, use the following command:

sudo yum install mysql-server -y

Step 3: Start MySQL

After the installation is complete, start the MySQL service by running:

sudo systemctl start mysqld

Step 4: Secure MySQL Installation

For security reasons, it is recommended to run the MySQL secure installation script that ships with the MySQL package. This script helps you set a root password, remove anonymous users, disable remote root login, and more. Run the following command and follow the prompts:

sudo mysql_secure_installation

Step 5: Enable MySQL on Boot

To ensure that MySQL starts automatically on system boot, execute the following command:

sudo systemctl enable mysqld

Step 6: Check MySQL Status

To verify that MySQL is running, use the command:

sudo systemctl status mysqld

Step 7: Access MySQL Shell

You can now access the MySQL shell by running the following command:

sudo mysql

Conclusion

Congratulations! You have successfully installed MySQL on CentOS 7. MySQL is now ready to be used for your web applications or any other projects that require a database management system.