pip install mysqlclient错误提示

admin

pip install mysqlclient
Collecting mysqlclient
2 c3 L2 z1 w9 ?" S5 X+ w  Using cached mysqlclient-2.2.4.tar.gz (90 kB)
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
1 j: J$ i  d. g5 t  ^, o  Preparing metadata (pyproject.toml) ... done
3 l/ n+ k$ o5 U) ^; mBuilding wheels for collected packages: mysqlclient
  Building wheel for mysqlclient (pyproject.toml) ... error
$ J+ u, x% `" q+ m9 ^! l& T% N# `  error: subprocess-exited-with-error

  × Building wheel for mysqlclient (pyproject.toml) did not run successfully.
  │ exit code: 1
  ╰─> [63 lines of output]
      # Options for building extension module:
        extra_compile_args: ['-I/usr/include/mysql', '-std=c99']
        extra_link_args: ['-L/usr/lib/x86_64-linux-gnu']
        define_macros: [('version_info', (2, 2, 4, 'final', 0)), ('__version__', '2.2.4')]
      running bdist_wheel
      running build
$ H! V; h0 p2 Z- }0 {      running build_py
      creating build
      creating build/lib.linux-x86_64-cpython-312
      creating build/lib.linux-x86_64-cpython-312/MySQLdb
      copying src/MySQLdb/__init__.py -> build/lib.linux-x86_64-cpython-312/MySQLdb
9 ~) v+ m# X. F2 k& L5 i6 v+ F      copying src/MySQLdb/_exceptions.py -> build/lib.linux-x86_64-cpython-312/MySQLdb
. _8 L4 _% O3 l      copying src/MySQLdb/connections.py -> build/lib.linux-x86_64-cpython-312/MySQLdb
: V! b6 V7 d1 `9 A; ^- T5 T# m: ~      copying src/MySQLdb/converters.py -> build/lib.linux-x86_64-cpython-312/MySQLdb
      copying src/MySQLdb/cursors.py -> build/lib.linux-x86_64-cpython-312/MySQLdb
  Q( Q# y3 ^9 ^: `+ |. [- V      copying src/MySQLdb/release.py -> build/lib.linux-x86_64-cpython-312/MySQLdb
      copying src/MySQLdb/times.py -> build/lib.linux-x86_64-cpython-312/MySQLdb
      creating build/lib.linux-x86_64-cpython-312/MySQLdb/constants
- h4 R# V. K2 h: V      copying src/MySQLdb/constants/CLIENT.py -> build/lib.linux-x86_64-cpython-312/MySQLdb/constants
" v, l) R: ]( \! i9 j      copying src/MySQLdb/constants/CR.py -> build/lib.linux-x86_64-cpython-312/MySQLdb/constants
  y  N$ [2 k/ U; l7 n0 {6 C8 \      copying src/MySQLdb/constants/ER.py -> build/lib.linux-x86_64-cpython-312/MySQLdb/constants
      copying src/MySQLdb/constants/FIELD_TYPE.py -> build/lib.linux-x86_64-cpython-312/MySQLdb/constants
- ?8 a. Y  |& i7 L' Y1 j- j- I  v      copying src/MySQLdb/constants/FLAG.py -> build/lib.linux-x86_64-cpython-312/MySQLdb/constants
      copying src/MySQLdb/constants/__init__.py -> build/lib.linux-x86_64-cpython-312/MySQLdb/constants
      running egg_info
3 b& N$ r: j; ?( e! L4 u      writing src/mysqlclient.egg-info/PKG-INFO
, w% r# k& p) Y+ [- P6 U# I3 L' A6 I      writing dependency_links to src/mysqlclient.egg-info/dependency_links.txt
7 ^! t8 z+ t/ Q$ Q; }; p: ?      writing top-level names to src/mysqlclient.egg-info/top_level.txt
: Z8 ^7 {1 O  n1 n9 Z% p/ f7 Y      reading manifest file 'src/mysqlclient.egg-info/SOURCES.txt'
4 q5 W% E1 i! Y$ Z' L+ _% D      reading manifest template 'MANIFEST.in'
/ }+ f. ]/ v, ~2 f/ C4 ]      adding license file 'LICENSE'
      writing manifest file 'src/mysqlclient.egg-info/SOURCES.txt'
; l% }8 u" w7 h      copying src/MySQLdb/_mysql.c -> build/lib.linux-x86_64-cpython-312/MySQLdb
6 l& I* j: M- X3 c, Y! O6 e" n      running build_ext
/ q! y! d5 K& z4 W! c+ S      building 'MySQLdb._mysql' extension
, T- T4 j- h2 V. l6 z      creating build/temp.linux-x86_64-cpython-312
( a0 D4 p8 |8 e5 m& d7 ~      creating build/temp.linux-x86_64-cpython-312/src
      creating build/temp.linux-x86_64-cpython-312/src/MySQLdb
' `( i0 _6 ^3 g% n- J      gcc -std=gnu11 -pthread -fno-strict-overflow -Wsign-compare -DNDEBUG -g -O3 -Wall -fPIC "-Dversion_info=(2, 2, 4, 'final', 0)" -D__version__=2.2.4 -I/usr/local/python312/include/python3.12 -c src/MySQLdb/_mysql.c -o build/temp.linux-x86_64-cpython-312/src/MySQLdb/_mysql.o -I/usr/include/mysql -std=c99
      src/MySQLdb/_mysql.c: 在函数‘_mysql_ConnectionObject_Initialize’中:
      src/MySQLdb/_mysql.c:539:44: 错误：‘MYSQL_OPT_SSL_KEY’未声明(在此函数内第一次使用)
" I3 {9 O$ B' C" c" C; t               mysql_options(&(self->connection), MYSQL_OPT_SSL_KEY, key);
                                                  ^
1 J( U* r# R8 O8 z      src/MySQLdb/_mysql.c:539:44: 附注：每个未声明的标识符在其出现的函数内只报告一次
      src/MySQLdb/_mysql.c:540:44: 错误：‘MYSQL_OPT_SSL_CERT’未声明(在此函数内第一次使用)
( o( [3 F% f- c& i* @+ y( W3 i# f               mysql_options(&(self->connection), MYSQL_OPT_SSL_CERT, cert);
2 U: H* i$ E* B1 M% L$ H5 Q                                                  ^
      src/MySQLdb/_mysql.c:541:44: 错误：‘MYSQL_OPT_SSL_CA’未声明(在此函数内第一次使用)
               mysql_options(&(self->connection), MYSQL_OPT_SSL_CA, ca);
4 ^% H2 s# L0 H; p                                                  ^
      src/MySQLdb/_mysql.c:542:44: 错误：‘MYSQL_OPT_SSL_CAPATH’未声明(在此函数内第一次使用)
4 N, S: Y" F! y) j7 }* F               mysql_options(&(self->connection), MYSQL_OPT_SSL_CAPATH, capath);
7 [/ w/ y# k: v$ I; k/ t( l                                                  ^
      src/MySQLdb/_mysql.c:543:44: 错误：‘MYSQL_OPT_SSL_CIPHER’未声明(在此函数内第一次使用)
               mysql_options(&(self->connection), MYSQL_OPT_SSL_CIPHER, cipher);
9 K- j& V/ `) b" N3 G! F                                                  ^
' M' _7 F% O$ t& w( H: P3 }      src/MySQLdb/_mysql.c:556:13: 警告：隐式声明函数‘mysql_optionsv’ [-Wimplicit-function-declaration]
- m) \; E; |( ^4 _0 g                   mysql_optionsv(&(self->connection), MYSQL_OPT_SSL_ENFORCE, (void *)&enforce_tls);
4 X+ R9 x* O  z  l+ H$ ~                   ^
      src/MySQLdb/_mysql.c:556:49: 错误：‘MYSQL_OPT_SSL_ENFORCE’未声明(在此函数内第一次使用)
                   mysql_optionsv(&(self->connection), MYSQL_OPT_SSL_ENFORCE, (void *)&enforce_tls);
                                                       ^
      error: command '/usr/bin/gcc' failed with exit code 1
      [end of output]

  note: This error originates from a subprocess, and is likely not a problem with pip.
* y1 M6 X2 D6 {( J- g  ERROR: Failed building wheel for mysqlclient
5 i) ^: f7 A6 m- u' s" y' eFailed to build mysqlclient
& F6 F, B( ]' f; O* _2 zERROR: ERROR: Failed to build installable wheels for some pyproject.toml based projects (mysqlclient)
# x  V0 f' e9 ?
+ V  }9 }$ y. P$ g; Z7 G/ W


解决方法：
9 y7 H1 n- C% R- z
降低mysqlclient 版本，替换mysqlclient-2.0.2 为1：

apache-airflow-providers-mysql==5.4.0
mysqlclient==2.1.0

admin

[root@python-flask ~]# pip install mysqlclient
Collecting mysqlclient
0 m& z" w& k% V6 f  Using cached mysqlclient-2.2.4.tar.gz (90 kB)
  Installing build dependencies ... done
  Getting requirements to build wheel ... error
9 t" a# @4 @' m. j, A1 Q  error: subprocess-exited-with-error
- o5 N7 u$ l! k6 \9 h, g: g  
1 i% M% q1 |& Y  × Getting requirements to build wheel did not run successfully.
  │ exit code: 1
$ v4 W7 R) x% c& P* Z! k  ╰─> [27 lines of output]
      Trying pkg-config --exists mysqlclient
      Command 'pkg-config --exists mysqlclient' returned non-zero exit status 1.
      Trying pkg-config --exists mariadb
      Command 'pkg-config --exists mariadb' returned non-zero exit status 1.
      Trying pkg-config --exists libmariadb
8 J9 h8 u, `7 b  G0 Y      Command 'pkg-config --exists libmariadb' returned non-zero exit status 1.
      Traceback (most recent call last):
        File "/usr/local/python312/lib/python3.12/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 353, in <module>
. D* ]4 F) A" e9 N4 g          main()
        File "/usr/local/python312/lib/python3.12/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 335, in main
2 s& [( [5 s& w+ K          json_out['return_val'] = hook(**hook_input['kwargs'])
5 J6 C+ o5 n5 P                                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
        File "/usr/local/python312/lib/python3.12/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 118, in get_requires_for_build_wheel
          return hook(config_settings)
                 ^^^^^^^^^^^^^^^^^^^^^
        File "/tmp/pip-build-env-w2b8dsud/overlay/lib/python3.12/site-packages/setuptools/build_meta.py", line 327, in get_requires_for_build_wheel
          return self._get_build_requires(config_settings, requirements=[])
7 `$ D9 |" b& r  G: }) ]$ `                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
: b; F! p8 v1 r( P9 a/ S1 O7 s        File "/tmp/pip-build-env-w2b8dsud/overlay/lib/python3.12/site-packages/setuptools/build_meta.py", line 297, in _get_build_requires
          self.run_setup()
        File "/tmp/pip-build-env-w2b8dsud/overlay/lib/python3.12/site-packages/setuptools/build_meta.py", line 313, in run_setup
: ^; L3 S6 [: O' h+ K          exec(code, locals())
        File "<string>", line 155, in <module>
, [  i1 w3 Y) g        File "<string>", line 49, in get_config_posix
        File "<string>", line 28, in find_package_name
      Exception: Can not find valid pkg-config name.
+ z& e) S- M4 `! [: @6 o# G' O. b1 Y      Specify MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS env vars manually
      [end of output]
3 W/ w- I4 U+ W3 Z2 N  
  note: This error originates from a subprocess, and is likely not a problem with pip.
( X' s& E) T. d) ]error: subprocess-exited-with-error
2 M$ v9 O. X5 s) e& y, ]
/ |8 L7 B& z7 ~× Getting requirements to build wheel did not run successfully.
! z  q- U, q! q  I& s6 k│ exit code: 1
, j, h, C! T! |: ?! z; _╰─> See above for output.

$ w# x% h! v. ]: x" D  _2 {4 B3 Mnote: This error originates from a subprocess, and is likely not a problem with pip.
8 D- T+ G- z4 \9 D; e- C* ?[root@python-flask ~]# pip install mysqlclient==2.1.0
Collecting mysqlclient==2.1.0
  Downloading mysqlclient-2.1.0.tar.gz (87 kB)
: s% R* p  U; B5 r     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 87.6/87.6 kB 635.5 kB/s eta 0:00:00
: x  o* }) K, ~) n) o1 l# |  G) ^/ \  Installing build dependencies ... done
* [- v# N# c( ^' `1 F' S4 |  Getting requirements to build wheel ... done
; w4 f1 J% L% ?# B6 ^* D. \  Preparing metadata (pyproject.toml) ... done
+ R  I6 S$ I; W- l1 nBuilding wheels for collected packages: mysqlclient
  Building wheel for mysqlclient (pyproject.toml) ... done
7 `: ?- L$ A! w( x0 M  Created wheel for mysqlclient: filename=mysqlclient-2.1.0-cp312-cp312-linux_x86_64.whl size=102434 sha256=9195914c669fe1b57f256214d711095c10e05799fdf3b2033541f88830a69b6d
  Stored in directory: /root/.cache/pip/wheels/b1/b6/8d/eb165ad207cde6784a606ec0a5bdd7a5b5c9241bad361d1623
" L  M+ i5 l1 J, }Successfully built mysqlclient
/ h& i( F8 L% m2 ~/ v  t: ]& G9 jInstalling collected packages: mysqlclient
, V7 X0 }  s. y7 g' r: C9 kSuccessfully installed mysqlclient-2.1.0
! |) n2 Q- f& t& i4 [) V+ x" KWARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager, possibly rendering your system unusable.It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv. Use the --root-user-action option if you know what you are doing and want to suppress this warning.

admin

安装失败还有一个原因可能是因为环境不干净导致。