MySQL Bugs: #68054: Connector/Python does not support mysql_clear

Bug #68054	Connector/Python does not support mysql_clear_password
Submitted:	8 Jan 2013 23:25	Modified:	12 Mar 2014 1:05
Reporter:	Daniel Padwa	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / Python	Severity:	S3 (Non-critical)
Version:	1.0.8	OS:	Any
Assigned to:	Geert Vanderkelen	CPU Architecture:	Any

Description:
MySQL Connector/Python does not allow you to connect to a database with a security plugin that wants to do mysql_clear_password.

How to repeat:
Try to connect to a database that can handle mysql_clear_password.   The server sends back:

OperationalError: 1251 (08004): Client does not support authentication protocol requested by server; consider upgrading MySQL client

Not inspiring for a client that is under three weeks old.

Suggested fix:
Implement the protocol.

Thank you for the reasonable feature request.

Noted in 1.2.1 changelog.

Connector/Python now supports authentication plugins found in MySQL
5.6. This includes mysql_clear_password and sha256_password, both of
which require an SSL connection. The sha256_password plugin does not
work over a non-SSL connection because Connector/Python does not
support RSA encryption.

The connect() method now supports an auth_plugin parameter that can
be used to force use of a particular plugin. For example, if the
server is configured to use sha256_password by default, specify
auth_plugin='mysql_native_password' to connect to an account that
authenticates using mysql_native_password.