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

    • Both a game adaptation and it's on Amazon I'll set my hopes low
    • You shut your mouth you young fart, that was just a few years ago, lol.
    • Good effort, but unfortunately not very useful in the real world, since it doesn't support UEFI - which is a major drawback. More than that, most PCs these days have Secure Boot enabled by default, so unless you're tech savvy, the average joe is not going to disable Secure Boot - which means automated Windows > Linux migration programs like this will not work. And if you're tech savvy enough to know how to disable Secure Boot, then you're tech savvy enough to just flash a USB drive and install Linux the usual way - after all, the actual installation process is just point-and-click. So I don't see a use case here to be honest, especially considering the lack of UEFI support - especially when you consider that more and more Linux distros are completely dropping BIOS support (eg Fedora dropped it back in 2022). So this program is a bit too late to the party.
    • I agree with open rights group that the age check companies should be regulated but action does need to be taken imo, they may be called irresponsible parents but the fact is that many don't know how to set up blocks. Why should kids suffer because their parents don't know something? I think the UK has always been a bit like this. We don't say healthcare is your responsibility, we tax everyone and make people register with the NHS. We also don't expect everyone to brush their teeth to maintain dental health, we just put fluoride in their water assuming people aren't brushing enough, because some probably aren't or aren't doing it properly. In general, this way of doing things works.
    • Well that's the weird thing, the UK really isn't a very religious country at all and the same politicians that are backing this (basically all of them) also support things like assisted dying which various religions spoke out against. I don't think this is coming from religion, of course religious groups will support it but I don't think they've started it.
  • Recent Achievements

    • One Month Later
      Falcon.ai earned a badge
      One Month Later
    • Week One Done
      Falcon.ai earned a badge
      Week One Done
    • Dedicated
      EYEREX earned a badge
      Dedicated
    • First Post
      Electronic Person earned a badge
      First Post
    • Week One Done
      CyberCeps666 earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      628
    2. 2
      ATLien_0
      236
    3. 3
      Xenon
      164
    4. 4
      neufuse
      142
    5. 5
      +FloatingFatMan
      123
  • Tell a friend

    Love Neowin? Tell a friend!