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.

Three.js and TypeScript
		Kindle Edition $9.99 $14.99 Paperback $29.99 $34.99
Design Patterns in TypeScript
		Kindle Edition $9.99 $14.99 Paperback $19.99 $24.99
Design Patterns in Python
		Kindle Edition $9.99 $14.99 Paperback $19.99 $24.99