Authentication plugin 'caching_sha2_password' is not supported
phani :
I am trying to connect to a MySQL server with python connector. I created a new user lcherukuri with the authentication plugin mysql_native_password.
But I got the error
mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
Can someone help me?
import mysql.connector
cnx = mysql.connector.connect(user='lcherukuri', password='password',
host='127.0.0.1',
database='test')
cnx.close()
Ben :
Per Caching SHA-2 Pluggable Authentication
In MySQL 8.0,
caching_sha2_passwordis the default authentication plugin rather thanmysql_native_password.
You're using mysql_native_password, which is no longer the default. Assuming you're using the correct connector for your version you need to specify the auth_plugin argument when instantiating your connection object
cnx = mysql.connector.connect(user='lcherukuri', password='password',
host='127.0.0.1', database='test',
auth_plugin='mysql_native_password')
From those same docs:
The
connect()method supports anauth_pluginargument that can be used to force use of a particular plugin. For example, if the server is configured to usesha256_passwordby default and you want to connect to an account that authenticates usingmysql_native_password, either connect using SSL or specifyauth_plugin='mysql_native_password'.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: How do I convert an array (i.e. list) column to Vector
- Next: How to rename a virtualenv in Python?
Related
TOP Ranking
- 1
Failed to listen on localhost:8000 (reason: Cannot assign requested address)
- 2
How to import an asset in swift using Bundle.main.path() in a react-native native module
- 3
Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)
- 4
pump.io port in URL
- 5
Spring Boot JPA PostgreSQL Web App - Internal Authentication Error
- 6
BigQuery - concatenate ignoring NULL
- 7
ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3
- 8
Do Idle Snowflake Connections Use Cloud Services Credits?
- 9
maven-jaxb2-plugin cannot generate classes due to two declarations cause a collision in ObjectFactory class
- 10
Compiler error CS0246 (type or namespace not found) on using Ninject in ASP.NET vNext
- 11
Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background
- 12
Generate random UUIDv4 with Elm
- 13
Jquery different data trapped from direct mousedown event and simulation via $(this).trigger('mousedown');
- 14
Is it possible to Redo commits removed by GitHub Desktop's Undo on a Mac?
- 15
flutter: dropdown item programmatically unselect problem
- 16
Change dd-mm-yyyy date format of dataframe date column to yyyy-mm-dd
- 17
EXCEL: Find sum of values in one column with criteria from other column
- 18
Pandas - check if dataframe has negative value in any column
- 19
How to use merge windows unallocated space into Ubuntu using GParted?
- 20
Make a B+ Tree concurrent thread safe
- 21
ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements
Comments