pip install mysqlclient错误提示

admin

pip install mysqlclient
Collecting mysqlclient
+ V: Q7 f6 ^* ]4 P( ]/ Q+ X6 g7 u  Using cached mysqlclient-2.2.4.tar.gz (90 kB)
& D: n  g- M8 K  Installing build dependencies ... done
  Getting requirements to build wheel ... done
: b2 B2 q! k+ W  Preparing metadata (pyproject.toml) ... done
Building wheels for collected packages: mysqlclient
  Building wheel for mysqlclient (pyproject.toml) ... error
  error: subprocess-exited-with-error

  × Building wheel for mysqlclient (pyproject.toml) did not run successfully.
  │ exit code: 1
. o, O& L9 |, @  ╰─> [63 lines of output]
* d8 `/ C; T4 f$ n1 Q2 g      # Options for building extension module:
        extra_compile_args: ['-I/usr/include/mysql', '-std=c99']
/ s9 X! M3 ]: f$ P1 [, r( P        extra_link_args: ['-L/usr/lib/x86_64-linux-gnu']
; g; U6 V6 ^8 n7 X* N        define_macros: [('version_info', (2, 2, 4, 'final', 0)), ('__version__', '2.2.4')]
      running bdist_wheel
8 ~- {6 K' Y# a/ g- B0 E5 }      running build
      running build_py
3 b2 _" r  }/ h  c      creating build
      creating build/lib.linux-x86_64-cpython-312
4 [5 I- P( }4 K! Z; L3 B      creating build/lib.linux-x86_64-cpython-312/MySQLdb
      copying src/MySQLdb/__init__.py -> build/lib.linux-x86_64-cpython-312/MySQLdb
      copying src/MySQLdb/_exceptions.py -> build/lib.linux-x86_64-cpython-312/MySQLdb
      copying src/MySQLdb/connections.py -> build/lib.linux-x86_64-cpython-312/MySQLdb
      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
+ o* I" V1 p' m. L, _! C      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
" }4 c4 O- {3 P! {7 a      creating build/lib.linux-x86_64-cpython-312/MySQLdb/constants
1 T3 T. F$ p3 P7 U      copying src/MySQLdb/constants/CLIENT.py -> build/lib.linux-x86_64-cpython-312/MySQLdb/constants
. H% e2 _$ d+ @  i' G      copying src/MySQLdb/constants/CR.py -> build/lib.linux-x86_64-cpython-312/MySQLdb/constants
9 F; ?5 z% n" H' Y- H      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
      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
- l; d* c8 M8 k4 M4 m8 ]0 _6 W      running egg_info
+ d$ Y  ?( K# x  ~      writing src/mysqlclient.egg-info/PKG-INFO
8 k4 C4 z0 y0 L7 n0 J2 Z. k      writing dependency_links to src/mysqlclient.egg-info/dependency_links.txt
      writing top-level names to src/mysqlclient.egg-info/top_level.txt
. a" A& \" U/ w( [) I% f+ X# y9 |/ C      reading manifest file 'src/mysqlclient.egg-info/SOURCES.txt'
      reading manifest template 'MANIFEST.in'
      adding license file 'LICENSE'
" r! g( p* P1 {; u0 I      writing manifest file 'src/mysqlclient.egg-info/SOURCES.txt'
" l" ?6 i0 d- w) H# V$ e      copying src/MySQLdb/_mysql.c -> build/lib.linux-x86_64-cpython-312/MySQLdb
9 d' ^% g4 I; w; }$ a+ @      running build_ext
      building 'MySQLdb._mysql' extension
  O6 S* ^8 P( c6 `' u& @5 C      creating build/temp.linux-x86_64-cpython-312
* H- j! O  L* K. M6 u. `      creating build/temp.linux-x86_64-cpython-312/src
4 L: b8 C0 |( b0 }8 k      creating build/temp.linux-x86_64-cpython-312/src/MySQLdb
      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’未声明(在此函数内第一次使用)
+ f" z( x# I" X* B( A8 a5 X5 a1 G               mysql_options(&(self->connection), MYSQL_OPT_SSL_KEY, key);
                                                  ^
+ e% L; p: \: f, ]+ t) G      src/MySQLdb/_mysql.c:539:44: 附注：每个未声明的标识符在其出现的函数内只报告一次
% [/ T/ m0 W) p& A5 o8 p; X      src/MySQLdb/_mysql.c:540:44: 错误：‘MYSQL_OPT_SSL_CERT’未声明(在此函数内第一次使用)
               mysql_options(&(self->connection), MYSQL_OPT_SSL_CERT, cert);
                                                  ^
$ W! v7 K8 Y5 o      src/MySQLdb/_mysql.c:541:44: 错误：‘MYSQL_OPT_SSL_CA’未声明(在此函数内第一次使用)
               mysql_options(&(self->connection), MYSQL_OPT_SSL_CA, ca);
                                                  ^
      src/MySQLdb/_mysql.c:542:44: 错误：‘MYSQL_OPT_SSL_CAPATH’未声明(在此函数内第一次使用)
. N# P% m/ t# x* F/ L  u               mysql_options(&(self->connection), MYSQL_OPT_SSL_CAPATH, capath);
0 ~! O. v9 ~. ^2 Y; W. u                                                  ^
' \/ W4 K! ?3 K, l      src/MySQLdb/_mysql.c:543:44: 错误：‘MYSQL_OPT_SSL_CIPHER’未声明(在此函数内第一次使用)
               mysql_options(&(self->connection), MYSQL_OPT_SSL_CIPHER, cipher);
                                                  ^
( _7 n/ i9 y) K8 k$ X1 d* Q      src/MySQLdb/_mysql.c:556:13: 警告：隐式声明函数‘mysql_optionsv’ [-Wimplicit-function-declaration]
                   mysql_optionsv(&(self->connection), MYSQL_OPT_SSL_ENFORCE, (void *)&enforce_tls);
' q. N0 ^# H6 y3 I" x* O3 U                   ^
9 Y) K1 q% O' W! X( S; {. H1 W      src/MySQLdb/_mysql.c:556:49: 错误：‘MYSQL_OPT_SSL_ENFORCE’未声明(在此函数内第一次使用)
                   mysql_optionsv(&(self->connection), MYSQL_OPT_SSL_ENFORCE, (void *)&enforce_tls);
                                                       ^
) U, k2 o6 G3 m( M- }& D      error: command '/usr/bin/gcc' failed with exit code 1
2 Q) _* G/ n2 c0 ~- r      [end of output]

  note: This error originates from a subprocess, and is likely not a problem with pip.
" d  K' w6 y; K$ `* W  ERROR: Failed building wheel for mysqlclient
Failed to build mysqlclient
ERROR: ERROR: Failed to build installable wheels for some pyproject.toml based projects (mysqlclient)


1 e$ G( D3 C, X2 @, _) h
; d% `. `( s* h% \. |3 `5 k* W
8 F- ^# v* G) S" E5 Y; E解决方法：
9 \2 }3 L  R5 y6 O8 D' t
, s* I5 ]* R* _& E6 \, x$ Z降低mysqlclient 版本，替换mysqlclient-2.0.2 为1：

apache-airflow-providers-mysql==5.4.0
3 _, k/ e4 u4 A- u  l! W2 Gmysqlclient==2.1.0
+ h# _* V/ d* N  @

2 S8 @, y& y: z
' W, ?- e0 G6 X* b3 ~$ J9 {# E

admin

[root@python-flask ~]# pip install mysqlclient
6 Z( |  P9 j1 x  }Collecting mysqlclient
  Using cached mysqlclient-2.2.4.tar.gz (90 kB)
  Installing build dependencies ... done
8 C4 u0 O1 Z, _+ D& R% N; s  Getting requirements to build wheel ... error
) Q* \* [* l) x5 u& I+ S  error: subprocess-exited-with-error
  
  × Getting requirements to build wheel did not run successfully.
  │ exit code: 1
# N* j1 [2 W5 J: C' ?: P  ╰─> [27 lines of output]
1 [' S5 s4 @8 G      Trying pkg-config --exists mysqlclient
      Command 'pkg-config --exists mysqlclient' returned non-zero exit status 1.
7 h: _# A3 n0 B! W/ O      Trying pkg-config --exists mariadb
      Command 'pkg-config --exists mariadb' returned non-zero exit status 1.
# X3 x6 ]( r* v, m  {      Trying pkg-config --exists libmariadb
5 K8 R' R6 Y) J% ]3 _0 b, _7 X      Command 'pkg-config --exists libmariadb' returned non-zero exit status 1.
  X2 u: P; y( O# {( I      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>
% U( V  p& }1 V) \1 t% ^# w& c8 O7 K          main()
        File "/usr/local/python312/lib/python3.12/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 335, in main
          json_out['return_val'] = hook(**hook_input['kwargs'])
- o8 b) T6 }, |' ?# T  v                                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
        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
  y  Q/ W1 x) v$ Z+ F7 |0 u9 U          return hook(config_settings)
                 ^^^^^^^^^^^^^^^^^^^^^
5 ?: n6 |8 Y$ \( t" A        File "/tmp/pip-build-env-w2b8dsud/overlay/lib/python3.12/site-packages/setuptools/build_meta.py", line 327, in get_requires_for_build_wheel
6 U' W. P! E4 G& N; ~' }% k5 |0 `          return self._get_build_requires(config_settings, requirements=[])
1 R& }: h1 }0 ^) D1 P                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  s  j# V* U1 J        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
          exec(code, locals())
        File "<string>", line 155, in <module>
        File "<string>", line 49, in get_config_posix
7 H3 ~3 c" {, Q        File "<string>", line 28, in find_package_name
      Exception: Can not find valid pkg-config name.
* _$ ]( W2 ^' s, p3 q+ b      Specify MYSQLCLIENT_CFLAGS and MYSQLCLIENT_LDFLAGS env vars manually
      [end of output]
  
  note: This error originates from a subprocess, and is likely not a problem with pip.
error: subprocess-exited-with-error
- v0 E- B" i7 P1 t
. K2 G4 b* u! ?9 b' q1 D× Getting requirements to build wheel did not run successfully.
# O2 T- A. n. L: r$ q│ exit code: 1
$ T0 D; e  u0 v/ S' |$ N╰─> See above for output.
1 u' k) J1 S, `6 u3 H! Y- d
note: This error originates from a subprocess, and is likely not a problem with pip.
, `8 G2 G5 O, Q7 M8 Z% d[root@python-flask ~]# pip install mysqlclient==2.1.0
# j- x# D# I$ W$ xCollecting mysqlclient==2.1.0
3 O# R( L8 D( N4 q* i4 T; J  Downloading mysqlclient-2.1.0.tar.gz (87 kB)
9 z' {6 w$ L4 G- a- g* u. m     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 87.6/87.6 kB 635.5 kB/s eta 0:00:00
  Installing build dependencies ... done
3 p4 v5 Z, N: g0 K9 ^/ t) C2 l  Getting requirements to build wheel ... done
  Preparing metadata (pyproject.toml) ... done
" T+ \! P  L% IBuilding wheels for collected packages: mysqlclient
  Building wheel for mysqlclient (pyproject.toml) ... done
  Created wheel for mysqlclient: filename=mysqlclient-2.1.0-cp312-cp312-linux_x86_64.whl size=102434 sha256=9195914c669fe1b57f256214d711095c10e05799fdf3b2033541f88830a69b6d
$ |0 _1 u! _8 r( g. t9 V- z  Stored in directory: /root/.cache/pip/wheels/b1/b6/8d/eb165ad207cde6784a606ec0a5bdd7a5b5c9241bad361d1623
Successfully built mysqlclient
, v8 d0 s3 ~0 C4 {" `Installing collected packages: mysqlclient
" _& b& C% j+ s. O2 ]7 zSuccessfully installed mysqlclient-2.1.0
$ t/ w, @* r/ lWARNING: 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

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