Why do I get an error when installing clickhouse-mysql-data-reader?

Question

pip

Installing clickhouse-mysql-data-reader and getting the following error

Mistake

[[email protected] ~]# pip3 install -e ./clickhouse-mysql-data-reader/
Obtaining file:///root/clickhouse-mysql-data-reader
Collecting mysqlclient
Using cached mysqlclient-2.0.1.tar.gz (87 kB)
ERROR: Command errored out with exit status 1:
command: /usr/bin/python3.6 -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-2gabu1yg/mysq lclient/setup.py'"'"'; __file__='"'"'/tmp/pip-install-2gabu1yg/mysqlclient/setup.py'"'"';f=getattr(tokenize, '"'"'open'" '"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exe c'"'"'))' egg_info --egg-base /tmp/pip-pip-egg-info-p0u782lt
cwd: /tmp/pip-install-2gabu1yg/mysqlclient/
Complete output (12 lines):
/bin/sh: mysql_config: command not found
/bin/sh: mariadb_config: command not found
/bin/sh: mysql_config: command not found
Traceback (most recent call last):
File "", line 1, in
File "/tmp/pip-install-2gabu1yg/mysqlclient/setup.py", line 15, in
metadata, options = get_config()
File "/tmp/pip-install-2gabu1yg/mysqlclient/setup_posix.py", line 65, in get_config
libs = mysql_config("libs")
File "/tmp/pip-install-2gabu1yg/mysqlclient/setup_posix.py", line 31, in mysql_config
raise OSError("{} not found".format(_mysql_config_path))
OSError: mysql_config not found
----------------------------------------
ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.

==============================
Tell me how to deal with this? I need to migrate from MySQL to ClickHouse, and unfortunately this is my barrier ((
Tried to google, but did not find the answer after trying a bunch of methods, now I ask you for help!
Thank you!))

Answer 1

You must first install mysql itself as well as the system libraries of the mysql client.