Grafana MySQL Tutorial | Configure MySQL Data Source for Grafana Dashboard

Аватар автора
PHP Инженер
Hello Friends, This tutorial is on Grafana and MySQL. We are going to create grafana docker container and mysql container. We will be creating sample data in to mysql databse by importing an xml file. Then we will connect the database to grafana and will create our dashboard. All the step by step instructions are available below. docker run -d --name=grafana -p 3001:3000 -v grafana_config:/etc/grafana -v grafana_data:/var/lib/grafana -v grafana_logs:/var/log/grafana grafana/grafana docker container run -d --name mysqldb -p 3306:3306 -v db_data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=password mysql:latest docker exec -it mysqldb bash mysql -u root -ppassword show databases; create database team; USE team; CREATE TABLE person ( person_id INT NOT NULL PRIMARY KEY, fname VARCHAR(40) NULL, lname VARCHAR(40) NULL, age INT NOT NULL, created TIMESTAMP ); SET GLOBAL local_infile=1; mysql --local-infile=1 -u root -ppassword select * from team.person; Command to add the port to firewall: sudo firewall-cmd --permanent --zone=public --add-port=3306/tcp sudo firewall-cmd --reload ======================================================= Follow me @: ======================================================

0/0


0/0

0/0

0/0