import mysql.connector

cnx = mysql.connector.connect(user='root',
                          password='password',
                          host='127.0.0.1',
                          database='db')
print(cnx)
cnx.close()

Traceback (most recent call last):
File "D:/ted/main.py", line 5, in <module>
database='db')
File "C:Program Files (x86)Python36-32libmysqlconnector__init__.py",
line 179, in connect
return MySQLConnection(*args, **kwargs)
File "C:Program Files (x86)Python36-32libmysqlconnectorconnection.py",
line 94, in __init__
self.connect(**kwargs)
File "C:Program Files (x86)Python36-32libmysqlconnectorabstracts.py",
line 722, in connect
self._open_connection()
File "C:Program Files (x86)Python36-32libmysqlconnectorconnection.py",
line 211, in _open_connection
self._ssl)
File "C:Program Files (x86)Python36-32libmysqlconnectorconnection.py",
 line 141, in _do_auth
auth_plugin=self._auth_plugin)
File "C:Program Files (x86)Python36-32libmysqlconnectorprotocol.py",
line 102, in make_auth
auth_data, ssl_enabled)
File "C:Program Files (x86)Python36-32libmysqlconnectorprotocol.py",
line 58, in _auth_response
auth = get_auth_plugin(auth_plugin)(
 File "C:Program Files (x86)Python36-
32libmysqlconnectorauthentication.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

Process finished with exit code 1