这是我在W3school上学习关于pythonMySQL数据库连接的一个程序，在pycharm中运行出错：
Traceback (most recent call last):
File "C:Userscarmel.hanDesktopmysqltest.py", line 7, in
auth_plugin='mysql_native_password'
File "C:Python27ArcGIS10.4libsite-packagesmysqlconnector__init__.py", line 179, in connect
return MySQLConnection(*args, **kwargs)
File "C:Python27ArcGIS10.4libsite-packagesmysqlconnectorconnection.py", line 95, in __init__
self.connect(**kwargs)
File "C:Python27ArcGIS10.4libsite-packagesmysqlconnectorabstracts.py", line 719, in connect
self._open_connection()
File "C:Python27ArcGIS10.4libsite-packagesmysqlconnectorconnection.py", line 210, in _open_connection
self._ssl)
File "C:Python27ArcGIS10.4libsite-packagesmysqlconnectorconnection.py", line 144, in _do_auth
self._auth_switch_request(username, password)
File "C:Python27ArcGIS10.4libsite-packagesmysqlconnectorconnection.py", line 167, in _auth_switch_request
auth = get_auth_plugin(new_auth_plugin)(
File "C:Python27ArcGIS10.4libsite-packagesmysqlconnectorauthentication.py", line 191, in get_auth_plugin
"Authentication plugin '{0}' is not supported".format(plugin_name))
NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
解决方案：
win+R输入：
pip install mysql-connector-python
请注意，mysql-connector已弃用，应该使用mysql-connector-python
