Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to edit user privileges with JetBrains DataGrip?

Tags:

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

like image 343
iizno Avatar asked Feb 16 '17 13:02

iizno


People also ask

How do you give a user access to a database?

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';

How do I edit a view in DataGrip?

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.


1 Answers

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.

[1] https://dev.mysql.com/doc/refman/5.7/en/user-account-management.html

like image 153
mnagel Avatar answered Sep 21 '22 12:09

mnagel