Managing databases is a vital component of contemporary IT systems. From powering websites and applications to handling local data management, SQL databases like MySQL and MariaDB are widely utilized.
Both MySQL and MariaDB are compatible with an array of systems, including CentOS, Red Hat, and Fedora. While MySQL is renowned as an open-source relational database system, MariaDB serves as a MySQL-compatible relational database system, binary-compatible with MySQL, and enriched with additional features and storage engines.
Installing only the client for MySQL or MariaDB, as opposed to the full server package, can be a strategic choice. It enables database management from your local machine without the necessity of having the complete server package installed, thus saving resources and maintaining efficiency.
Steps to install MySQL or MariaDB client on CentOS, Red Hat, Fedora:
- Open a terminal window on your system.
- Update your system packages.
sudo dnf update -y
- Enable the (Extra Packages for Enterprise Linux) repository if you are using CentOS or Red Hat.
sudo dnf install epel-release -y
- Install your preferred RDBMS client.
$ sudo yum install mysql-community-client $ sudo yum install MariaDB-client
- Verify the installation by checking the version of the installed client.
mysql --version mariadb --version
Mohd Shakir Zakaria is an experienced cloud architect with a strong development and open-source advocacy background. He boasts multiple certifications in AWS, Red Hat, VMware, ITIL, and Linux, underscoring his expertise in cloud architecture and system administration.
Comment anonymously. Login not required.