Re: Adding Users

[Umesh Shastry]

Hi!

[FromDocs]

You can do this by starting mysqld with --skip-show-database option..

--skip-show-database

With this option, the SHOW DATABASES statement is allowed only to users who have the SHOW DATABASES privilege, and the statement displays all database names. Without this option, SHOW DATABASES is allowed to all users, but displays each database name only if the user has the SHOW DATABASES privilege or some privilege for the database.

Also there is an SHOW DATABASE privilge in the GRANT statement..you can prevent users from viewing /using show database command..

take a look at here..

http://dev.mysql.com/doc/mysql/en/grant.html

Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221