How to add a MySQL database in Metabase?
As all databases, it is all a questions of credentials. To add a database within Metabase, proceed as follow:
May 09, 2018 Metabase has a table with a column name admin that is not being escaped by Liquibase (the library we use for our database migrations). It looks like the MySQL folks added it as a reserved word in 8, but they are making it non-reserved when 8.0.12 is released (according to the reference docs here). Hi @recfloyd, Metabase has officially supported MySQL 5.7+ for a few years now. We’ve been testing against 5.7 and 8.0 for a long time now but I believe 5.6 used to work as well. In 0.32.0 we switched to using the MariaDB JDBC driver because of licensing issues and it seems like it has problems with MySQL 5.6. Configuring the Metabase Application Database The application database is where Metabase stores information about users, saved questions, dashboards, and any other data needed to run the application. The default settings use an embedded H2 database, but this is configurable.
- Click on settings (right top and corner).
- Click on admin.
- Click on databases (top menu).
- Click on add database.
- Choose the database type 'MySQL'.
- Give an explicit name to your database, a name that you can easily remember later on.
- Indicate the host, if it is a local database, just let localhost.
- Indicate the port, if it is a local database, high chances that you can keep this field empty.
- Indicate the database name which correspond to the database you are querying.
- Indicate the user who has access to this database, so to say your username.
- For the rest, those are security measures, so as far as your database is not that big and that you are working with Metabase locally you don't need to fill those fields.
Mysql Metabase Example
Ok, you are good to go.