Error 1045: Access denied for user

[fanhualei]

lookat: #137

I have a very similar issue right now.

mkdir mytest
cd mytest
vi docker-compose.yml

docker-compose.yml

version: '3'
services:

  #mysql
  mysql:
    hostname: mysql
    image: mysql:5.7
    environment:
      MYSQL_ROOT_PASSWORD: pw123456
  
  #mysql-exporter
  mysql-exporter:
    image: prom/mysqld-exporter
    hostname: mysql-exporter
    environment:
      - DATA_SOURCE_NAME="root:pw123456@(mysql:3306)/"      

testing

docker-compose up -d 

docker-compose exec mysql bash
docker-compose exec mysql mysql  -uroot -ppw123456
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'pw123456' WITH GRANT OPTION;


docker-compose exec  -u root  mysql-exporter ash
> ping -c 2 mysql
> wget localhost:9104/metrics  
> exit      
        
docker-compose logs  mysql-exporter

the logs

 time="2019-10-22T13:14:39Z" level=error msg="Error pinging mysqld: Error 1045: Access denied for user '\"root'@'172.26.0.2' (using password: YES)" source="exporter.go:146"

docker -v

Docker version 19.03.2, build 6a30dfc
docker-compose version 1.24.1, build 4667896b
centos7

[fanhualei]

why is :my mysql network
not: mysql host name or mysqlhost ip

The example given on this website ：https://github.com/prometheus/mysqld_exporter

example

docker network create my-mysql-network
docker pull prom/mysqld-exporter

docker run -d \
  -p 9104:9104 \
  --network my-mysql-network  \
  -e DATA_SOURCE_NAME="user:password@(my-mysql-network:3306)/" \
  prom/mysqld-exporter

[leapcat]

why is :my mysql network
not: mysql host name or mysqlhost ip

The example given on this website ：https://github.com/prometheus/mysqld_exporter

example

docker network create my-mysql-network
docker pull prom/mysqld-exporter

docker run -d \
  -p 9104:9104 \
  --network my-mysql-network  \
  -e DATA_SOURCE_NAME="user:password@(my-mysql-network:3306)/" \
  prom/mysqld-exporter

I got same error as you did. It seems mysql-exporter should be deployed in the same host with mysqld. and It‘s wrong to use network name 'my-mysql-network' in the example . I use mysql service name instead.

[fanhualei]

Did you succeed?

Can you give an example code ?

[leapcat]

Did you succeed?

Can you give an example code ?

Yes, I resolved this problem. mysqld-exporter seems has bug to deal with 'DATA_SOURCE_NAME', I use config file instead. please refer my docker-compse service configuration:

prometheus-mysqld-exporter: image: prom/mysqld-exporter:latest container_name: prometheus-mysqld-exporter restart: on-failure hostname: prometheus-mysqld-exporter # Default use 'nobody', change to 'root' user: root # Add arguments entrypoint: - mysqld_exporter - --config.my-cnf=/etc/my.cnf #- --log.level=debug environment: # Use this always get 'Access denied for user' response from mysqld. Use my.cnf is ok. It costs me almost a day. #- DATA_SOURCE_NAME="exporter:123456@(mysql:3306)/" - TZ=Asia/Shanghai volumes: - /root/mysqld-exporter/my.cnf:/etc/my.cnf

[Shadowstrider-Jackie]

  - DATA_SOURCE_NAME=root:pw123456@(mysql:3306)/

Do not use double or single quotes

[fearless11]

  -e DATA_SOURCE_NAME=root:pw123456@(mysql:3306)/

but script execution error：
syntax error near unexpected token `('

[nulf]

Was driving me mad but @ironboyjw found the solution(for my problem at least). No single or double quotes in the docker-compose file environment-entry. Thanks!

[Littlehhao]

我的密码有@符号如何处理呢