In this article, we will install and configure Grafana with the MySQL database. Grafana is an open-source monitoring and data visualization tool. Grafana uses MySQL for storing Users, sessions, and dashboard ( You can use other databases as well). Let’s start with Grafana installation.
Lab setup
OS: Amazon Linux.
Grafana version: 6.3.2
Hosted on: AWS
Database: MySQL
Grafana Installation
Download the rpm package from the official Grafana website. The below link helps you to get it.
https://grafana.com/grafana/download?platform=linux
Execute the below command to install the Grafana package.
[root@techiescorner ~]# wget https://dl.grafana.com/oss/release/grafana-6.3.2-1.x86_64.rpm [root@techiescorner ~]# yum localinstall grafana-6.3.2-1.x86_64.rpm
Once the installation completed we can start the service with the following command.
[root@techiescorner ~]# service grafana-server start
Check server status with the below command.
The default port of Grafana is 3000, make sure that you have opened it in the firewall.
Database Configuration
Login to the MySQL and execute the below commands to create a user and password and grant access for the user over the database.
mysql> create database grafana; Query OK, 1 row affected (0.01 sec) mysql> grant all privileges on grafana.* to grafana@localhost identified by "Techies123"; Query OK, 0 rows affected, 1 warning (0.01 sec) mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) mysql> exit
Add database details in the Grafana configuration file. The location will be
/etc/grafana/grafana.ini Please refer below screenshot.
Restart the Grafana service to pick up the newly added database details.
[root@techiescorner ~]# service grafana-server restart Stopping Grafana Server: ... [ OK ] Starting Grafana Server: ... [ OK ]
Now try to access the Grafana interface from the browser, HTTP://< your server IP>:3000. The default Username and Password is “admin”.
Once you logged in the first time you need to change the password.
From the Grafana home page click on the “Add database” option to add database details. Refer below screenshot
By clicking the “Save&Test” button you can confirm the details are correct. If you are getting any error, please make sure you have used correct the database name, user and password. Also, make sure that the user has access to the associated database.
