Installing MySQL client for MySQL databases

CDP uses Python version 3.8. To use MySQL as a backend database for Hue, you must install the MySQL client and other required dependencies on all the Hue hosts based on your operating system.

note

The version 2.2.0 of the MySQL client requires that you set the values of the MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS environment variables, as follows:

$ export MYSQLCLIENT_CFLAGS=`pkg-config mysqlclient --cflags`
$ export MYSQLCLIENT_LDFLAGS=`pkg-config mysqlclient --libs`

The version 2.2.0 of the MySQL client also requires you to install the Python 3 and MySQL development headers and libraries, as follows on Debian or Ubuntu operating systems:

sudo apt-get install python3-dev default-libmysqlclient-dev build-essential

or as follows on CentOS and RHEL operating systems:

sudo yum install python3-devel mysql-devel

Alternatively, you can install and use the version 2.1.1 of the MySQL client, as follows, which does not have this requirement:

pip3 install mysqlclient==2.1.1

The Hue service user and the root user must have the necessary permissions to access libraries installed in the Python site-packages directory.

Cent OS
RHEL 8
SLES 12
Ubuntu 18 and 20

SSH into the Hue host as a root user.

Download the MySQL yum repository as follows:

curl -sSLO https://dev.mysql.com/get/mysql80-community-release-el7-5.noarch.rpm

Install the package as follows:

rpm -ivh mysql80-community-release-el7-5.noarch.rpm

Install the required dependencies as follows:
```
yum install mysql-devel
yum install -y xmlsec1  xmlsec1-openssl
```
For MySQL version 8.0.27, add the mysql-community-client-8.0.25 client package as follows:
```
yum install mysql-community-client-8.0.25
```
Add the path where you installed the MySQL client and packages to the PATH environment variable as follows:
```
export PATH=/usr/local/bin:$PATH
```
Install the MySQL client as follows:
```
pip3.8 install mysqlclient
```

SSH into the Hue host as a root user.

Download the MySQL yum repository as follows:

(RHEL 7)

curl -sSLO https://dev.mysql.com/get/mysql80-community-release-el7-5.noarch.rpm

(RHEL 8)

curl -sSLO https://dev.mysql.com/get/mysql80-community-release-el8-8.noarch.rpm

Install the package as follows:

(RHEL 7)

rpm -ivh mysql80-community-release-el7-5.noarch.rpm

(RHEL 8)

rpm -ivh mysql80-community-release-el8-8.noarch.rpm

Install the required dependencies as follows:

yum install mysql-devel
yum install -y xmlsec1  xmlsec1-openssl

Add the path where you installed the MySQL client and packages to the PATH environment variable as follows:
```
export PATH=/usr/local/bin:$PATH
```
Install the MySQL client as follows:
```
pip3.8 install mysqlclient
```

SSH into the Hue host as a root user.

Install the required packages and dependencies as follows:

zypper install libmysqlclient-devel
zypper install xmlsec1
zypper install xmlsec1-devel
zypper install xmlsec1-openssl-devel

Add the path where you installed the packages to the PATH environment variable as follows:
```
export PATH=/usr/local/bin:$PATH
```
Install the MySQL client as follows:
```
pip3.8 install mysqlclient
```

SSH into the Hue host as a root user.

Install the required packages and dependencies as follows:

apt-get install libmysqlclient-dev
apt-get install -y xmlsec1
apt-get install libxmlsec1-openssl

Add the path where you installed the packages to the PATH environment variable as follows:
```
export PATH=/usr/local/bin:$PATH
```
Install the MySQL client as follows:
```
pip3.8 install mysqlclient
```