invalid metric type “dictionary_file_words_count untyped“

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!FWtVKXNkQudD2fW&#1j&W4DDMwaHD5lz@TV6Y&bX%MVOoA2OwjQrKilFx';
mysql> grant process,replication client,select on *.* to 'mysqlmonitor2'@'localhost';
mysql> flush privileges;