Home AlmaLinux How to Install MySQL on AlmaLinux

How to Install MySQL on AlmaLinux

Brief: This article guide takes us through the installation, configuration, and testing of MySQL database server software on an AlmaLinux 9 and AlmaLinux 8 distribution.

MySQL, the most popular open-source database management software solution, is developed, distributed, and supported by Oracle Corporation. However, if linked with Linux, Apache/Nginx, and PHP/Python/Pearl, it creates a complete LAMP or LEMP stack solution, which makes data query and management possible through its implementation of SQL (Structured Query Language) and relational models.

Step 1: Installing MySQL on AlmaLinux

An up-to-date Linux operating system distribution provides a better performance spectrum for installed software:

$ sudo dnf update 

We will use AlmaLinux’s default repository to fetch and install the latest MySQL package (mysql-server) alongside needed MySQL dependencies.

$ sudo dnf install mysql-server 
Install MySQL in AlmaLinux
Install MySQL in AlmaLinux

Once the installation command finishes its execution, we can proceed to confirm the installed MySQL version:

$ mysql --version

mysql Ver 8.0.30 for Linux on x86_64 (Source distribution)

MySQL does not automatically start running after its installation, you need to start it, enable it to start at system startup, and verify the status by running the following commands.

$ sudo systemctl start mysqld 
$ sudo systemctl enable mysqld 
$ sudo systemctl status mysqld 
Check MySQL Status in AlmaLinux
Check MySQL Status in AlmaLinux

If you later feel like disabling MySQL service so that it does not automatically run after system startup, execute:

$ sudo systemctl disable mysqld

Step 2: Securing MySQL on AlmaLinux

To improve MySQL security, change some of its default configuration options by executing the following MySQL security script.

$ sudo mysql_secure_installation

You will be taken through a series of interactive prompts that will enable you to choose whether to:

  • validate your password
  • remove anonymous users
  • disallow root login remotely
  • remove test database
  • reload table privileges
Secure MySQL in AlmaLinux
Secure MySQL in AlmaLinux

Step 3: Testing MySQL in AlmaLinux

You can verify your MySQL installation and view some of its information using the mysqladmin command, a client tool for performing administrative operations as shown.

$ mysqladmin -u root -p version

If you would like to connect to MySQL and start creating data on it, run the following:

$ mysql -u root -p

From here, you should be able to create and load databases or execute queries related to your database projects.

[ You might also like: MySQL Database Commands Cheat Sheet for Linux ]

With MySQL software installed on AlmaLinux, you should be able to pursue your database-driven projects to their full potential comfortably.

Ravi Saive
I am an Experienced GNU/Linux expert and a full-stack software developer with over a decade in the field of Linux and Open Source technologies. Founder of TecMint.com, LinuxShellTips.com, and Fossmint.com. Over 150+ million people visited my websites.

Each tutorial at UbuntuMint is created by a team of experienced writers so that it meets our high-quality standards.

Was this article helpful? Please add a comment to show your appreciation and support.

Got something to say? Join the discussion.

Thanks for choosing to leave a comment. Please keep in mind that all comments are moderated according to our comment policy, and your email address will NOT be published or shared. Please Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.