How to Configure Metabase in Linux CentOS 8

Introduction

In this article, the focus is exist as in the title of this article. It is about how to configure metabase in Linux CentOS 8. This article is the continuation of the previous article. In the previous article, the main focus is about to install metabase in Linux CentOS 8. That article exist in this link with the title of ‘How to Install Metabase in Linux CentOS 8’.

Step for Configuring Metabase in Linux CentOS 8

Following the end of the installation process of Metabase with the title of ‘How to Install Metabase in Linux CentOS 8’ exist in another article in this link, just follow these steps below :

1. Access the default URL of metabase in ‘http://localhost:3000’ in any types of web browser. The following page will appear :

2. Following after, just click the button Get Started in the page above, the following image of the next page will appear :

   Just choose the suitable preferred language and according to the image above, English is the preferred language. Change it accordingly to the suitable environment in order to ease the usage along with the preferred language. Click Next to continue on the metabase configuration.

3. Following after, the next metabase configuration will present the following page :

   Fill all of the entries accordingly and then click the Next button.

4. Next step, after filling the profile of the user, there will be a page appear as follows where the main focus is about the metabase database connection. In this context, it is using MariaDB where it is a compatible substitute for MySQL database server. So, check the MariaDB service in the first place as follows :

   [root@10 ~]# systemctl status mariadb
   ● mariadb.service - MariaDB 10.3 database server
      Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
      Active: active (running) since Wed 2021-04-07 21:57:17 EDT; 26min ago
        Docs: man:mysqld(8)
              https://mariadb.com/kb/en/library/systemd/
    Main PID: 975 (mysqld)
      Status: "Taking your SQL requests now..."
       Tasks: 30 (limit: 11412)
      Memory: 102.6M
      CGroup: /system.slice/mariadb.service
              └─975 /usr/libexec/mysqld --basedir=/usr
   Apr 07 21:57:08 localhost.localdomain systemd[1]: Starting MariaDB 10.3 database server...
   Apr 07 21:57:09 localhost.localdomain mysql-prepare-db-dir[928]: Database MariaDB is probably initialized in /var/lib/m>Apr 07 21:57:09 localhost.localdomain mysql-prepare-db-dir[928]: If this is not the case, make sure the /var/lib/mysql >Apr 07 21:57:11 localhost.localdomain mysqld[975]: 2021-04-07 21:57:11 0 [Note] /usr/libexec/mysqld (mysqld 10.3.27-Mar>Apr 07 21:57:17 10.0.2.15 systemd[1]: Started MariaDB 10.3 database server.
   [root@10 ~]# 
   

5. As soon as the checking process of MariaDB is finish with the status of running, access it to create a database, user account for metabase application as follows :

   [root@10 ~]# mysql -uroot -p
   Enter password:
   Welcome to the MariaDB monitor.  Commands end with ; or \g.
   Your MariaDB connection id is 14
   Server version: 10.3.27-MariaDB MariaDB Server
   Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
   cType 'help;' or '\h' for help. Type '\c' to clear the current input statement.
   MariaDB [(none)]> create database metabase;
   Query OK, 1 row affected (0.086 sec)
   MariaDB [(none)]> create user 'metabase'@'localhost' identified by 'metabase';
   Query OK, 0 rows affected (0.039 sec)
   MariaDB [(none)]> grant all on metabase.* to 'metabase'@'localhost';
   Query OK, 0 rows affected (0.010 sec)
   MariaDB [(none)]> flush privileges;
   Query OK, 0 rows affected (0.001 sec)
   MariaDB [(none)]>
   

6. At last, fill all of the database connection configuration credentials above in to the page for connecting metabase to the database as follows :

    

   Click the Next button after finishing. the following page will appear :

    

   In order to complete the configuration process, just click the button with the label of ‘Take me to Metabase’.

7. Finally, it will redirect to the metabase dashboard directly. The following output will appear :