title: sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (2059, "Authentication plugin 'caching_sha2_password'
body: <p>I am learning to implement Flask application.
  And using mysql as a database.
  I tried MySQLdb, flask_mysql &amp; flask_sqlalchemy.</p>
  
  <p>But still getting this error, when i try to perform any action on database :</p>
  
  <p>sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (2059, "Authentication plugin 'caching_sha2_password' cannot be loaded: The specified module could not be found.\r\n")</p>
  
  <p>I also tried :
  ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password  BY 'root';</p>
  
  <p>Please help.
  Thanks.</p>