Mysqld_exporter version mysqld_exporter - 0.10.0. Linux - amd64
Msyql version 5.7.26
Steps:
1, the root login mysql
2, new users and empowerment
TO GRANT the REPLICATION CLIENT, PROCESS ON *. * 'exporter' @ 'localhost' identified by '123456'.
GRANT SELECT ON *. * 'exporter' @ 'localhost'),
flush privileges;
3, create. My CNF file vi. My. CNF:
[client]
User=exporter
Password=123456
4, the implementation of nohup./mysqld_exporter - config. My - CNF.=my. CNF & amp;
The result Error MSG="Error pinging mysqld: Error 1045: Access denied for user 'exporter' @ 'localhost' (using password: YES)" source="mysqld_exporter. Go: 268"
The point is, to use Mysql - 5.6.25 version to do the same operation is no problem
Version 5.6 is your virtual machine, you can't change version 5.7 is a company, always let the
Look from an error, or jurisdiction, tried 'exporter' @ '%' no, I tried the user=root also not line, are all the same mistake
Mysql5.7 have other Settings?
CodePudding user response:
I also encountered this problem;My solution
Mysqld_exporter connect to the database, there are two way,
1, the configuration file. My. CNF
2, the environment variable export DATA_SOURCE_NAME='root: password @ TCP (IP: 3306)/'
My way into the environment variables well, hope to help you