DEV Community

Cover image for Installing and Configuring MySQL on Arch Linux
tinApyp
tinApyp

Posted on

Installing and Configuring MySQL on Arch Linux

MySQL, a robust and widely used relational database management system, serves as a cornerstone for many applications and systems. Installing it on Arch Linux, a rolling release distribution known for its flexibility and cutting-edge features, requires a few steps to ensure a smooth setup. Follow this comprehensive guide to install and configure MySQL on your Arch-based system.

Step 1: Update System
Before proceeding with the installation, ensure your system is up-to-date. Open a terminal and execute the following command:

sudo pacman -Syu
Enter fullscreen mode Exit fullscreen mode

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

sudo pacman -S mysql
Enter fullscreen mode Exit fullscreen mode

Step 3: Verify Installation
Confirm the installation by checking the MySQL version:

mysqld --version
Enter fullscreen mode Exit fullscreen mode

Step 4: Initialize MySQL
Initialize the MySQL data directory before starting the server:

sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
Enter fullscreen mode Exit fullscreen mode

Step 5: Start MySQL
Initiate the MySQL server using systemctl:

sudo systemctl start mysqld
sudo systemctl status mysqld
Enter fullscreen mode Exit fullscreen mode

Step 6: Enable MySQL
Enable MySQL to start on system boot:

sudo systemctl enable mysqld
Enter fullscreen mode Exit fullscreen mode

Configuring MySQL

Step 1: Secure Installation
Run the MySQL security installation script to configure security settings:

sudo mysql_secure_installation
Enter fullscreen mode Exit fullscreen mode

Step 2: Log into MySQL
Access the MySQL command-line interface as the root user:

sudo mysql
Enter fullscreen mode Exit fullscreen mode

Step 3: Create User
Create a new MySQL user with the desired username and password:

CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';
Enter fullscreen mode Exit fullscreen mode

Step 4: Grant Privileges
Grant all privileges to the newly created user:

GRANT ALL PRIVILEGES ON *.* TO '<username>'@'localhost' WITH GRANT OPTION;
Enter fullscreen mode Exit fullscreen mode

Step 5: Flush Privileges
Flush privileges to apply the changes and exit MySQL:

FLUSH PRIVILEGES;
exit
Enter fullscreen mode Exit fullscreen mode

Step 6: Log in with New User
Log in to MySQL with the newly created user:

mysql -u <username> -p
Enter fullscreen mode Exit fullscreen mode

Step 7: Create Database
Create a new database for your application:

CREATE DATABASE <dbname>;
Enter fullscreen mode Exit fullscreen mode

Step 8: Verify Databases
List all available databases to verify the successful creation:

SHOW DATABASES;
Enter fullscreen mode Exit fullscreen mode

Congratulations! You have now successfully installed and configured MySQL on your Arch Linux system. You're ready to leverage the power of MySQL for your applications and projects.

Top comments (2)

Collapse
 
izaan_107fb6df7d541577843 profile image
Izaan

If anyone wants to specifically want to install mysql not mariadb then this wont help

Collapse
 
seno21 profile image
Fega Suseno

Nice tutorial, thx bro