MySQL and MariaDB are both renowned open-source relational database management systems that power countless applications and services across diverse domains. While MySQL has been a staple in the industry since 1995, MariaDB emerged as a promising fork in 2009 following Oracle's acquisition of MySQL. Boasting MySQL compatibility along with added features and improvements, MariaDB has garnered significant adoption over the years.
These RDBMS platforms offer a suite of clients and utilities that facilitate seamless management and interaction with databases. With these tools, users can effortlessly create and modify databases, execute SQL queries, and manage user accounts. This guide will provide a step-by-step walkthrough for installing MySQL or MariaDB clients on CentOS, Red Hat, and Fedora distributions, catering to an audience well-versed in database management systems.
The following steps are tailored to provide a streamlined installation experience, culminating in a fully functional MySQL or MariaDB client on your system. These instructions assume that you have a fundamental understanding of Linux systems and databases.
sudo dnf update -y
sudo dnf install epel-release -y
sudo dnf install mysql-community-client -y sudo dnf install mariadb-client -y
mysql --version mariadb --version
sudo dnf install bash-completion -y
source /etc/profile.d/bash_completion.sh
source /etc/profile.d/bash_completion.sh
source ~/.bashrc
Comment anonymously. Login not required.