Installation of MySQL on Manjaro

Follow the below steps to install the MySQL database.

Step 1: We will update and upgrade our system by executing the following command:

$ sudo pacman -Syu

Step 2: Install MySQL from the official repository using pacman package manager

$ sudo pacman -S mysql

Step 3: Now, verify the installation by running the below command.

$ mysqld --version

Step 4: Run the following command before starting mysqld

$ mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

Step 5: Start the MySQL server by using the systemctl command.

$ sudo systemctl start mysqld
$ sudo systemctl status mysqld

Step 6: Once again use systemctl command to enable MySQL service. After command execution, MySQL will restart whenever our machine boots up.

$ sudo systemctl enable mysqld

MySQL is an open-source relational database management system developed by Oracle based on structured query language (SQL). It is primarily written in C and C++ programming languages and licensed under the GNU Public License. The client-end API is used to query, filter, sort, group, and modify data stored in the database table in the form of rows and columns. This article is a step-by-step guide for installing and configuring MySQL server on an Arch-based Linux system.