title: How to connect superset with mysql database?
body: <p>I was trying to connect superset with mysql database with this SQLAlchemy URI:<code>mysql://localhost:3306/mysql/database/table1</code>  but not able to connect.</p>
  <p>I was getting this error:</p>
  <pre><code>ERROR: {&quot;error&quot;: &quot;Connection failed!
  
  The error message returned was:
  No module named 'MySQLdb'&quot;, &quot;stacktrace&quot;: &quot;Traceback (most recent call last):
    File \&quot;/Users/akay/venv/lib/python3.7/site-packages/superset/views/core.py\&quot;, line 1703, in testconn
      engine = database.get_sqla_engine(user_name=username)
    File \&quot;/Users/akay/venv/lib/python3.7/site-packages/superset/utils/core.py\&quot;, line 131, in __call__
      value = self.func(*args, **kwargs)
    File \&quot;/Users/akay/venv/lib/python3.7/site-packages/superset/models/core.py\&quot;, line 923, in get_sqla_engine
      return create_engine(url, **params)
    File \&quot;/Users/akay/venv/lib/python3.7/site-packages/sqlalchemy/engine/__init__.py\&quot;, line 479, in create_engine
      return strategy.create(*args, **kwargs)
    File \&quot;/Users/akay/venv/lib/python3.7/site-packages/sqlalchemy/engine/strategies.py\&quot;, line 87, in create
      dbapi = dialect_cls.dbapi(**dbapi_args)
    File \&quot;/Users/arkay/venv/lib/python3.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.py\&quot;, line 118, in dbapi
      return __import__(\&quot;MySQLdb\&quot;)
      ModuleNotFoundError: No module named 'MySQLdb'
  &quot;}
  </code></pre>