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.

  1. SSH into the Hue server host.
  2. Install the driver for connecting to the MySQL database server:
    yum install perl-DBD-MySQL
  3. Configure the RHEL 8 OS repository (/etc/yum.repos.d/mysql8.repo) to point to
  4. Install MySQL community server:
    yum install mysql-community-server-8.0.25 mysql-community-common-8.0.25 mysql-community-devel-8.0.25
  5. Copy the my__config_8h_source.html configuration file content to /usr/include/mysql/my_config.h.
  6. Install the MySQL Python interface:
    pip install MySQL-python --force-reinstall --ignore-installed
  7. 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.