caching sha2 password is not supported mysql

Question

i'm trying to get my python program to insert data into MySQL and i followed a guide however i keep getting the error below.

"Authentication plugin '{0}' is not supported".format(plugin_name)) mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported"

have i missed a setting in mysql server or does python not support this yet?

I think i can just change the password type but mysql doesn't want to let me for some reason all users with caching_sha2_password can't be changed and when i create a new user and select SHA256 Password I get the error creating account @% the password hash doesn't have the expected format. check if the correct password algorithm is being used with the PASSWORD() function.

#!/user
# -*- coding: utf-8 -*-

from __future__ import print_function
import urllib.request
import numpy as np
import mysql.connector as mysql

from datetime import date, datetime, timedelta



cnx = mysql.connect(user='root', password='password', database='powergrid')

cursor = cnx.cursor()

tomorrow = datetime.now().date() + timedelta(days=1)

idfueltype= cursor.lastrowid

add_fueltype = ("INSERT INTO fueltype"
                "(idfueltype, fueltypecol, demand)"
               "VALUES(%s, %s, %s)")

fueltype_data = (idfueltype, 'coal', 10000)

cursor.execute(add_fueltype, fueltype_data)

cnx.commit()

cursor.close()
cnx.close()

**solved** : `pip install mysql-connector-python` – hassanzadeh.sd Apr 05 '20 at 07:58 — hassanzadeh.sd, Apr 05 '20 at 07:58

score 28 · Accepted Answer · answered May 09 '18 at 14:25

28

I managed to fix this. In the end I was using a version of python in Anaconda which just wouldn't install version 8.0.11 of the python connector, I managed to get 8.0.11 installed on my vanilla python 3.6.5 using windows PowerShell (in admin privileges) and using pip install MySQL-connector-python (I think I also had to update pip from 9 to 10.

answered May 09 '18 at 14:25

adam Wadsworth

774
1
8
26

Fixed it for me. I previously used `mysql-connector`, which didn't provide the right version. – stefanbschneider Feb 09 '19 at 21:43

score 10 · Answer 2 · edited Nov 15 '18 at 02:24

10

Installs the drive for python3.

python3 -m pip install mysql-connector-python

Installs the drive for the default python preinstalled on your system by the manufacturer.

python -m pip install mysql-connector-python

edited Nov 15 '18 at 02:24

Book Of Zeus

49,509
18
174
171

answered Nov 15 '18 at 02:06

DKMDebugin

551
7
16

1

A little nitpick, running these commands in the root context is plain wrong and might turn your Linux into a pumkin. Never run pip in root context, there are apt/yum/... whatever tools which manage the system packages, pip shall be used in the user context only. – mestia Jul 14 '22 at 11:23

Giuseppe Marcucci · Answer 3 · 2018-08-25T09:27:09.213

I had the same problem

"Authentication plugin '{0}' is not supported".format(plugin_name)) mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported"

This happens because your Python connector does not support the authentication plugin caching_sha2_password and you need to update it. I fixed it by installing the correct Python connector from MySQL official site. Be sure to download the correct connector based on your operating system, MySQL version and the Python version you use.

score 3 · Answer 4 · answered Jul 25 '18 at 06:32

3

Seems this package works for me: sudo pip install MySQL-connector-python

answered Jul 25 '18 at 06:32

Allen211

69
6

score 2 · Answer 5 · answered Mar 07 '19 at 12:03

I was getting the exact same issue and tried to update the mysql-connector module with pip as suggested in the accepted answer, however that did not help. I realized that the problem might be related to my Anaconda environment, hence I tried using conda for updating my mysql-connector-python module.

Finally I resolved this issue with the following command:

conda install -c anaconda mysql-connector-python

This seems to do what pip could not do, at least in my case. The link of the conda package is: https://anaconda.org/anaconda/mysql-connector-python

score 2 · Answer 6 · answered Nov 13 '19 at 19:44

Got the same issue just now, and tried all the answers above (none worked).

Per MySQL 8 documentation, easiest way to fix this is to add the following to your MySQL d file -> restart MySQL server. This worked for me!

If your MySQL installation must serve pre-8.0 clients and you encounter compatibility issues after upgrading to MySQL 8.0 or higher, the simplest way to address those issues and restore pre-8.0 compatibility is to reconfigure the server to revert to the previous default authentication plugin (mysql_native_password). For example, use these lines in the server option file:

[mysqld]
#add the following file to your MySQLd file
    default_authentication_plugin=mysql_native_password

score 1 · Answer 7 · answered May 09 '18 at 07:22

1

MySQL 8.0 made caching_sha2_password the default authentication for new accounts, which requires updated connectors to be able to use it. Alternatively, you can change the account to use the native auth method (but that is less secure).

answered May 09 '18 at 07:22

Mike Lischke

48,925
16
119
181

score 0 · Answer 8 · answered Aug 23 '21 at 10:48

Personally, I’m a fan of the pymysql package.
Added bonus: the implementation is based on PEP 249, and it is purely Python!

Please note:

Most public APIs are compatible with mysqlclient and MySQLdb.
PyMySQL doesn’t support low level APIs _mysql provides like data_seek, store_result, and use_result. You should use high level APIs defined in PEP 249. But some APIs like autocommit and ping are supported because PEP 249 doesn’t cover their usecase.

caching sha2 password is not supported mysql

8 Answers8

Linked