Create MySQL Data Source
Video Lecture
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.
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.
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.