How to edit user privileges with JetBrains DataGrip?

Question

How can I edit user privileges of some MySQL servers with JetBrains DataGrip?

score 16 · Answer 1 · answered Nov 29 '17 at 09:17

16

As far as I can tell, the state of the art is that you either

write+run hand-written SQL statements for user management (see MySQL docs at [1] )
run DataGrip in the background while running MySQL Workbench or phpMyAdmin in the foreground and do the user management there

Let's hope that the situation improves, but right now there does not even seem to be a feature request for that.

answered Nov 29 '17 at 09:17

mnagel

2

There is now a feature request, but it has not seen a lot of activity: https://youtrack.jetbrains.com/issue/DBE-3599 – Quentin Skousen Sep 18 '18 at 22:08

score 2 · Accepted Answer · answered Jan 13 '23 at 21:35

2

You can now right click a database or schema to navigate to "Tools" > "Modify Grants..".

answered Jan 13 '23 at 21:35

Webber

2 Answers2