Skip to content


 Zabbix
 Grafana
 Prometheus
 Threejs and TypeScript
 SocketIO and TypeScript
 Blender Topological Earth
 Sweet Home 3D
 Design Patterns Python
 Design Patterns TypeScript
   
 Course Coupon Codes
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




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.