• 0

hide databases to a user in mysql


Question

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!

Link to comment
https://www.neowin.net/forum/topic/43240-hide-databases-to-a-user-in-mysql/
Share on other sites

9 answers to this question

Recommended Posts

  • 0

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. :(

  • 0

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...

  • 0

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

  • 0

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?

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.