-1

I've just installed Apache Superset v5.0.0, and I'm trying to configure a database connection. However, I only see options for PostgreSQL and SQLite; the MySQL connection button is missing. I've searched online and found some discussions suggesting that Superset v5.0.0 removed the direct MySQL button, and now users are expected to use the "Other" database option for MySQL connections. This seems difficult to believe and counter-intuitive for such a common database.

Can anyone confirm if this information is accurate? If so, could you please provide guidance on the correct way to connect MySQL databases in Superset v5.0.0 using the "Other" option, or clarify if there's a different method I'm overlooking?

Improve this question

1 Answer 1

Reset to default
0

Yes, that's correct. Starting with Apache Superset v5.0.0, some connectors like MySQL no longer have a dedicated button in the interface. Instead, you're expected to use the "Other" option to manually configure the connection. MySQL is still fully supported, but you need to enter the connection string manually.

First, make sure you have the required driver installed. You can use either mysqlclient or PyMySQL. PyMySQL is often easier to set up:

pip install pymysql

If needed, you can also add this to your Python environment so SQLAlchemy recognizes it:

importpymysql pymysql.install_as_MySQLdb()

Then, in Superset, go to Data > Databases > + Database, and choose "Other". There, enter the SQLAlchemy connection string. For example:

mysql+pymysql://username:password@host:port/database_name

A specific example would be:

mysql+pymysql://root:1234@localhost:3306/my_database

Click on "Test Connection", and if it works, save it.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.