[EMAIL PROTECTED] wrote:
> I have a MySQL server running with some users besides root, that I want to grant all
> privileges for their own databases, but no rights for anything else.
> So to say, I have a user web01 that shall be able to do whatever he wants with the
> database db01. There are more databases, like db02 etc.
> If user web01 runs a 'SHOW DATABASES' command, he'll get to see ALL databases on the
> server, but I don't want him to see them... When the user does a 'USE <dbname>;', it
> says 'access denied'. There must be some special trick to let him only see the
> database(s) he's got rights on. (At least my webhoster managed that somehow...)
>
> Anyone an idea what rights I have to assign to get this running?
Since 4.0.0 user must have SHOW DATABASES privilege to see databases on with he has no
permissions:
http://www.mysql.com/doc/en/Privileges_provided.html
In 3.23.xx you can run mysqld with --skip-show-database option:
http://www.mysql.com/doc/en/Command-line_options.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
