如何使用mysqlconnector使sqlalchemy.create_engine与mysql_native_password连接？

如何使用mysqlconnector使sqlalchemy.create_engine与mysql_native_password连接？

您可以使用

connect_args

：

db_connection = sqlalchemy.create_engine(    'mysql+mysqlconnector://user:pwd@hostname/db_name',    connect_args={'auth_plugin': 'mysql_native_password'})

或网址查询：

db_connection = sqlalchemy.create_engine(    'mysql+mysqlconnector://user:pwd@hostname/db_name?auth_plugin=mysql_native_password')