# Error 1142 (42000): UPDATE command denied to user when Explain/Tables tab clicked

**URL:** <https://forums.percona.com/t/error-1142-42000-update-command-denied-to-user-when-explain-tables-tab-clicked/25717>\
**Category:** PMM 2.x\
**Created:** [October 6, 2023, 11:42am UTC](https://forums.percona.com/t/error-1142-42000-update-command-denied-to-user-when-explain-tables-tab-clicked/25717 "2023-10-06T11:42:23Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![msutic](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/msutic/32/4218_2.png) [@msutic](https://forums.percona.com/u/msutic)\
**Post date:** [October 6, 2023, 11:42am UTC](https://forums.percona.com/t/error-1142-42000-update-command-denied-to-user-when-explain-tables-tab-clicked/25717/1 "2023-10-06T11:42:23Z")

</div>

## Description:

When Explain/Tables tab is clicked to get execution plan for DML statement error is popped.

```auto
Error 1142 (42000): UPDATE command denied to user 'pmm2mysql'@'127.0.0.1' for table 'table1'
or
Error 1142 (42000): INSERT, UPDATE command denied to user 'pmm2mysql'@'127.0.0.1' for table 'table2'

```

Looks like explain plan is not working for DML statements. Even tested with SUPERUSER privileges for “pmm2mysql” user and behavior is the same.

Is this expected?

## Steps to Reproduce:

Click on DML query and check Explain plan.

## Version:

2.39 (server and client)

## Expected Result:

Get Explain plan.

## Actual Result:

Error 1142 (42000): UPDATE command denied to user ‘pmm2mysql’@‘127.0.0.1’ for table ‘table1’

## Additional Information:

Chrome

---

<div class="post-metadata">

**Author:** ![Denis\_Subbota](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/denis_subbota/32/23607_2.png) [@Denis\_Subbota](https://forums.percona.com/u/Denis_Subbota)\
**Post date:** [October 6, 2023, 1:35pm UTC](https://forums.percona.com/t/error-1142-42000-update-command-denied-to-user-when-explain-tables-tab-clicked/25717/2 "2023-10-06T13:35:41Z")

</div>

Hello Msutic,

Could you please share grants for the ‘pmm2mysql’@‘127.0.0.1’ user ?

Regards,  
Denis Subbota.  
Managed Services, Percona.

---

<div class="post-metadata">

**Author:** ![msutic](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/msutic/32/4218_2.png) [@msutic](https://forums.percona.com/u/msutic)\
**Post date:** [October 9, 2023, 7:40pm UTC](https://forums.percona.com/t/error-1142-42000-update-command-denied-to-user-when-explain-tables-tab-clicked/25717/3 "2023-10-09T19:40:56Z")

</div>

Hi Denis,

```auto
mysql> show grants for 'pmm2mysql'@'127.0.0.1';
+--------------------------------------------------------------------------------------------+
| Grants for pmm2mysql@127.0.0.1 |
+--------------------------------------------------------------------------------------------+
| GRANT SELECT, RELOAD, PROCESS, SUPER, REPLICATION CLIENT ON *.* TO 'pmm2mysql'@'127.0.0.1' |
+--------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

```

Best regards,  
Marko

---

<div class="post-metadata">

**Author:** ![Denis\_Subbota](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/denis_subbota/32/23607_2.png) [@Denis\_Subbota](https://forums.percona.com/u/Denis_Subbota)\
**Post date:** [October 10, 2023, 7:21am UTC](https://forums.percona.com/t/error-1142-42000-update-command-denied-to-user-when-explain-tables-tab-clicked/25717/4 "2023-10-10T07:21:39Z")

</div>

Hi msutic,  
With such grants it’s expected to see such kind of errors.  
Try to add grants INSERT, UPDATE for user ‘pmm2mysql’@‘127.0.0.1’ it should help you to fix this issue:

```auto
GRANT SELECT, INSERT, UPDATE ,RELOAD, PROCESS, SUPER, REPLICATION CLIENT ON *.* TO 'pmm2mysql'@'127.0.0.1';

```

Regards,  
Denis Subbota.  
Managed Services, Percona.

---

<div class="post-metadata">

**Author:** ![msutic](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/msutic/32/4218_2.png) [@msutic](https://forums.percona.com/u/msutic)\
**Post date:** [October 10, 2023, 9:01pm UTC](https://forums.percona.com/t/error-1142-42000-update-command-denied-to-user-when-explain-tables-tab-clicked/25717/5 "2023-10-10T21:01:24Z")

</div>

Hi Denis,  
Granting mentioned privileges fixes issue.

Do you think docs needs to be updated?

> **[Percona Monitoring and Management - MySQL](https://docs.percona.com/percona-monitoring-and-management/setting-up/client/mysql.html)**
>
> How to set up PMM to monitor a MySQL or MySQL-based database instance.

```auto
CREATE USER 'pmm'@'127.0.0.1' IDENTIFIED BY 'pass' WITH MAX_USER_CONNECTIONS 10;
GRANT SELECT, PROCESS, REPLICATION CLIENT, RELOAD, BACKUP_ADMIN ON *.* TO 'pmm'@'127.0.0.1';

```

With mentioned privileges you will not be able to get explain plan for DML statements.

Thanks

Best regards,  
Marko
