Configuring Apache Superset With Mysql Database

I am configuring apache to read from mysql instead of sqlite; The following is the details in my configuration file. I don't quite understand how to configure the file above to rea

Solution 1:

There might be 2 things going on:

1. It seems your DB URI should be in the format of mysql://username:password@host:port/dbname as opposed to just mysql://username:password@host:port/ (see https://docs.sqlalchemy.org/en/13/core/engines.html#mysql for reference)
2. It seems you're looking to connect to that mysql database in order to query it and visualize its data - NOT to use it as your superset database backend (i.e. the database superset is going to use in order to persist your superset configurations). For the latter, you might be better off to just using sqlite.
   In order to connect to your target DB to actually query it, see "Connecting To Your Target Database(s)" on https://duperset.com/getting_started