import mysql.connector as mysql
import dbconfig as dbConf
import csv

class Database:
    # class variable
    db_name = 'data_preparation_tools'

    #------------------------------------------------------
    def connect(self):
        # connect by unpacking dictionary credentials
        conn = mysql.connect(user='', password='', host='localhost', charset= 'utf8mb4', auth_plugin='mysql_native_password')

        # create cursor
        cursor = conn.cursor()

        return conn, cursor

    #------------------------------------------------------
    def close(self, conn, cursor):
        # close cursor
        cursor.close()

        # close connection to MySQL
        conn.close()

    #------------------------------------------------------
    def showDBs(self):
        # connect to MySQL
        conn, cursor = self.connect()

        # print results
        cursor.execute("SHOW DATABASES")
        print(cursor)
        print(cursor.fetchall())

        # close cursor and connection
        self.close(cursor, conn)

    def useDB(self, cursor):
        cursor.execute('use data_preparation_tools')


db=Database()
db.connect()

(env) C:\Users\Preparation_Tools\GUI>py main.py
Traceback (most recent call last):
  File "main.py", line 26, in <module>
    from igcrawl import IgCrawler
  File "C:\Users\Preparation_Tools\igcrawl.py", line 15, in <module>
    from db_connect import Database
  File "C:\Users\Preparation_Tools\db_connect.py", line 85, in <module>
    db.connect()
  File "C:\Users\Preparation_Tools\db_connect.py", line 12, in connect
    conn = mysql.connect(user='', password='', host='localhost', charset= 'utf8mb4', auth_plugin='mysql_native_password')
  File "C:\Users\Preparation_Tools\env\lib\site-packages\mysql\connector\__init__.py", line 179, in connect
    return MySQLConnection(*args, **kwargs)
  File "C:\Users\Preparation_Tools\env\lib\site-packages\mysql\connector\connection.py", line 94, in __init__
    self.connect(**kwargs)
  File "C:\Users\Preparation_Tools\env\lib\site-packages\mysql\connector\abstracts.py", line 722, in connect
    self._open_connection()
  File "C:\Users\Preparation_Tools\env\lib\site-packages\mysql\connector\connection.py", line 211, in _open_connection
    self._ssl)
  File "C:\Users\Preparation_Tools\env\lib\site-packages\mysql\connector\connection.py", line 143, in _do_auth
    self._auth_switch_request(username, password)
  File "C:\Users\Preparation_Tools\env\lib\site-packages\mysql\connector\connection.py", line 166, in _auth_switch_request
    auth = get_auth_plugin(new_auth_plugin)(
  File "C:\Users\Preparation_Tools\env\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