2025-11-13

Installing MySQL 5.7 Community Server on AlmaLinux 10

This guide provides step-by-step instructions for installing MySQL 5.7 Community Server on AlmaLinux 10.

Prerequisites

AlmaLinux 10 system with sudo privileges
Internet connection for package downloads

Installation Steps

Step 1: Add MySQL Community Repository

Create the MySQL community repository configuration file:

sudo vim /etc/yum.repos.d/mysql-community.repo

Add the following content to the file:

[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
enabled=1
gpgcheck=0

[mysql-connectors-community]
name=MySQL Connectors Community
baseurl=http://repo.mysql.com/yum/mysql-connectors-community/el/7/$basearch/
enabled=1
gpgcheck=0

[mysql-tools-community]
name=MySQL Tools Community
baseurl=http://repo.mysql.com/yum/mysql-tools-community/el/7/$basearch/
enabled=1
gpgcheck=0

Step 2: Configure Repository Settings

Ensure MySQL 8.0 is disabled and MySQL 5.7 is enabled:

# Disable MySQL 8.0 Community Repository
sudo dnf config-manager --disable mysql80-community

# Enable MySQL 5.7 Community Repository
sudo dnf config-manager --enable mysql57-community

Step 3: Install MySQL 5.7 Community Server

Install the MySQL server package:

sudo dnf install mysql-community-server

Step 4: Start and Enable MySQL Service

Start the MySQL service and enable it to start automatically on boot:

sudo systemctl enable --now mysqld.service

Verify the service is running:

sudo systemctl status mysqld.service

Step 5: Retrieve Temporary Root Password

MySQL generates a temporary password for the root user during installation. Retrieve it using:

sudo grep 'A temporary password' /var/log/mysqld.log | tail -1

Example output:

2025-11-12T12:16:18.004506Z 1 [Note] A temporary password is generated for root@localhost: EQ(9h)1AsZen

Important: Make note of the password (in this example: EQ(9h)1AsZen) as you’ll need it for the next step.

Step 6: Secure MySQL Installation

Run the MySQL secure installation script to enhance security:

sudo mysql_secure_installation

Follow the interactive prompts:

Enter the temporary password you noted in the previous step
Set a new root password when prompted
Remove anonymous users: Select Yes
Disallow root login remotely: Select Yes
Remove test database: Select Yes
Reload privilege tables: Select Yes

Example interactive session:

Change the password for root ? (Press y|Y for Yes, any other key for No) : Yes

New password: [Enter your new secure password]
Re-enter new password: [Confirm your password]

Estimated strength of the password: 100
Do you wish to continue with the password provided?: Yes

Remove anonymous users?: Yes
Success.

Disallow root login remotely? : Yes
Success.

Remove test database and access to it? : Yes
 - Dropping test database...
Success.
 - Removing privileges on test database...
Success.

Reload privilege tables now? (Press y|Y for Yes) : Yes
Success.

All done!

Verification

Test your MySQL installation by connecting to the server:

mysql -u root -p

Enter your new root password when prompted. If successful, you’ll see the MySQL prompt:

mysql>

To exit MySQL, type:

EXIT;

Troubleshooting

Common Issues

Service fails to start: Check system logs with sudo journalctl -u mysqld.service
Cannot find temporary password: Ensure the service started properly and check /var/log/mysqld.log
Repository conflicts: Verify repository configuration and ensure conflicting MySQL packages are not installed