In this article you are going to learn steps for changing Grafana Database To Mysql. We will begin with learning to install Mysql database first. Post Mysql database is installed then we will change Grafana to use Mysql.
Table of Contents
Installing MySQL Server
wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
sudo rpm -ivh mysql57-community-release-el7-9.noarch.rpm
sudo yum install mysql-server
Starting MySQL Server
sudo systemctl start mysqld
sudo systemctl status mysqld
sudo grep 'temporary password' /var/log/mysqld.log
Creating a new database in MySQL Database
sudo mysql_secure_installation
create database grafanadb CREATE USER 'grafana'@'localhost' IDENTIFIED BY 'grafana';
GRANT ALL PRIVILEGES ON grafanadb.* TO 'grafana'@'localhost';
FLUSH PRIVILEGES;
Making changes in Grafana Configuration File.
Open Grafana configuration file which is by default available at /etc/grafana/grafana.ini and change url of mysqldb as shown below:
url =mysql://grafana:grafana@localhost:3306/grafanadb
I hope you liked this article about Changing Grafana Database to MySQL. You can read more about Grafana here or by selecting one of the topics from below list. You can also subscribe me on my Youtube Channel.
- Embedding Grafana in a websiteIntroduction of Embedding Grafana in a website Embedding grafana in a website is pretty simple if you want to embed Grafana Panels using Iframe. Often there …
- Monitor Docker Using Telegraf and GrafanaIn this article I am going to show you how you can Monitor Docker Using Telegraf and Grafana. Let us begin with a quick official intro …
- Grafana Email Alerts and Change Default TemplateIn this article I am going to show you how you can configure Grafana Email Alerts and Change Default Template. Please notice that in this article …
Grafana Email Alerts and Change Default Template Read More »
- Grafana and Telegram IntegrationIf you want to integrate Grafana and Telegram so that Grafana alerts can be received in any of the Telegram groups then this article is for …
- Installing InfluxDb and TelegrafIn this article I will show you steps for Installing InfluxDb and Telegraf. If there is any query please write in the comment box and I …