GitHub user dosubot[bot] added a comment to the discussion: use mysql
<!-- Answer --> To integrate Superset with MySQL instead of SQLite, you can follow these steps: 1. **Install the MySQL Driver**: Ensure you have the `mysqlclient` package installed: ```bash pip install mysqlclient ``` 2. **Configure the Connection String**: Update the Superset configuration to use the MySQL connection string format: ```plaintext mysql://<UserName>:<DBPassword>@<Database Host>/<Database Name> ``` 3. **Update Superset Configuration**: Modify the Superset configuration file (usually `superset_config.py`) to set the SQLAlchemy URI to point to your MySQL database. For example: ```python SQLALCHEMY_DATABASE_URI = 'mysql://username:password@localhost/superset' ``` These steps will configure Superset to use MySQL as the metadata database <sup>[[1]](https://github.com/apache/superset/blob/master/docs/docs/configuration/configuring-superset.mdx)</sup>. Additionally, I found a similar closed issue where the suggested solution was to set the `SUPERSET_CONFIG_PATH` environment variable: ```bash export SUPERSET_CONFIG_PATH=superset/superset_config.py ``` This solution was confirmed to work by multiple users <sup>[[2]](https://github.com/apache/superset/issues/2467)</sup>. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/db3d5216-fb3f-4a97-8d74-49a2059dd2cc?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/db3d5216-fb3f-4a97-8d74-49a2059dd2cc?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/db3d5216-fb3f-4a97-8d74-49a2059dd2cc?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/db3d5216-fb3f-4a97-8d74-49a2059dd2cc?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/db3d5216-fb3f-4a97-8d74-49a2059dd2cc?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/db3d5216-fb3f-4a97-8d74-49a2059dd2cc?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/db3d5216-fb3f-4a97-8d74-49a2059dd2cc?feedback_type=other)</sup> GitHub link: https://github.com/apache/superset/discussions/33200#discussioncomment-12906602 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
