How to edit user privileges with JetBrains DataGrip?

mysql jetbrains-ide datagrip
iizno picture iizno · Feb 16, 2017 · Viewed 11.7k times · Source

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

Answer

mnagel picture mnagel · Nov 29, 2017

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

Related questions

How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command: UPDATE tablename SET columnname=1; It gives …

Read More