This brief tutorial shows students and new users how to install Metabase on Ubuntu 18.04 | 16.04 server.
For those who don’t know, Metabase is a free, open source platform that helps companies and businesses easily summarize and visualize large data sets without ever writing a line of SQL.
Follow asked Nov 4 '20 at 6:34. Cignitor Cignitor. 681 3 3 gold badges 12 12 silver badges 34 34 bronze badges. Just to mention, because you. Metabase provides limited support for migrating from H2 to Postgres or MySQL if you decide to upgrade to a more production-ready database. See Migrating from H2 to MySQL or Postgres for more details. H2 (default) For production installations of Metabase we recommend that users replace the H2 database with a more robust option such as Postgres.
It allows users to search through tables, then filter things down to find just is needed without learning how to run SQL queries. Simply use its flexible GUI to look up data sets.
If you’re looking for a free, high performance database lookup platform for your business, Metabase may be just want you want at your company.
For more about Metabase, please visit its homepage.
If you’re a student or new user looking for a Linux system to start learning on, the easiest place to start is Ubuntu Linux OS…. It’s a great Linux operating system for beginners and folks looking for easier Linux distribution to use..
Ubuntu is an open source Linux operating systems that runs on desktops, laptops, server and other devices…
When using Ubuntu, you will find that Linux isn’t so different than Windows and other operating systems in so many ways, especially when it comes to using the system to get work done.…
![Metabase Metabase](/uploads/1/0/8/0/108075575/700422400.png)
When you’re ready to install Metabase, follow the steps below:
Step 1: Install Java
Metabase is written in the Java so you’ll need Java installed to run it. The open source Java works great with Metabase. To install the open source version of Java, run the commands below:
After installing Java, the commands below can be used to verify whether Java is installed.
java -version
You should see similar output as below:
Step 2: Install MariaDB Database Server
Metabase also requires a database server to store its content… If you’re looking for a truly open source database server, then MariaDB is a great place to start…
To install MariaDB run the commands below:
sudo apt-get install mariadb-server mariadb-client
After installing MariaDB, the commands below can be used to stop, start and enable MariaDB service to always start up when the server boots…
Run these on Ubuntu 16.04 LTS
Run these on Ubuntu 18.10 and 18.04 LTS
Next, run the commands below to secure the database server with a root password if you were not prompted to do so during the installation…
sudo mysql_secure_installation
When prompted, answer the questions below by following the guide.
- Enter current password for root (enter for none): Just press the Enter
- Set root password? [Y/n]: Y
- New password: Enter password
- Re-enter new password: Repeat password
- Remove anonymous users? [Y/n]: Y
- Disallow root login remotely? [Y/n]: Y
- Remove test database and access to it? [Y/n]: Y
- Reload privilege tables now? [Y/n]: Y
Now that MariaDB is installed, to test whether the database server was successfully installed, run the commands below…
sudo mysql -u root -p
type the root password when prompted…
If you see a similar screen as shown above, then the server was successfully installed…
Step 4: Create Metabase Database
Now that you’ve installed all the packages that are required for Metabase to function, continue below to start configuring the servers. First run the commands below to create a blank Metabase database.
To logon to MariaDB database server, run the commands below.
sudo mysql -u root -p
Then create a database called metabase
CREATE DATABASE metabase;
Create a database user called metabaseuser with a new password
CREATE USER 'metabaseuser'@'localhost' IDENTIFIED BY 'new_password_here';
Then grant the user full access to the database.
GRANT ALL ON metabase.* TO 'metabaseuser'@'localhost' WITH GRANT OPTION;
Finally, save your changes and exit.
Step 4: Install Metabase
Now that Java is installed, run the commands below to download Metabase from its official package repository. At the time of this writing, the current version was at 0.34.1.
After downloading, move Metabase Java app to its new home directory at /opt/metabase.
After downloading, move Metabase Java app to its new home directory at /opt/metabase.
To run Metabase effectively, you’ll want to create a dedicated user and group accounts.. Simply run the commands below to create a username metabase as well as a group name.
Next, change the ownership of the /opt/metabase directory so the user can have full control of content in there.
After that, you will also want to create Metabase systemd service so you can control starting, stopping and enabling its service.. To do that, simply run the commands below to create a service file.
sudo nano /etc/systemd/system/metabase.service
Then copy the content below into the file and save it.
After saving it, run the commands below to enable the service.
To verify if the service is functioning, run the commands below to check it.
sudo systemctl status metabase
You should see similar output as below:
Next you need to create a syslog conf to make sure systemd is able to handle the logs properly.
Run the commands below to create a syslog config file.
sudo nano /etc/rsyslog.d/metabase.conf
Then copy and paste the lines below into the file and save.
After that, restart Metabase service by running the commands below:
sudo systemctl restart metabase
Finally, open your browser and browse to the server hostname or IP address followed by port #3000
You should see Metabase setup wizard.
Click the button to get started and continue.
First create an admin account with password to continue.
Then choose to add a database. For this tutorial, we’re using MySQL or MariaDB. Type in the database information created above and continue with the setup.
After that, finish the setup and begin using your platform.
Login and begin setting up your environment,
That should do it!
Conclusion:
This post shows you how to install Metabase Server on Ubuntu 18.04 | 16.04. If you find any errors above, please use the comment form below to report them.
You may also like the post below:
v0.39.0.1 / Administration Guide / Mysql
Working with MySQL in Metabase
Connecting to MySQL 8+ servers
Metabase uses the MariaDB connector to connect to MariaDB and MySQL servers. The MariaDB connector does not currently support MySQL 8’s default authentication plugin, so in order to connect, you’ll need to change the plugin used by the Metabase user to
mysql_native_password
: ALTER USER 'metabase'@'%' IDENTIFIED WITH mysql_native_password BY 'thepassword';
If you’re still experiencing problems connecting, please refer to the troubleshooting guide.
![Metabase mysql login Metabase mysql login](/uploads/1/0/8/0/108075575/639086576.png)
Raising a MySQL Docker container of MySQL 8+
If you are spinning up a new MySQL container, and:
- you want Metabase to connect to the container without having to manually create the user or change the authentication mechanism,
- or you’re facing a
RSA public key is not available client side (option serverRsaPublicKeyFile not set)
error,
Use the
['--default-authentication-plugin=mysql_native_password']
modifiers when you run the container, like so:Metabase Query Builder
- a simple docker run:
docker run -p 3306:3306 -e MYSQL_ROOT_PASSWORD=xxxxxx mysql:8.xx.xx --default-authentication-plugin=mysql_native_password
- or in docker-compose: