正在docker中连接mysqld exporter-mysql\u up 0

huwehgph  于 2021-06-21  发布在  Mysql
关注(0)|答案(1)|浏览(632)

我做了什么:

1. docker run --net minha-rede --name mysql01 -e MYSQL_ROOT_PASSWORD=Password1234 -d mysql

2. docker run --net minha-rede --name wordpress01 --link mysql01 -p 8080:80 -e WORDPRESS_DB_HOST=mysql01:3306 -e WORDPRESS_DB_USER=root -e WORDPRESS_DB_PASSWORD=Password1234 -e WORDPRESS_DB_NAME=wordpress -e WORDPRESS_TABLE_PREFIX=wp_ -d wordpress

3. docker exec -it mysql01 bash

4. mysql -u root -p

5. CREATE USER 'luckerman'@'localhost' IDENTIFIED BY 'onboard' WITH MAX_USER_CONNECTIONS 3;

6. GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'luckerman'@'localhost';

7. exit

8. exit

9. docker run -d \
  -p 9104:9104 --name mysqlexp01\
  --network minha-rede  \
  -e DATA_SOURCE_NAME="luckerman:onboard@(minha-rede:3306)/" \
  prom/mysqld-exporter

但是当我运行 http://localhost:9104/metrics 我有消息 # TYPE mysql_exporter_last_scrape_error gauge mysql_exporter_last_scrape_error 1 当我跑的时候 docker logs mysqlexp01 它告诉我:
time=“2018-09-11t20:57:40z”level=info msg=“正在启动mysqld\u exporter(version=0.11.0,branch=head,revision=5d7179615695a61ecc3b5bf90a2a7c76a9592cdd)”source=“mysqld\u exporter.go:206”
time=“2018-09-11t20:57:40z”level=info msg=“构建上下文(go=go1.10.3,user=root@3d3ff666b0e4,date=20180629-15:00:35)“source=”mysqld\u exporter.go:207“
time=“2018-09-11t20:57:40z”level=info msg=“启用的scrapers:”source=“mysqld\u exporter.go:218”
time=“2018-09-11t20:57:40z”level=info msg=“--collect.info\u schema.tables”source=“mysqld\u exporter.go:222”
time=“2018-09-11t20:57:40z”level=info msg=“--collect.global\u status”source=“mysqld\u exporter.go:222”
time=“2018-09-11t20:57:40z”level=info msg=“--collect.global\u variables”source=“mysqld\u exporter.go:222”
time=“2018-09-11t20:57:40z”level=info msg=“--collect.slave\u status”source=“mysqld\u exporter.go:222”
time=“2018-09-11t20:57:40z”level=info msg=“监听:9104”source=“mysqld\u exporter.go:232”
time=“2018-09-11t20:57:44z”level=error msg=“error pinging mysqld:dial tcp 127.0.0.1:3306:connect:连接被拒绝”source=“exporter.go:119”
我做错了什么?我尝试了很多论坛,网站等。。。

gzjq41n4

gzjq41n41#

成功了!我做到了:
docker网络检查minha rede
然后我找到了我的sql的ip(在我的例子中是172.23.0.2),然后我输入了我的sql并执行了以下命令:create user'luckerman'@'172.23.0.2'由'onboard'标识,最大用户连接数为3;
授权进程,复制客户端,选择“开”。“幸运儿”@'172.23.0.2';
谢谢你@alex karshin!

相关问题