sohelsarder commented on issue #5013: Connecting MySQL and PostgreSQL into SQLAlchemy URI URL: https://github.com/apache/incubator-superset/issues/5013#issuecomment-402609933 My superset version info is :"version": "0.25.6" mysql version is : 5.7, python version info : python2.7 first of all SQLALCHEMY_DATABASE_URI would be like this SQLALCHEMY_DATABASE_URI = 'mysql://{your mysql user name}:{your password }@localhost/{your db name}' While I tried to use mysql as a meta data storage for superset after running **pip install mysqlclient** The first error I got: EnvironmentError: mysql_config not found resolved this issue by running command: **sudo apt-get install libmysqlclient-dev** then got error: ImportError: No module named MySQLdb resolved this issue by running command: **pip install MySQL-python** Then everything worked perfectly for me.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
