Authentication plugin caching sha2 password is not supported

Question

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

User · Answer

I uninstalled mysql-connector  I installed following tutorial on w3schools tutorial  and installed mysql-connector-python instead  It worked

User · Answer

Per Caching SHA-2 Pluggable Authentication     In MySQL 8 0  caching sha2 password is the default authentication plugin rather than mysql 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 an auth plugin argument that can be used to force use of a particular plugin  For example  if the server is configured to use sha256 password by default and you want to connect to an account that authenticates using mysql native password  either connect using SSL or specify auth plugin  mysql native password

User · Answer

None of the above solution work for me  I tried and very frustrated until I watched the following video  https   www youtube com watch v tGinfzlp0fE  pip uninstall mysql-connector work on some computer and it might not work for other computer   I did the followings   The mysql-connector causes problem    pip uninstall mysql-connector  The following may not need but I removed both connector completely  pip uninstall mysql-connector-python  re-install mysql-conenct-python connector  pip install mysql-connector-python

User · Answer

This question is already answered here and this solution works   caching sha2 password is not supported mysql  Just try this command    pip install mysql-connector-python

User · Answer

For those who couldn t work out because they installed mysql-connector first  I did the following  1 First on CMD go to the path of  pip  2 Use  pip list  command 3 There would be three packages installed namely six  protobuf and mysql-connector 4 Uninstall each of them separately 5 Now freshly install the mysql-connector-python module This worked out for me

User · Answer

I ran into the same problem as well   My problem was  that I accidentally installed the wrong connector version  Delete your currently installed version from your file system  my path looks like this  C  Program Files Python36 Lib site-packages  and then execute   pip install mysql-connector-python   This should solve your problem

User · Answer

Using MySql 8 I got the same error when connecting my code to the DB  using the pip install mysql-connector-python did solve this error

User · Answer

I had an almost identical error   Error while connecting to MySQL   Authentication plugin  caching sha2 password  is not supported  The solution for me was simple   My db username password creds were incorrect  The error was not descriptive of the problem  so I thought I would share this in case someone else runs into this

User · Answer

You can go to Settings- Project- Project Interpreter and here install latest version of mysql-connector-python package  In my case it was mysql-connector-python 8 0 15

User · Answer

To have a more permanent solution without going through your code and modifying whatever needs to be modified  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

User · Answer

I also got a similar error    File  C  Users User AppData Local Programs Python Python37-32 lib site-packages mysql connector authentication py   line 191  in get auth plugin      Authentication plugin   0   is not supported  format plugin name   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

User · Answer

I had the same problem and passing auth plugin  mysql native password  did not work  because I accidentally installed mysql-connector instead of mysql-connector-python  via pip3   Just leaving this here in case it helps someone

User · Answer

I had this same issue but my resolution was different because this didn t completely work    I found this on a GitHub forum - copy and paste this into your terminal  You don t have to change your password  it can be the exact same    ALTER USER  root   localhost  IDENTIFIED BY  password  PASSWORD EXPIRE NEVER  ALTER USER  root   localhost  IDENTIFIED WITH mysql native password BY   NewPassword

User · Answer

If you are looking for the solution of following error     ERROR  Could not install packages due to an EnvironmentError   WinError 5  Acces   s is denied   D  softwares spider Lib site-packages libmysql dll    Consider using the --user option or check the permissions    The solution  You should add --user if you find an access-denied error    pip install --user mysql-connector-python   paste this command into cmd and solve your problem

User · Answer

I was facing the same error for 2 days  then finally I found a solution  I checked for all the installed connectors using pip list and uninstalled all the connectors  In my case they were    mysql-connector mysql-connector-python mysql-connector-python-rf   Uninstalled them using pip uninstall mysql-connector and finally downloaded and installed the mysql-connector-python from MySQL official website and it works well

User · Answer

Please install below command using command prompt   pip install mysql-connector-python

User · Answer

Use pip install mysql-connector-python Then connect like this  import mysql connector  mydb   mysql connector connect    host  quot localhost quot                  hostname   user  quot Harish quot                       the user who has privilege to the db   passwd  quot Harish96 quot                  password for user   database  quot Factdb quot                  database name     auth plugin    mysql native password

User · Answer

Modify Mysql encryption  ALTER USER  lcherukuri   localhost  IDENTIFIED WITH mysql native password BY  password

User · Answer

Install mysql connector using the below command   pip install mysql-connector-python-rf Use the command to set the privileges   ALTER USER  root   localhost  IDENTIFIED WITH mysql native password BY      very strong password        FLUSH PRIVILEGES  Use the python command to connect to mysql database  mydb   mysql connector connect     host  localhost      user  root      passwd  very strong password      auth plugin  mysql native password

User · Answer

pip3 install mysql-connector-python did solve my problem as well  Ignore using mysql-connector module

User · Answer

pip install -U mysql-connector-python this worked for me  if you already have installed mysql-connector-python and then follow https   stackoverflow com a 50557297 6202853 this answer

User · Answer

i try to resolve this error and finally install PyMySQL instead of mysql library and it s working properly   thanks

[python] Authentication plugin 'caching_sha2_password' is not supported

Examples related to python

Examples related to mysql