Can't grant any privileges to a MySQL user, and editing a user with existing grants tries to revoke everything


I'm having a weird issue with DataGrip (2022.2.2, Windows, MySQL) where modifying a user's grants doesn't generate any SQL. In the first screenshot, I have tried to add a new grant, but nothing appears in the preview, and clicking "OK" does not modify the user.

Odder, in the second screenshot I am trying to modify a user who already has grants. Even though I have not touched anything in the modify window, the preview SQL is trying to revoke every grant the user has.

Any ideas of how to resolve this? I am having to go back to MySQL Workbench to work with users in the meantime.

1 comment
Official comment

Fix will be available in DataGrip 2022.2.3.

Please sign in to leave a comment.