Home > database >  Ask: mysql5.7 use mysqld_exporter monitoring, submitted to the authority problem
Ask: mysql5.7 use mysqld_exporter monitoring, submitted to the authority problem

Time:09-15

Using mysqld_exporter mysql monitor to the company, to MSG="Error pinging mysqld: Error 1045: Access denied for user 'exporter' @ 'localhost' (using password: YES)" source="mysqld_exporter. Go: 268"

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
  • Related