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
Step 2: Install MySQL
Install MySQL from the official repository using the pacman package manager:
sudo pacman -S mysql
Step 3: Verify Installation
Confirm the installation by checking the MySQL version:
mysqld --version
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
Step 5: Start MySQL
Initiate the MySQL server using systemctl:
sudo systemctl start mysqld
sudo systemctl status mysqld
Step 6: Enable MySQL
Enable MySQL to start on system boot:
sudo systemctl enable mysqld
Configuring MySQL
Step 1: Secure Installation
Run the MySQL security installation script to configure security settings:
sudo mysql_secure_installation
Step 2: Log into MySQL
Access the MySQL command-line interface as the root user:
sudo mysql
Step 3: Create User
Create a new MySQL user with the desired username and password:
CREATE USER '<username>'@'localhost' IDENTIFIED BY '<password>';
Step 4: Grant Privileges
Grant all privileges to the newly created user:
GRANT ALL PRIVILEGES ON *.* TO '<username>'@'localhost' WITH GRANT OPTION;
Step 5: Flush Privileges
Flush privileges to apply the changes and exit MySQL:
FLUSH PRIVILEGES;
exit
Step 6: Log in with New User
Log in to MySQL with the newly created user:
mysql -u <username> -p
Step 7: Create Database
Create a new database for your application:
CREATE DATABASE <dbname>;
Step 8: Verify Databases
List all available databases to verify the successful creation:
SHOW DATABASES;
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)
If anyone wants to specifically want to install mysql not mariadb then this wont help
Nice tutorial, thx bro