grafana使用mysql8.0.28做数据源

grafana使用mysql8.0.28做数据源
1、创建库名、用户和账户授权
create database grafana DEFAULT CHARACTER SET utf8mb4;
create user 'grafana'@'%' identified with mysql_native_password by '123123';
GRANT ALL ON grafana.* TO grafana@'%' WITH GRANT OPTION;

2、修改配置文件
vim /etc/grafana/grafana.ini

[database]
type = mysql
host = 127.0.0.1:3306
name = grafana
user = grafana
password = grafanap

grafana使用mysql存储session
1、创建session表
CREATE TABLE `session` (
`key` CHAR(16) NOT NULL,
`data` BLOB,
`expiry` INT(11) UNSIGNED NOT NULL,
PRIMARY KEY (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

2、修改配置文件
[session]
provider = mysql
provider_config = grafana:grafana@tcp(127.0.0.1:3306)/grafana
cookie_name = grafana_sess
cookie_secure = false
session_life_time = 86400