The user myuser was originally created with permissions like a supervisor:

 mysql> SHOW GRANTS FOR 'myuser'; +---------------------------------------------------------------------+ | Grants for myuser@% | +---------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' WITH GRANT OPTION | +---------------------------------------------------------------------+

This user must have access to the mysql database, but the rights to all other databases should remain the same. After a couple of hours of attempts, nothing happened.

Do not tell me how to implement it?

  • Try it: REVOKE ALL PRIVILEGES ON mysql.* FROM 'myuser'@'%' - MaxU

1 answer 1

You can use the program with the HeidiSQL graphical interface or using the query

REVOKE ALL PRIVILEGES ON mysql. * FROM 'newuser' @ 'localhost';

Take all rights to the database from the user. Read more here.

  • It does not work, unfortunately. There is an option to take all rights at once, and then start issuing to the necessary bases, but this does not quite suit me. Perhaps there is a better solution - Philipp