[Solved] mysql.connector.errors.NotSupportedError: Authentication plugin ‘caching_sha2_password’ is not supported

Hello Guys, How are you all? Hope You all Are Fine. Today in Java. So Here I am Explain to you all the possible solutions here.

Without wasting your time, Let’s start This Article to Solve This Error.

How mysql.connector.errors.NotSupportedError: Authentication plugin ‘caching_sha2_password’ is not supported Error Occurs ?

I am just trying to connect MySQL server with python connector using mysql connector. But I am facing following error.

mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

How To Solve mysql.connector.errors.NotSupportedError: Authentication plugin ‘caching_sha2_password’ is not supported Error ?

Solution 1: install mysql-connector-python

Just uninstall mysql-connector with this command pip uninstall mysql-connector and install mysql-connector-python. Use this command to install mysql-connector-python.

pip install mysql-connector-python

Now your error must be gone.

Solution 2: specify the auth_plugin

You Just need to specify the auth_plugin argument when instantiating your connection object. Just like below code.

cnx = mysql.connector.connect(user='root', password='',
                              host='127.0.0.1', database='airpaw',
                              auth_plugin='mysql_native_password')

Summary

It’s all About this issue. Hope all solution helped you a lot. Comment below Your thoughts and your queries. Also, Comment below which solution worked for you?

Also, Read

• selenium.common.exceptions.WebDriverException: Message: unknown error: Chrome failed to start: crashed