MySQL Bugs: #102007: Support for cleartext auth

Bug #102007	Support for cleartext auth
Submitted:	16 Dec 2020 10:39	Modified:	16 Dec 2020 10:57
Reporter:	Daniël van Eeden (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	Shell General / Core Client	Severity:	S4 (Feature request)
Version:	8.0.22	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
For an account that requires cleartext authentication (over TLS) it is possible to setup a classic connection in a slightly weird way:

LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=1 mysqlsh ... mysql:// ...

However X Protocol connections fail to authenticate.

How to repeat:
Connect MySQL Shell to a MySQL 8.0 server with an account that required cleartext authentication.

Suggested fix:
1. Add a configuration option so that LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=1 is no longer needed.

2. Add support for X Protocol connections with cleartext auth (over TLS)

Hello Daniël,

Thank you for the reasonable feature request!

regards,
Umesh