这是我在W3school上学习关于pythonMySQL数据库连接的一个程序，在pycharm中运行出错：
Traceback (most recent call last):
File "C:\Users\carmel.han\Desktop\mysqltest.py", line 7, in
auth_plugin='mysql_native_password'
File "C:\Python27\ArcGIS10.4\lib\site-packages\mysql\connector\__init__.py", line 179, in connect
return MySQLConnection(*args, **kwargs)
File "C:\Python27\ArcGIS10.4\lib\site-packages\mysql\connector\connection.py", line 95, in __init__
self.connect(**kwargs)
File "C:\Python27\ArcGIS10.4\lib\site-packages\mysql\connector\abstracts.py", line 719, in connect
self._open_connection()
File "C:\Python27\ArcGIS10.4\lib\site-packages\mysql\connector\connection.py", line 210, in _open_connection
self._ssl)
File "C:\Python27\ArcGIS10.4\lib\site-packages\mysql\connector\connection.py", line 144, in _do_auth
self._auth_switch_request(username, password)
File "C:\Python27\ArcGIS10.4\lib\site-packages\mysql\connector\connection.py", line 167, in _auth_switch_request
auth = get_auth_plugin(new_auth_plugin)(
File "C:\Python27\ArcGIS10.4\lib\site-packages\mysql\connector\authentication.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