Skip to content

Create MySQL Data Source

Video Lecture

Create MySQL Data Source Create MySQL Data Source Create MySQL Data Source

Description

I create a new MySQL Data Source.

I also demonstrate how to install a MySQL database server in case you don't have one.

I install the MySQL database on my existing Grafana Server to make it easier to follow the lecture.

You can install MySQL on any server you like.

1
2
3
4
5
sudo apt install mysql-server

sudo mysql_secure_installation

sudo service mysql status

I also create an example database, and a specific user called grafana@localhost, that will have SELECT only access to the database.

1
mysqladmin create exampledb
1
mysql
1
2
3
4
5
6
7
> CREATE USER 'grafana'@'localhost' IDENTIFIED BY 'password';

> GRANT SELECT ON exampledb.* TO 'grafana'@'localhost';

> FLUSH PRIVILEGES;

> quit

I then continue setting up the MySQL data source using the Grafana User Interface.