Prometheus监控mysql8时报错,提示密码问题,原因猜测:新版Mysql中加入了validate_password插件用于测试密码并提高安全性,Prometheus连接mysql时密码长度检测不符合要求,加长密码长度即可
invalid metric type "dictionary_file_words_count untyped"
主要报错信息:
err=“invalid metric type “dictionary_file_words_count untyped””
level=warn ts=2023-03-17T12:29:06.912965042Z
caller=scrape.go:836 component="scrape manager"
scrape_pool=agent1_mysql target=http://192.168.75.162:9104/metrics msg="append failed"
err="invalid metric type \"dictionary_file_words_count untyped\""
解决办法:将密码长度加长,最好50
位,随机密码生成:https://suijimimashengcheng.bmcx.com/
mysql> create user 'mysqlmonitor2'@'localhost' identified by 'f*SLvBlsJ8ETFhYlFTuigQknVVWG50zHVvJrhDswr!FWtVKXNkQudD2fWj&W4DDMwaHD5lz@TV6Y&bX%MVOoA2OwjQrKilFx';
mysql> grant process,replication client,select on *.* to 'mysqlmonitor2'@'localhost';
mysql> flush privileges;