While executing the code below there is a runtime error showing - Authentication plugin 'caching_sha2_password' is not supported

Question

import mysql.connector as con
mydb= con.connect(host='localhost', user = 'username', password ='password', database= 'databasename');

Answer 1

There was a similar case before, but then it involved PHP, not Python.

https://www.sololearn.com/Discuss/2690328/?ref=app