python 验证mysql_（Python）MySQL数据库身份验证troub

我尝试运行下面的代码，将symbols变量的组件添加到名为securities\u master的数据库中。我之前发布了这个问题，并修复了大量错误，但是，我仍然收到以下错误：Traceback (most recent call last):

File "C:/Users/Nathan/.PyCharmCE2018.1/config/scratches/scratch.py", line 28, in

insert_btc_symbols(symbols)

File "C:/Users/Nathan/.PyCharmCE2018.1/config/scratches/scratch.py", line 15, in insert_btc_symbols

con = MySQLdb.connect(host=db_host,user=db_user,db=db_name) #,passwd=db_pass

File "C:\Python27\lib\site-packages\MySQLdb\__init__.py", line 81, in Connect

return Connection(*args, **kwargs)

File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 193, in __init__

super(Connection, self).__init__(*args, **kwargs2)

_mysql_exceptions.OperationalError: (1251, 'Client does not support authentication protocol requested by server; consider upgrading MySQL client')

Process finished with exit code 1

我尝试通过没有密码的用户和根用户以及密码的公钥进行连接，但都没有成功。以下是我正在执行的代码：

^{pr2}$