hide databases to a user in mysql

[Tim Dorr Veteran]

I've got a user I'm adding to my mysql server that I want to be able to create databases himself and do what he wants to them, but i don't want him to be able to see or drop the other databases on the server. Any way of doing this? Cause I'm not seeing it....

Thanks!

[Plonky]

i don't know much, but i do know that in Linux, you can get most of the configuration options through webmin. (i just found out today).

Load webmin by typing 'webmin' without the '. If webmin is installed it should work. if it isn't, install it ;).

If you are talking about windows, i can't help you, sorry. :(

[ChoaticWhisper]

I think thats possible, I use MySQL Front(windows)

[Tim Dorr Veteran]

i've tried with MySQL Front (which I also use)

does webmin give the SQL command it issues to do this? cause it's all done through SQL anyways....

[ChoaticWhisper]

Webmin doesnt show what command it used to do something.

You mean like MyPHPadmin does?

[Tim Dorr Veteran]

well, i've tried giving this user (yes, you, xcalibur, if you must know :p ) CREATE and SELECT rights globally and full rights to their own database. However, they can SHOW DATABASE and DROP DATABASE for some reason... So, I dunno...

[john smith 1924 Veteran]

in phpmyadmin config.inc.php you can set it to only access x database. you can also set various other admin rights/ permissions.

[Tim Dorr Veteran]

no, i need to do this on the server, not via phpmyadmin, becuase they can get at the config.inc.php file, plus, i'm going to give them access to their IP...

[CitruS]

This is very simple. I have only read some posts so I dont know if this has already been said

Because I host a hosting business this I should know (shameless advertisement: Swirldot.com)

When mysql is installed, the database will have a mysql database. This should never be removed. The key tables you will want to add data to are 'host, user, db'

If you view the structure of the database, its self explanatory. BTW, the password stored in the table 'user' uses PASSWORD('') in mysql. The structures of the tables in database 'mysql' should not be altered

[Tim Dorr Veteran]

well, i have done that, but i don't know what I should have to do to get it set right. yes, i have done a FLUSH PRIVLEGES... this is the data in CSV format:

localhost,xcalibur,PASSWORD,Y,N,N,N,Y,N,N,N,N,N,N,N,N,N

any idea?