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.
- Master Top 60 Grafana Interview Questions and AnswersIn this article, we are going to discuss about frequently asked Grafana Interview Questions and Answers. Beginner-Level Grafana Interview Questions and Answers What is Grafana? Grafana… Read more: Master Top 60 Grafana Interview Questions and Answers
- What is the default username and password for Grafana login page?In this article, we are going to discuss the default username and password for the Grafana web login page. Default Grafana Username admin Default Grafana Password… Read more: What is the default username and password for Grafana login page?
- Jira Grafana DashboardIn this “Jira Grafana Dashboard” Video, I am going to show you how to create a Jira dashboard in Grafana using Jira APIs. Grafana opensource doesn’t… Read more: Jira Grafana Dashboard
- Prometheus vs. Grafana: A Comprehensive Comparison for Effective Monitoring and VisualizationIn the realm of observability and monitoring, Prometheus and Grafana stand out as two powerful tools that play complementary roles in ensuring the reliability and performance… Read more: Prometheus vs. Grafana: A Comprehensive Comparison for Effective Monitoring and Visualization
- New Relic vs. Grafana: Choosing the Right Monitoring Tool for Your BusinessNew Relic Vs. Grafana, The right tools play a crucial role in IT operations and application performance monitoring. When it comes to this, New Relic and… Read more: New Relic vs. Grafana: Choosing the Right Monitoring Tool for Your Business