Installing MySQL client for MariaDB databases

To use MariaDB as a backend database for Data Explorer, you must install the MySQL client and other required dependencies on all the Data Explorer hosts based on your operating system.

Cent OS
RHEL
SLES
Ubuntu

SSH into the Data Explorer host as a root user.
Install the required dependencies as follows:
```
yum install -y xmlsec1  xmlsec1-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.12 install mysqlclient
```

SSH into the Data Explorer host as a root user.

Install the required dependencies as follows:

yum install mysql-devel
yum install -y xmlsec1  xmlsec1-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:
(RHEL 8)
```
pip3.11 install mysqlclient
```
(RHEL 9)
```
pip3.12 install mysqlclient
```

SSH into the Data Explorer 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
```
note
While installing the mysql-devel and libmysqlclient-devel packages on SLES15, use the --replacefiles zypper switch or manually enter yes on the interactive pop-up that you see when the files are being overwritten. Else, you may see an error such as: File /usr/bin/mariadb_config from install of MariaDB-devel-<version>.x86_64 conflicts with file from install of libmariadb-devel-3.1.21-150000.3.33.3.x86_64 (SLES Module Server Applications Updates).
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.12 install mysqlclient
```

SSH into the Data Explorer 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.12 install mysqlclient
```