Security manager, only show one database.

[kaffeburk]

Hello,

I want a user to have all privileges for one database only. The other databases should not be shown. I'm able to limit so he can not alter them, but i don't want him to see them. How can i make this?

[alexa]

Please see the following sample user with the full access to the sakila database:

Code: Select all

CREATE USER 'testuser'@'%' IDENTIFIED WITH mysql_native_password PASSWORD EXPIRE DEFAULT;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, GRANT OPTION, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE, EVENT, TRIGGER ON sakila.* TO 'testuser'@'%';

SET PASSWORD FOR 'testuser'@'%' = PASSWORD ('11111');

Here is how it will look like: