Installing and configuring MySQL on RHEL 8

The steps for installing and configuring MySQL version 8.0.25 on RHEL 8 on a CDP cluster host are different. Make sure that you copy the corresponding my__config_8h_source.html content to the my_config.h file corresponding to your MySQL server version.

SSH into the Hue server host.
Install the driver for connecting to the MySQL database server:
```
yum install perl-DBD-MySQL
```
Configure the RHEL 8 OS repository (/etc/yum.repos.d/mysql8.repo) to point to http://repo.mysql.com/yum/mysql-8.0-community/el/8/x86_64/.

Install MySQL community server:

yum install mysql-community-server-8.0.25 mysql-community-common-8.0.25 mysql-community-devel-8.0.25

Copy the my__config_8h_source.html configuration file content to /usr/include/mysql/my_config.h.

Install the MySQL Python interface:

pip install MySQL-python --force-reinstall --ignore-installed

Grant read and execute permissions to all users and write access to the admin user:

chmod 755 chmod -R 755 /usr/lib64/python2.7/site-packages/MySQLdb /usr/lib64/python2.7/site-packages/MySQL_python* /usr/lib64/python2.7/site-packages/_mysql*

After installing the MySQL server, create the Hue database and configure MySQL as the backend database for Hue.