dbt not support mysql

infinite loop

root@10:/data/local/all_everyone# pip install mysql-connector-python==8.2.0
/usr/bin/pip:6: DeprecationWarning: pkg_resources is deprecated as an API. See Package Discovery and Resource Access using pkg_resources - setuptools 69.2.0.post20240313 documentation
from pkg_resources import load_entry_point
Collecting mysql-connector-python==8.2.0
Downloading mysql_connector_python-8.2.0-py2.py3-none-any.whl (593 kB)
|████████████████████████████████| 593 kB 21 kB/s
Collecting protobuf<=4.21.12,>=4.21.1
Downloading protobuf-4.21.12-cp37-abi3-manylinux2014_x86_64.whl (409 kB)
|████████████████████████████████| 409 kB 27 kB/s
ERROR: dbt-mysql 1.7.0a1 has requirement mysql-connector-python<8.1,>=8.0.0, but you’ll have mysql-connector-python 8.2.0 which is incompatible.
Installing collected packages: protobuf, mysql-connector-python
Attempting uninstall: protobuf
Found existing installation: protobuf 4.25.3
Uninstalling protobuf-4.25.3:
Successfully uninstalled protobuf-4.25.3
Attempting uninstall: mysql-connector-python
Found existing installation: mysql-connector-python 8.0.33
Uninstalling mysql-connector-python-8.0.33:
Successfully uninstalled mysql-connector-python-8.0.33
Successfully installed mysql-connector-python-8.2.0 protobuf-4.21.12
root@10:/data/local/all_everyone# pip install mysql-connector-python==8.1.0
/usr/bin/pip:6: DeprecationWarning: pkg_resources is deprecated as an API. See Package Discovery and Resource Access using pkg_resources - setuptools 69.2.0.post20240313 documentation
from pkg_resources import load_entry_point
Collecting mysql-connector-python==8.1.0
Downloading mysql_connector_python-8.1.0-py2.py3-none-any.whl (581 kB)
|████████████████████████████████| 581 kB 23 kB/s
Requirement already satisfied: protobuf<=4.21.12,>=4.21.1 in /usr/local/lib/python3.8/dist-packages (from mysql-connector-python==8.1.0) (4.21.12)
ERROR: dbt-mysql 1.7.0a1 has requirement mysql-connector-python<8.1,>=8.0.0, but you’ll have mysql-connector-python 8.1.0 which is incompatible.
Installing collected packages: mysql-connector-python
Attempting uninstall: mysql-connector-python
Found existing installation: mysql-connector-python 8.2.0
Uninstalling mysql-connector-python-8.2.0:
Successfully uninstalled mysql-connector-python-8.2.0
Successfully installed mysql-connector-python-8.1.0
root@10:/data/local/all_everyone# pip install mysql-connector-python==8.0.23
/usr/bin/pip:6: DeprecationWarning: pkg_resources is deprecated as an API. See Package Discovery and Resource Access using pkg_resources - setuptools 69.2.0.post20240313 documentation
from pkg_resources import load_entry_point
Collecting mysql-connector-python==8.0.23
Downloading mysql_connector_python-8.0.23-cp38-cp38-manylinux1_x86_64.whl (18.0 MB)
|▍ | 235 kB 11 kB/s eta 0:25:40^C
ERROR: Operation cancelled by user
root@10:/data/local/all_everyone# pip install mysql-connector-python==8.0.33
/usr/bin/pip:6: DeprecationWarning: pkg_resources is deprecated as an API. See Package Discovery and Resource Access using pkg_resources - setuptools 69.2.0.post20240313 documentation
from pkg_resources import load_entry_point
Collecting mysql-connector-python==8.0.33
Using cached mysql_connector_python-8.0.33-cp38-cp38-manylinux1_x86_64.whl (27.4 MB)
Collecting protobuf<=3.20.3,>=3.11.0
Using cached protobuf-3.20.3-cp38-cp38-manylinux_2_5_x86_64.manylinux1_x86_64.whl (1.0 MB)
ERROR: dbt-core 1.7.8 has requirement protobuf>=4.0.0, but you’ll have protobuf 3.20.3 which is incompatible.
Installing collected packages: protobuf, mysql-connector-python
Attempting uninstall: protobuf
Found existing installation: protobuf 4.21.12
Uninstalling protobuf-4.21.12:
Successfully uninstalled protobuf-4.21.12
Attempting uninstall: mysql-connector-python
Found existing installation: mysql-connector-python 8.1.0
Uninstalling mysql-connector-python-8.1.0:
Successfully uninstalled mysql-connector-python-8.1.0
Successfully installed mysql-connector-python-8.0.33 protobuf-3.20.3
root@10:/data/local/all_everyone# vi requirements.txt
root@10:/data/local/all_everyone# pip install --upgrade protobuf
/usr/bin/pip:6: DeprecationWarning: pkg_resources is deprecated as an API. See Package Discovery and Resource Access using pkg_resources - setuptools 69.2.0.post20240313 documentation
from pkg_resources import load_entry_point
Collecting protobuf
Using cached protobuf-4.25.3-cp37-abi3-manylinux2014_x86_64.whl (294 kB)
ERROR: mysql-connector-python 8.0.33 has requirement protobuf<=3.20.3,>=3.11.0, but you’ll have protobuf 4.25.3 which is incompatible.
Installing collected packages: protobuf
Attempting uninstall: protobuf
Found existing installation: protobuf 3.20.3
Uninstalling protobuf-3.20.3:
Successfully uninstalled protobuf-3.20.3
Successfully installed protobuf-4.25.3
root@10:/data/local/all_everyone# dbt --version
Core:

  • installed: 1.7.8
  • latest: 1.7.9 - Update available!