Authentication not supported

[Reeta kushwaha]

FOR IMPORTING

import mysql.connector as c
db=c.connect(host='localhost',user='root',passwd='Akanksha',database='banking')
mc=db.cursor()
mc.execute("show tables")
for i in mc:
print(i)


WHILE MAKING CONNECTION BETWEEN MYSQL COMMAND LINE CLIENT AND PYTHON FOLLOWING MSG COMES:

File "C:\Users\pc\AppData\Roaming\Python\Python311\site-packages\mysql\connector\authentication.py", line 190, in get_auth_plugin
raise errors.NotSupportedError(
mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

WHEREAS MYSQL IS OPENING WITH PASSWORD