mysqld_exporter state down on prometheus

[paldapd]

Hello, I am trying to create a database dashboard using mysqld_exporter, Prometheus, and Grafana. Previously, I installed Prometheus and Grafana inside a Docker container. However, I attempted to install mysqld_exporter directly on the server.

After the installation process was complete, I checked Prometheus and found that mysqld_exporter was in the "down" state with the message: "Get "http://localhost:9104/metrics": dial tcp 127.0.0.1:9104: connect: connection refused."

Then, I checked the logs, and here is what I found:
sudo journalctl -u mysql.service ... Sep 04 14:40:52 lumoshive-dev-001 systemd[1]: mysql.service: Main process exited, code=killed, status=9/KILL ... Sep 17 07:11:24 lumoshive-dev-001 systemd[1]: mysql.service: Succeeded. Sep 17 07:11:24 lumoshive-dev-001 systemd[1]: Stopped MySQL Community Server.
And the status of mysqld_exporter:
sudo systemctl status mysqld_exporter ... Dec 28 15:15:38 lumoshive-dev-001 mysqld_exporter[247507]: ts=2023-12-28T08:15:38.606Z caller=tls_config.go:195 level=info msg="TLS is disabled." http2=false

When I check curl http://localhost:9104/metrics, I get metrics related to the Go runtime garbage collector, indicating that mysqld_exporter is running.

I appreciate any assistance in understanding why this is happening and how to resolve it. Thank you!