SHOW DATABASES is a global privilege. It allows the named user to see (with
SHOW DATABASES) dbs he/she cannot work with. If that's really what you
want, the syntax for your 4th line would be:
GRANT SHOW DATABASES ON *.* TO [EMAIL PROTECTED]
You use *.* instead of OSMS.* because th
ION;
GRANT ALL PRIVILEGES ON OSMS.* TO osms@"%" IDENTIFIED BY 'openipmp' WITH
GRANT OPTION;
GRANT SHOW DATABASES ON OSMS.* TO [EMAIL PROTECTED] IDENTIFIED BY 'openipmp'
WITH GRANT OPTION;
GRANT SHOW DATABASES ON OSMS.* TO [EMAIL PROTECTED] IDENTIFIED BY 'openipm
