# pmm-admin add mysql not working... **URL:** \ **Category:** PMM 2.x\ **Created:** [April 3, 2020, 12:02pm UTC](https://forums.percona.com/t/pmm-admin-add-mysql-not-working/7504 "2020-04-03T12:02:38Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![marcio](https://avatars.discourse-cdn.com/v4/letter/m/f19dbf/32.png) [@marcio](https://forums.percona.com/u/marcio)\ **Post date:** [April 3, 2020, 12:02pm UTC](https://forums.percona.com/t/pmm-admin-add-mysql-not-working/7504/1 "2020-04-03T12:02:38Z")
Hello !! how are you doing ? I switch the pmm v1 to new pmm v2, and I can’t add the monitoring for mysql with pmm-admin (before working fine with pmm v1). I tried a lot of options and still getting the error for dial tcp connection.  I have running the mysql server with the default port (3306). I believe this issue may have relation with [[PMM-4782] PMM2 default service name not picked up while adding instance from pmm-admin - Percona JIRA](https://jira.percona.com/browse/PMM-4782) I appreciate any help in advance!! Thank you. # pmm-admin list Service type  Service name         Address and port  Service ID Agent type                  Status     Agent ID                                        Service ID pmm\_agent                   Connected  /agent\_id/0488982d-c64a-4076-a53a-6de3acc6f2a3  node\_exporter               Running    /agent\_id/fbc96f99-0ad7-403c-80ac-1abac01e2d1e # pmm-admin add mysql --username=pmm  --password=password --service-name=araguaia 127.0.0.1:3306 --debugDEBUG 2020-04-03 17:14:26.408993096Z: POST /local/Status HTTP/1.1 Host: 127.0.0.1:7777 User-Agent: Go-http-client/1.1 Content-Length: 3 Accept: application/json Content-Type: application/json Accept-Encoding: gzip {} DEBUG 2020-04-03 17:14:26.413423518Z: HTTP/1.1 200 OK Content-Length: 449 Content-Type: application/json Date: Fri, 03 Apr 2020 17:14:26 GMT Grpc-Metadata-Content-Type: application/grpc {“agent\_id”:“/agent\_id/0488982d-c64a-4076-a53a-6de3acc6f2a3”,“runs\_on\_node\_id”:“/node\_id/0babb77a-42d9-4f00-9171-5e3bf289e589”,“server\_info”:{“url”:“[https://root:password@pmm.server:443/“,“insecure\_tls”:true,“connected”:true,“version”:“2.4.0”},“agents\_info”:[{“agent\_id”:”/agent\_id/fbc96f99-0ad7-403c-80ac-1abac01e2d1e",“agent\_type”:“NODE\_EXPORTER”,“status”:“RUNNING”}],“config\_filepath”:"/usr/local/percona/pmm2/config/pmm-agent.yaml](https://root:password@pmm.server:443/%22,%22insecure_tls%22:true,%22connected%22:true,%22version%22:%222.4.0%22%7D,%22agents_info%22:%5B%7B%22agent_id%22:%22/agent_id/fbc96f99-0ad7-403c-80ac-1abac01e2d1e%22,%22agent_type%22:%22NODE_EXPORTER%22,%22status%22:%22RUNNING%22%7D%5D,%22config_filepath%22:%22/usr/local/percona/pmm2/config/pmm-agent.yaml)”} DEBUG 2020-04-03 17:14:26.414132693Z: POST /local/Status HTTP/1.1 Host: 127.0.0.1:7777 User-Agent: Go-http-client/1.1 Content-Length: 3 Accept: application/json Content-Type: application/json Accept-Encoding: gzip {} DEBUG 2020-04-03 17:14:26.415052048Z: HTTP/1.1 200 OK Content-Length: 449 Content-Type: application/json Date: Fri, 03 Apr 2020 17:14:26 GMT Grpc-Metadata-Content-Type: application/grpc {“agent\_id”:“/agent\_id/0488982d-c64a-4076-a53a-6de3acc6f2a3”,“runs\_on\_node\_id”:“/node\_id/0babb77a-42d9-4f00-9171-5e3bf289e589”,“server\_info”:{“url”:“[https://root:password@pmm.server:443/“,“insecure\_tls”:true,“connected”:true,“version”:“2.4.0”},“agents\_info”:[{“agent\_id”:”/agent\_id/fbc96f99-0ad7-403c-80ac-1abac01e2d1e",“agent\_type”:“NODE\_EXPORTER”,“status”:“RUNNING”}],“config\_filepath”:"/usr/local/percona/pmm2/config/pmm-agent.yaml](https://root:password@pmm.server:443/%22,%22insecure_tls%22:true,%22connected%22:true,%22version%22:%222.4.0%22%7D,%22agents_info%22:%5B%7B%22agent_id%22:%22/agent_id/fbc96f99-0ad7-403c-80ac-1abac01e2d1e%22,%22agent_type%22:%22NODE_EXPORTER%22,%22status%22:%22RUNNING%22%7D%5D,%22config_filepath%22:%22/usr/local/percona/pmm2/config/pmm-agent.yaml)”} DEBUG 2020-04-03 17:14:26.415637609Z: POST /v1/management/MySQL/Add HTTP/1.1 Host: pmm.server:443 User-Agent: Go-http-client/1.1 Content-Length: 302 Accept: application/json Authorization: Basic dW5pbGE6c2VuaGFtdWl0b3NlY3JldGEyMDE4 Content-Type: application/json Accept-Encoding: gzip {“node\_id”:“/node\_id/0babb77a-42d9-4f00-9171-5e3bf289e589”,“service\_name”:“araguaia”,“address”:“127.0.0.1”,“port”:3306,“pmm\_agent\_id”:“/agent\_id/0488982d-c64a-4076-a53a-6de3acc6f2a3”,“username”:“pmm”,“password”:“password”,“qan\_mysql\_slowlog”:true,“max\_slowlog\_file\_size”:“0”} DEBUG 2020-04-03 17:14:26.626416737Z: HTTP/1.1 400 Bad Request Transfer-Encoding: chunked Trailer: Grpc-Trailer-Content-Type Content-Type: application/json Date: Fri, 03 Apr 2020 17:14:26 GMT Server: nginx be {“error”:“Connection check failed: dial tcp 127.0.0.1:3306: connect: connection refused.”,“code”:9,“message”:“Connection check failed: dial tcp 127.0.0.1:3306: connect: connection refused.”} 0 DEBUG 2020-04-03 17:14:26.626612647Z: Result: \                                DEBUG 2020-04-03 17:14:26.626661767Z: Error: &my\_sql.AddMySQLDefault{\_statusCode:400, Payload:(\*my\_sql.AddMySQLDefaultBody)(0xc0003edb80)} Connection check failed: dial tcp 127.0.0.1:3306: connect: connection refused. # ---
**Author:** ![alexey.palazhchenko](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/alexey.palazhchenko/32/35_2.png) [@alexey.palazhchenko](https://forums.percona.com/u/alexey.palazhchenko)\ **Post date:** [April 6, 2020, 8:15am UTC](https://forums.percona.com/t/pmm-admin-add-mysql-not-working/7504/2 "2020-04-06T08:15:20Z")
> [@](#): > > pmm-admin add mysql --username=pmm  --password=password --service-name=araguaia 127.0.0.1:3306 --debug In that command both “araguaia” and “127.0.0.1:3306” are service names. ```auto pmm-admin add mysql --help usage: pmm-admin add mysql [<flags>] [<name>] [<address>] Add MySQL to monitoring Flags: [...] --service-name=NAME Service name (overrides positional argument) --host=HOST Service hostname or IP address (overrides positional argument) --port=PORT Service port number (overrides positional argument) [...] Positional arguments: [<name>] Service name (autodetected default: mini-mysql) [<address>] MySQL address and port (default: 127.0.0.1:3306) ``` “pmm-admin add mysql --username=pmm  --password=password araguaia 127.0.0.1:3306” should work. ---
**Author:** ![marcio](https://avatars.discourse-cdn.com/v4/letter/m/f19dbf/32.png) [@marcio](https://forums.percona.com/u/marcio)\ **Post date:** [April 6, 2020, 8:29am UTC](https://forums.percona.com/t/pmm-admin-add-mysql-not-working/7504/3 "2020-04-06T08:29:29Z")
Hi [alexey.palazhchenko](https://forums.percona.com/profile/alexey.palazhchenko)!! The error still the same, I have tested with this commands: # pmm-admin add mysql --username=pmm  --password=password araguaia 127.0.0.1:3306 Connection check failed: dial tcp 127.0.0.1:3306: connect: connection refused. # pmm-admin add mysql --username=pmm  --password=password araguaia IP\_ADDRESS\_V4:3306 Connection check failed: dial tcp IP\_ADDRESS\_V4:3306: connect: connection refused.