Connecting python to mysql error

Guys, can anyone helpme.
to connet python and mysql on anaconda command prompt
conda install -c anaconda mysql-connector-python

Collecting package metadata (current_repodata.json): done
Solving environment: failed with initial frozen solve. Retrying with flexible solve.
Solving environment: failed with repodata from current_repodata.json, will retry with next repodata source.
Collecting package metadata (repodata.json): done
Solving environment: failed with initial frozen solve. Retrying with flexible solve.
Solving environment:
Found conflicts! Looking for incompatible packages.
This can take several minutes. Press CTRL-C to abort.
failed

UnsatisfiableError: The following specifications were found
to be incompatible with the existing python installation in your environment:

Specifications:

  • mysql-connector-python → python[version=’>=3.5,<3.6.0a0|>=3.6,<3.7.0a0|>=3.7,<3.8.0a0’]

Your python: python=3.9

If python is on the left-most side of the chain, that’s the version you’ve asked for.
When python appears to the right, that indicates that the thing on the left is somehow
not available for the python version you are constrained to. Note that conda will not
change your python version to a different minor version unless you explicitly specify
that.

1 Like

I’m having the same issue that it seems Anaconda does not have the latest MySQL Python Connector package 8.0.30.

Can we request this package to be available?

1 Like

If you are using python 3.9, you need to install ‘mysql-connector-python’ package from the conda-forge channel to get a later version. This will install ‘mysql-connector-python’ version 8.0.29.

The current version of the package in the anaconda main channel should get updated soon…

1 Like

i’m using python 3.8 and facing the same issue. Is there any other way, shall i update my python version for this to work?

Another option is to simply use the ODBC driver you can download from the MySQL website here:
https://dev.mysql.com/downloads/connector/odbc/

and use the pyodbc package to connect.