1/18/2024 0 Comments Mysqld exporterWorkaround: Changing the password to an password without # and worked for the exporter. Type '\c' to clear the current input > \qĮrror-Msg: Mar 29 15:51:27 host0815 mysqld_exporter: time="T15:51:27+01:00" level=error msg="Error pinging mysqld: Error 1045: Benutzer hat keine Zugriffsberechti gung (verwendetes Passwort: Ja)" source="exporter.go:119" Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. MariaDB > 10.3 NOTE: Not all collection methods are supported on MySQL/MariaDB < 5. But rather you should whitelist IP of the server, where prometheus-mysqld-exporter is setup. Server version: 8.0.13 MySQL Community Server - GPLĬopyright (c) 2000, 2018, Oracle and/or its affiliates. MySQL Server Exporter Prometheus exporter for MySQL server metrics. Then I deployed the mysql exporter like this: docker exec -it mysql80 mysql -uroot -p Enter password: mysql> CREATE USER exporter IDENTIFIED BY exporterpassword WITH MAXUSERCONNECTIONS 3 mysql> GRANT PROCESS, REPLICATION CLIENT, SELECT ON. Solution: When you are creating user in MariaDB which in your case is exporter444.333.22.111, therefore this means you are whitelisting 444.333.22.111 for user exporter. socket=/opt/mysql/admin/mond/config/mysql.sock -user=MON_NOCMONITOR mysql -defaults-file=/home/mysqladm/.myMOND.cnf ![]() ![]() It queries MySQL, scraps the data, and exposes the metrics to a Kubernetes service endpoint. Mysql would have been started with the following arguments: TO exporter192.168.1. The MySQL exporter is required to monitor and expose MySQL metrics. Mysql -defaults-file=/home/mysqladm/.myMOND.cnf -print-defaults
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |