Authentication plugin ‘caching_sha2_password’ is not supported

by

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.

More Related Contents:

  1. Python read from txt and save into mysql
  2. Lost connection to MySQL server during query
  3. How to install Python MySQLdb module using pip?
  4. Does Python support MySQL prepared statements?
  5. How to convert SQL Query result to PANDAS Data Structure?
  6. How do I get the “id” after INSERT into MySQL database with Python?
  7. Escape string Python for MySQL
  8. How to install MySQLdb (Python data access library to MySQL) on Mac OS X?
  9. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  10. Load CSV data into MySQL in Python
  11. Enable Python to Connect to MySQL via SSH Tunnelling
  12. Inserting a Python datetime.datetime object into MySQL
  13. How to replace Django’s primary key with a different integer that is unique for that table
  14. MySQL — Joins Between Databases On Different Servers Using Python?
  15. Using a Python dict for a SQL INSERT statement
  16. Python Mysql, “commands out of sync; you can’t run this command now”
  17. How do I escape % from python mysql query
  18. Bulk insert with SQLAlchemy ORM
  19. RuntimeError: working outside of application context
  20. Why are some mysql connections selecting old data the mysql database after a delete + insert?
  21. ImportError: No module named MySQLdb
  22. Can’t install mysql-python (newer versions) in Windows
  23. Using Django database layer outside of Django?
  24. How to move a model between two Django apps (Django 1.7)
  25. How do i cast char to integer while querying in django ORM?
  26. flake8 complains on boolean comparison “==” in filter clause
  27. How do I get time from a datetime.timedelta object?
  28. Python issue:Unable to find vcvarsall.bat [duplicate]
  29. Context manager for Python’s MySQLdb
  30. Retrieve query results as dict in SQLAlchemy

Leave a Comment