How to install MySQL and MariaDB on Centos 7

• 27 February 2023
• ThunderVM Team
• Information Technology, Linux

MySQL and MariaDB are two of the most popular open-source relational database management systems (RDBMS) used to store and manage data for web applications. While both are very similar, there are some differences that set them apart. In this blog post, we will discuss the differences between MySQL and MariaDB and guide you through the steps to install and configure them on CentOS 7.

This post will guide you on how to install and upgrade pip on a linux vps or on a linux dedicated server.

MySQL vs. MariaDB

MySQL is a well-established RDBMS developed by Oracle Corporation. It is known for its reliability, scalability, and robust features, making it a popular choice for enterprise-level applications. MariaDB, on the other hand, is a community-developed fork of MySQL, designed to be a drop-in replacement for MySQL. It is known for its improved performance, security, and compatibility with MySQL.

While MariaDB maintains compatibility with MySQL, it has added several features that improve its performance and security. For example, MariaDB includes Galera Cluster, a multi-master replication tool that provides high availability and automatic failover. It also includes XtraDB, a drop-in replacement for InnoDB, which improves the performance and scalability of the database.

Installing MySQL and MariaDB on Centos 7

Install MySQL on CentOS 7 – How To

• Update your system using the following command: sudo yum update -y
• Install the MySQL community repository using the following command: sudo yum install https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
• Install MySQL using the following command: sudo yum install mysql-community-server -y
• Start and enable MySQL on boot using the following commands: sudo systemctl start mysqld and sudo systemctl enable mysqld

Install MariaDB on CentOS 7 – How To

1. Update your system using the following command: sudo yum update -y
2. Install MariaDB using the following command: sudo yum install mariadb-server -y
3. Start and enable MariaDB on boot using the following commands: sudo systemctl start mariadb and sudo systemctl enable mariadb

Configuring MySQL and MariaDB

After installing MySQL or MariaDB, you will need to configure them for your specific needs. Here are some basic configuration steps you can follow:

• Secure your database by running the mysql_secure_installation command, which will prompt you to set a root password, remove anonymous users, disable root login remotely, and remove test databases.
• Create a new user with appropriate permissions for your database using the CREATE USER and GRANT commands.
• Configure your database settings by editing the my.cnf file located in /etc/mysql or /etc/my.cnf.d.

Conclusion

MySQL and MariaDB are both powerful RDBMS that can help you manage your data effectively. While they are similar in many ways, MariaDB has added features that make it a more performant and secure option. By following the installation and configuration steps outlined in this post, you can get your MySQL or MariaDB database up and running in no time.