dosubot[bot] commented on issue #34208: URL: https://github.com/apache/superset/issues/34208#issuecomment-3084581237
<!-- Answer --> Superset officially supports two MySQL drivers: mysqlclient (the default, also known as mysqldb) and mysql-connector-python. mysqlclient is recommended for most cases, but it does not support the caching_sha2_password authentication plugin used by newer MySQL servers. If you need caching_sha2_password, you should use mysql-connector-python instead. Both drivers are supported for basic SQL operations, but as you've seen, there are known issues with DDL/DML result set handling in mysql-connector-python [docs](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/docs/docs/configuration/databases.mdx). PyMySQL is mentioned in some community discussions as a possible alternative (connection string: `mysql+pymysql://user:password@host:port/dbname`), but it is not officially documented or supported by Superset, and its compatibility—especially with authentication plugins and DDL/DML handling—may be limited [discussion](https://github.com/apache/superset/issues/31400). No other MySQL drivers are officially recognized or documented as supported by Superset for MySQL connections. If you need caching_sha2_password, mysql-connector-python is the main supported option, despite its current limitations with DDL/DML in Superset [docs](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/docs/docs/configuration/databases.mdx). <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/1162d81b-861f-4459-a584-5b485a4f02f3?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/1162d81b-861f-4459-a584-5b485a4f02f3?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/1162d81b-861f-4459-a584-5b485a4f02f3?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/1162d81b-861f-4459-a584-5b485a4f02f3?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/1162d81b-861f-4459-a584-5b485a4f02f3?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/1162d81b-861f-4459-a584-5b485a4f02f3?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/1162d81b-861f-4459-a584-5b485a4f02f3?feedback_type=other)</sup> [](https://go.dosu.dev/discord-bot) [! [Share on X](https://img.shields.io/badge/X-share-black)](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/34208) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
