Bug description
When I try to connect mysql in web. I cannot choose mysql in web:
I use docker compose to install tag 5.0.0
Screenshots/recordings
No response
Superset version
master / latest-dev
Python version
3.9
Node version
16
Browser
Chrome
Additional context
No response
Checklist
- [ ] I have searched Superset docs and Slack and didn't find a solution to my problem.
- [ ] I have searched the GitHub issue tracker and didn't find a similar bug report.
- [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
Comment From: dosubot[bot]
MySQL is missing from the connection options because the required driver is not installed in your Docker image. Starting with Superset 4.1.0, database drivers like MySQL are no longer included by default—you need to add them yourself for MySQL support to appear in the UI reference.
To fix this:
1. Create a file called requirements-local.txt
in your docker
directory (if it doesn’t exist).
2. Add either mysqlclient
or mysql-connector-python
to that file.
3. Rebuild your Docker image and restart Superset.
Example:
echo "mysqlclient" >> docker/requirements-local.txt
docker compose build --force-rm
docker compose up
If you get errors about missing system dependencies (like default-libmysqlclient-dev
), you’ll need to create a custom Dockerfile that installs those before the Python package reference.
If MySQL still doesn’t show up, check your Superset logs for any errors about missing MySQL drivers and share them here for more help.
To reply, just mention @dosu.
How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other