# pmm-admin add mysql - invalid username or password **URL:** \ **Category:** PMM 1.x\ **Created:** [December 4, 2019, 5:01am UTC](https://forums.percona.com/t/pmm-admin-add-mysql-invalid-username-or-password/7330 "2019-12-04T05:01:17Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![holala](https://avatars.discourse-cdn.com/v4/letter/h/bbe5ce/32.png) [@holala](https://forums.percona.com/u/holala)\ **Post date:** [December 4, 2019, 5:01am UTC](https://forums.percona.com/t/pmm-admin-add-mysql-invalid-username-or-password/7330/1 "2019-12-04T05:01:17Z")
Hello, I’m trying to add mysql monitoring: sudo pmm-admin add mysql --query-source=perfschema --username=XXX --password=XXX --debug Username/password are correct, I can login to mysql locally, to 127.0.0.1. But I always get: “Invalid username or password. Please check username and password.” Is there any special mysql role I need to add to the user? Or may be there’s some firewall issue I’m not aware of? ​​​​​​​Regards​​​​​​​ ---
**Author:** ![Stateros](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/stateros/32/2490_2.png) [@Stateros](https://forums.percona.com/u/Stateros)\ **Post date:** [December 4, 2019, 5:28am UTC](https://forums.percona.com/t/pmm-admin-add-mysql-invalid-username-or-password/7330/2 "2019-12-04T05:28:16Z")
Hello, could you check your CREATE USER statement for pmm? PMM2 is sensitive for difference between localhost and 127.0.0.1 For example my pmm\_user statements are: ```auto CREATE USER pmm_user'@'127.0.0.1 IDENTIFIED BY pmm_password; GRANT SELECT, PROCESS, SUPER, REPLICATION CLIENT, RELOAD ON *.* TO pmm_user'@'127.0.0.1 WITH MAX_USER_CONNECTIONS 10; GRANT SELECT, UPDATE, DELETE, DROP ON performance_schema.* TO pmm_user'@'127.0.0.1; ``` ---
**Author:** ![holala](https://avatars.discourse-cdn.com/v4/letter/h/bbe5ce/32.png) [@holala](https://forums.percona.com/u/holala)\ **Post date:** [December 4, 2019, 8:00am UTC](https://forums.percona.com/t/pmm-admin-add-mysql-invalid-username-or-password/7330/3 "2019-12-04T08:00:00Z")
Added these grants, still doesn’t work. Debug output is the following: DEBUG 2019-12-04 13:26:11.438438107Z: POST /v1/management/MySQL/Add HTTP/1.1 Host: XXX:443 User-Agent: Go-http-client/1.1 Content-Length: 291 Accept: application/json Authorization: Basic YWRtaW46YWRtaW4= Content-Type: application/json Accept-Encoding: gzip {“address”:“127.0.0.1”,“max\_slowlog\_file\_size”:“0”,“node\_id”:“/node\_id/59474a06-80ab-4819-8a4a-787d52e8fdf0”,“password”:“XXX”,“pmm\_agent\_id”:“/agent\_id/6590d7c2-db64-4793-88ec-0edad86dc472”,“port”:3306,“qan\_mysql\_slowlog”:true,“service\_name”:“XXX-mysql”,“username”:“pmm”} DEBUG 2019-12-04 13:26:11.591946912Z: HTTP/1.1 401 Unauthorized Content-Length: 92 Connection: keep-alive Content-Type: application/json Date: Wed, 04 Dec 2019 13:26:11 GMT Server: nginx {“code”:16,“error”:“Invalid username or password”,“message”:“Invalid username or password”} DEBUG 2019-12-04 13:26:11.592128639Z: Result: DEBUG 2019-12-04 13:26:11.592170075Z: Error: &my\_sql.AddMySQLDefault{\_statusCode:401, Payload:(\*my\_sql.AddMySQLDefaultBody)(0xc000508480)} Invalid username or password. Please check username and password. ---
**Author:** ![Stateros](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/stateros/32/2490_2.png) [@Stateros](https://forums.percona.com/u/Stateros)\ **Post date:** [December 5, 2019, 5:59am UTC](https://forums.percona.com/t/pmm-admin-add-mysql-invalid-username-or-password/7330/4 "2019-12-05T05:59:10Z")
As I can see you are Unauthorized on pmm-server side. You need to specify admin user and admin password from PMM Server on config stage. ```auto pmm-admin config 10.10.10.10 generic best_db_name --server-insecure-tls --server-url=http://admin_user:admin_apssword@pmm.com/ ``` ---
**Author:** ![holala](https://avatars.discourse-cdn.com/v4/letter/h/bbe5ce/32.png) [@holala](https://forums.percona.com/u/holala)\ **Post date:** [December 6, 2019, 5:06am UTC](https://forums.percona.com/t/pmm-admin-add-mysql-invalid-username-or-password/7330/5 "2019-12-06T05:06:43Z")
Ok, I got this working! In PMM Inventory I can see MySQL service. But nothing is displayed in mysql dashboards ☹ Been trying to find next steps in online docs/blogs, but couldn’t. ---
**Author:** ![Stateros](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/stateros/32/2490_2.png) [@Stateros](https://forums.percona.com/u/Stateros)\ **Post date:** [December 6, 2019, 7:02am UTC](https://forums.percona.com/t/pmm-admin-add-mysql-invalid-username-or-password/7330/6 "2019-12-06T07:02:55Z")
could you share output of? ```auto pmm-admin list ``` Also you can open url, but you should be logged in as admin. ```auto your-pmm-server-domain.com/prometheus/targets ``` There you can find all connected agent to PMM Server and their status. It can provide more information.