Changing Grafana Database to MySQL

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.

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.

• Grafana and Telegram Integration
  Sending Alerts from Grafana to Telegram is very popular method. Let’s learn the integration by following step by step approach. First thing you need is a …

  Grafana and Telegram Integration Read More »
• Installing InfluxDb and Telegraf
  In 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 …

  Installing InfluxDb and Telegraf Read More »

• Upgrading from Grafana 6 to Grafana 7
  In this article I am going to show you steps for Upgrading from Grafana 6 to Grafana 7. We will be installing Latest version of Grafana …

  Upgrading from Grafana 6 to Grafana 7 Read More »

• Changing Grafana Database to MySQL
  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 …

  Changing Grafana Database to MySQL Read More »

• Installing Grafana on Windows
  In this article I will show you all the steps required for Installing Grafana on Windows Operating System. After reading this article if you still have …

  Installing Grafana on Windows Read More »