Mysql 8.0.33 causes issues when building mysqlclient Python package

[ChiragPatelAccu]

Describe the bug

Using cached mysqlclient-2.2.0.tar.gz (89 kB)
Installing build dependencies ... done
Getting requirements to build wheel ... done
Installing backend dependencies ... done
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
╰─> [46 lines of output]
# Options for building extention module:
extra_compile_args: ['-I/usr/include/mysql', '-m64', '-std=c99']
extra_link_args: ['-L/usr/lib64/mysql', '-lmysqlclient']
define_macros: [('version_info', (2, 2, 0, 'final', 0)), ('version', '2.2.0')]
running bdist_wheel
running build
running build_py
creating build
creating build/lib.linux-x86_64-cpython-38
creating build/lib.linux-x86_64-cpython-38/MySQLdb
copying src/MySQLdb/connections.py -> build/lib.linux-x86_64-cpython-38/MySQLdb
copying src/MySQLdb/times.py -> build/lib.linux-x86_64-cpython-38/MySQLdb
copying src/MySQLdb/converters.py -> build/lib.linux-x86_64-cpython-38/MySQLdb
copying src/MySQLdb/release.py -> build/lib.linux-x86_64-cpython-38/MySQLdb
copying src/MySQLdb/cursors.py -> build/lib.linux-x86_64-cpython-38/MySQLdb
copying src/MySQLdb/_exceptions.py -> build/lib.linux-x86_64-cpython-38/MySQLdb
copying src/MySQLdb/init.py -> build/lib.linux-x86_64-cpython-38/MySQLdb
creating build/lib.linux-x86_64-cpython-38/MySQLdb/constants
copying src/MySQLdb/constants/CLIENT.py -> build/lib.linux-x86_64-cpython-38/MySQLdb/constants
copying src/MySQLdb/constants/ER.py -> build/lib.linux-x86_64-cpython-38/MySQLdb/constants
copying src/MySQLdb/constants/FIELD_TYPE.py -> build/lib.linux-x86_64-cpython-38/MySQLdb/constants
copying src/MySQLdb/constants/FLAG.py -> build/lib.linux-x86_64-cpython-38/MySQLdb/constants
copying src/MySQLdb/constants/CR.py -> build/lib.linux-x86_64-cpython-38/MySQLdb/constants
copying src/MySQLdb/constants/init.py -> build/lib.linux-x86_64-cpython-38/MySQLdb/constants
running egg_info
writing src/mysqlclient.egg-info/PKG-INFO
writing dependency_links to src/mysqlclient.egg-info/dependency_links.txt
writing top-level names to src/mysqlclient.egg-info/top_level.txt
reading manifest file 'src/mysqlclient.egg-info/SOURCES.txt'
reading manifest template 'MANIFEST.in'
adding license file 'LICENSE'
writing manifest file 'src/mysqlclient.egg-info/SOURCES.txt'
copying src/MySQLdb/mysql.c -> build/lib.linux-x86_64-cpython-38/MySQLdb
running build_ext
building 'MySQLdb.mysql' extension
creating build/temp.linux-x86_64-cpython-38
creating build/temp.linux-x86_64-cpython-38/src
creating build/temp.linux-x86_64-cpython-38/src/MySQLdb
gcc -Wno-unused-result -Wsign-compare -DDYNAMIC_ANNOTATIONS_ENABLED=1 -DNDEBUG -D_GNU_SOURCE -fPIC -fwrapv -O2 -pthread -Wno-unused-result-Wsign-compare -g -std=c99 -Wextra -Wno-unused-parameter -Wno-missing-field-initializers -Werror=implicit-function-declaration -D_GNU_SOURCE -fPIC -fwrapv -D_GNU_SOURCE -fPIC -fwrapv -O2 -pthread -Wno-unused-result -Wsign-compare -g -std=c99 -Wextra -Wno-unused-parameter -Wno-missing-field-initializers -Werror=implicit-function-declaration -D_GNU_SOURCE -fPIC -fwrapv -O2 -pthread -Wno-unused-result -Wsign-compare -g -std=c99 -Wextra -Wno-unused-parameter -Wno-missing-field-initializers -Werror=implicit-function-declaration -I/opt/openssl/include -I/include -fPIC "-Dversion_info=(2, 2, 0, 'final', 0)" -D__version=2.2.0 -I/home/devtemporisystem/virtualenv/public_html/dev_tempori_system/3.8/include -I/opt/alt/python38/include/python3.8 -c src/MySQLdb/_mysql.c -o build/temp.linux-x86_64-cpython-38/src/MySQLdb/_mysql.o -I/usr/include/mysql -m64 -std=c99
src/MySQLdb/_mysql.c:46:10: fatal error: Python.h: No such file or directory
#include "Python.h"
^~~~~~~~~~
compilation terminated.
/tmp/pip-build-env-vjv6ahd5/overlay/lib/python3.8/site-packages/setuptools/config/pyprojecttoml.py:66: _BetaConfiguration: Support for [tool.setuptools] in pyproject.toml is still beta.
config = read_configuration(filepath, True, ignore_option_errors, dist)
error: command '/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.
ERROR: Failed building wheel for mysqlclient
Failed to build mysqlclient
ERROR: Could not build wheels for mysqlclient, which is required to install pyproject.toml-based projects

Environment

No response

How did you install libmysqlclient libraries?

No response

What version of mysqlclient do you use?

No response

Docker command to start MySQL server

No response

Minimum but complete code to reproduce

# Write Python code here.
import MySQLdb

conn = MySQLdb.connect(host='127.0.0.1', port=3306, user='root')
...

Schema and initial data required to reproduce.

-- Write SQL here.
-- e.g. CREATE TABLE ...

Commands, and any other step required to reproduce your issue.

No response

[methane]

src/MySQLdb/_mysql.c:46:10: fatal error: Python.h: No such file or directory

You need to install python-dev (Debian, Ubuntu) or python-devel (CentOS) package.
(The python part may have version suffix like python3-devel or python311-devel. You need to check it by yourself.)