How can I edit user privileges of some MySQL servers with JetBrains DataGrip?
Database-Specific Privileges To GRANT ALL privileges to a user , allowing that user full control over a specific database , use the following syntax: mysql> GRANT ALL PRIVILEGES ON database_name. * TO 'username'@'localhost';
In the Database Explorer (View | Tool Windows | Database Explorer), right-click a and select Modify. In the Modify Table dialog, specify the settings that you need.
As far as I can tell, the state of the art is that you either
Let's hope that the situation improves, but right now there does not even seem to be a feature request for that.
[1] https://dev.mysql.com/doc/refman/5.7/en/user-account-management.html
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With