[Fixed] mysql.connector.errors.Not SupportedError: Authentication plugin ‘caching_sha2_password’ is not supported

Issue

caching_sha2_password is the default plugin used for authentication in latest versions of MySQL. When you try to use Incorrect MySQL Connector with Python, you may see this not supported error

Solution

pip uninstall mysql-connector

pip install mysql-connector-python