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

You have probably installed mysql-connector instead of mysql-connector-python. So you need to install it again for python3:

pip3 install mysql-connector-python

3.67
3
Awgiedawgie 440220 points

                                    #To resolve this error just add auth_plugin 
import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="username",
  password="password",
  database="db name",
  auth_plugin='mysql_native_password'
)

3.67 (3 Votes)
0
Are there any code examples left?
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
get_auth_plugin raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported python mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported just do not go away mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported docker (mysql.connector.errors.NotSupportedError) Authentication plugin 'caching_sha2_password' is not supported (mysql.connector.errors.NotSupportedError) Authentication plugin 'caching_sha2_password' is not supported\n(Background on this error at: http://sqlalche.me/e/13/tw8g) mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported%0A mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported mysql.connector.errors.NotSupportedError: Authentication plugin Authentication plugin 'caching_sha2_pa ssword' is not supported mysql Authentication plugin 'caching_sha2_password' is not supported necting to MySQL Authentication plugin 'caching_sha2_password' is not supported Authentication plugin 'caching_sha2_password' is not supported python authentication plugin 'caching_sha2_password' is not supported sqlalchemy raise errors.NotSupportedError(mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported ERROR: Authentication plugin 'caching_sha2_password' is not supported mysqldbimport python caching_sha2_password "Authentication plugin '{0}' is not supported".format(plugin_name)) mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported mysql Authentication plugin not supported: caching_sha2_password Authentication plugin 'caching_sha2_password' is not supporte python Authentication plugin 'caching_sha2_password' is not supported python mysql caching_sha2_password python mysql Authentication plugin 'caching_sha2_password' is not supported python mysql client caching_sha2_password error Authentication plugin 'caching_sha2_password' is not supported [-] raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported Process finished with exit code 1 mysql connector errors interfaceerror caching_sha2_password requires ssl on mysql connector python mysql connector errors interfaceerror caching_sha2_password requires ssl in mysqlconnector python mysql connector errors interfaceerror caching_sha2_password requires ssl mysql.connector.errors.InterfaceError: caching_sha2_password requires SSL mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported\ mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported python 3.8 Error while connecting to MySQL Authentication plugin 'caching_sha2_password' is not supported caching_sha2_password example mysql.connector.errors.notsupportederror authentication plugin 'caching_sha2_password' mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported discord py NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported Error while connecting to MySQL Authentication plugin 'caching_sha2_password' is not supported sqlalchemy authentication plugin 'caching_sha2_password' is not supported how to resolve mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported Authentication plugin 'caching_sha2_password' is not supported mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source