mysql8连接5sslexecptio_python 链接mysql数据库使用 mysql-connector 方式

用linux上 用python对mysql进行连接

前提遇到的问题记录：

在linux上安装

(base) [sqoop@flink-slave5 bin]$ ./pip install mysql

Looking in indexes: http://pypi.douban.com/simple

Collecting mysql

Downloading http://pypi.doubanio.com/packages/bf/5f/b574ac9f70811df0540e403309f349a8b9fa1a25d3653824c32e52cc1f28/mysql-0.0.2.tar.gz (1.9 kB)

Collecting mysqlclient

Downloading http://pypi.doubanio.com/packages/d0/97/7326248ac8d5049968bf4ec708a5d3d4806e412a42e74160d7f266a3e03a/mysqlclient-1.4.6.tar.gz (85 kB)

|████████████████████████████████| 85 kB 4.0 MB/s

ERROR: Command errored out with exit status 1:

command: /data/python_test/bin/python -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-s6ioj0n3/mysqlclient/setup.py'"'"'; __file__='"'"'/tmp/pip-install-s6ioj0n3/mysqlclient/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' egg_info --egg-base /tmp/pip-install-s6ioj0n3/mysqlclient/pip-egg-info

cwd: /tmp/pip-install-s6ioj0n3/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-s6ioj0n3/mysqlclient/setup.py", line 16, in

metadata, options = get_config()

File "/tmp/pip-install-s6ioj0n3/mysqlclient/setup_posix.py", line 61, in get_config

libs = mysql_config("libs")

File "/tmp/pip-install-s6ioj0n3/mysqlclient/setup_posix.py", line 29, in mysql_config

raise EnvironmentError("%s not found" % (_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.

解决方法： [root@flink-slave5 ~]# yum install mysql-devel gcc gcc-devel python-devel

参考链接 https://www.jianshu.com/p/5b6deb15bd21

(base) [sqoop@flink-slave5 bin]$ pwd

/data/python_test/bin

(base) [sqoop@flink-slave5 bin]$ ./pip install mysql

Looking in indexes: http://pypi.douban.com/simple

Collecting mysql

Downloading http://pypi.doubanio.com/packages/bf/5f/b574ac9f70811df0540e403309f349a8b9fa1a25d3653824c32e52cc1f28/mysql-0.0.2.tar.gz (1.9 kB)

Collecting mysqlclient

Downloading http://pypi.doubanio.com/packages/d0/97/7326248ac8d5049968bf4ec708a5d3d4806e412a42e74160d7f266a3e03a/mysqlclient-1.4.6.tar.gz (85 kB)

|████████████████████████████████| 85 kB 14.8 MB/s

Building wheels for collected packages: mysql, mysqlclient

Building wheel for mysql (setup.py) ... done

Created wheel for mysql: filename=mysql-0.0.2-py3-none-any.whl size=1243 sha256=81bb94d982e366e617bf2dd96df9735009fea2ad983b60198d054773df25dde2

Stored in directory: /home/sqoop/.cache/pip/wheels/42/09/8b/d90224fd8b5636800fa21b9ede51f208bb1781bf7f52b89085

Building wheel for mysqlclient (setup.py) ... done

Created wheel for mysqlclient: filename=mysqlclient-1.4.6-cp37-cp37m-linux_x86_64.whl size=59120 sha256=1d83233315a664a264e51acb1b0288979b0f621da6c15a0f