# MySQL 8.4.x on RHEL 8+ This article provides a detailed procedure for installing and configuring MySQL 8.4.x on Red Hat Enterprise Linux (RHEL) 8 or 9 systems. It includes prerequisites, installation steps, initial setup, and recommended performance tuning parameters as per OvalEdge guidelines. ## **Prerequisites** Ensure the following conditions before starting the installation: * A virtual machine (VM) or server running RHEL 8.x or 9.x * A user account with sudo privileges * An active internet connection is required to download packages * SELinux and firewall considerations (adjust as per your security policies) ## Installation Steps 1. **System Update** * Update the system packages. ```bash sudo yum update -y ``` \ *Sample Reference Screenshot:*
2. **Install Required Utilities** * Install `yum-utils` to manage repositories. ```bash sudo yum install -y yum-utils ``` 3. **Configure MySQL Repository** * Download and install the official MySQL 8.4 repository RPM. * **For RHEL 8:** ```bash wget https://dev.mysql.com/get/mysql84-community-release-el8-1.noarch.rpm sudo rpm -ivh mysql84-community-release-el8-1.noarch.rpm ``` * **For RHEL 9:** ```bash wget https://dev.mysql.com/get/mysql84-community-release-el9-1.noarch.rpm sudo rpm -ivh mysql84-community-release-el9-1.noarch.rpm ```

Use the correct .rpm file based on the OS version.

\ \&#xNAN;*Sample Reference Screenshot:*
4. **Disable Default MySQL Module** * Disable the default MySQL module to avoid conflicts. ```bash sudo yum module disable -y mysql ``` \ *Sample Reference Screenshot:*
5. **Install MySQL Server** * Install the MySQL community server package. ```bash sudo yum localinstall -y mysql84-community-release-el8-1.noarch.rpm ``` \ *Sample Reference Screenshot:*
6. **Start and Enable MySQL Service** * Start the MySQL service and enable it to run at boot. ```bash sudo systemctl start mysqld sudo systemctl enable mysqld sudo systemctl status mysqld ``` \ *Sample Reference Screenshot:*
* Verify the installed version: ```bash mysql --version ``` \ *Sample Reference Screenshot:*
7. **Retrieve Temporary Root Password** * Check the MySQL log to retrieve the temporary root password. ```bash sudo grep 'temporary password' /var/log/mysqld.log ``` \ *Sample Reference Screenshot:*
8. **Secure MySQL Installation** * Log in to MySQL and configure the root account. ```bash mysql -u root -p ``` \ *Sample Reference Screenshot:*
* Run the following SQL commands: ```sql ALTER USER 'root'@'localhost' IDENTIFIED BY ''; DELETE FROM mysql.user WHERE User=''; DROP DATABASE IF EXISTS test; DELETE FROM mysql.db WHERE Db='test' OR Db='test_%'; FLUSH PRIVILEGES; ```

Replace <NewSecurePassword> with a strong, secure password.

\ \&#xNAN;*Sample Reference Screenshot:*
9. **Apply Recommended Configuration** * Edit the MySQL configuration file: ```bash sudo vi /etc/my.cnf ``` * Append or update the following parameters: ```ini max_binlog_size=1G binlog_expire_logs_seconds=2592000 group_concat_max_len=4294967295 max_connections=600 max_allowed_packet=1G bind-address=0.0.0.0 innodb_buffer_pool_size=8G ``` \ *Sample Reference Screenshot:*
10. **Restart MySQL Service** * Apply the configuration changes by restarting the MySQL service. ```bash sudo systemctl restart mysqld sudo systemctl enable mysqld ``` \ *Sample Reference Screenshot:*
### OvalEdge Database Creation 1. **Import OvalEdge Schema** * Place the `MasterScripts.sql` file (provided by the OvalEdge team) in the MySQL VM.\ \ \&#xNAN;*Sample Reference Screenshot:*
* Connect to MySQL: ```bash mysql -u root -p ``` \ *Sample Reference Screenshot:*
* Run the script: ```sql SOURCE ; ```

Replace <path_to_MasterScripts.sql> with the actual file path.

2. **Verify Database Creation** * Check if the OvalEdge database has been created: ```sql SHOW DATABASES; ``` \ *Sample Reference Screenshot:*
* Expected output should include: * `ovaledgedb` *** Copyright © 2025, OvalEdge LLC, Peachtree Corners, GA, USA. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.ovaledge.com/release8.1/deployment-and-maintenance/installation/mysql-8.4.x-on-rhel-8+.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.