Create MySQL Data Source

Video Lecture

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.

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`

mysql

> 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.