• 0

hide databases to a user in mysql

Asked by Tim Dorr,

 Share

Question

Grand Master

Tim Dorr Veteran

Posted
  • Veteran
Posted

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
Enthusiast

Plonky

Posted
Posted

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
Grand Master

Tim Dorr Veteran

Posted
  • Author
  • Veteran
Posted

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
Enthusiast

CitruS

Posted
Posted

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
Grand Master

Tim Dorr Veteran

Posted
  • Author
  • Veteran
Posted

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.
 Share
Go to question listing

  • Recently Browsing   0 members

    • No registered users viewing this page.

  • Posts

    • UK enforces strict new online age checks today

      By zikalify · Posted

      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.
    • UK enforces strict new online age checks today

      By zikalify · Posted

      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.
    • Cable box with tv converter

      By Jim K · Posted

      No.  The only thing you'll be able to capture with that is via antenna (your local NBC, CBS, etc) or if you had a regular cable box you could capture ClearQAM channels (if they are still a thing...probably not though).  Everything else will have encryption which those capture cards aren't meant for.   So yeah...you'll need Verizon's DVR (sucks if you have to pay for it).
    • AdGuard is yet another app to block Windows Recall

      By Brian Miller · Posted

      I've gotta say Microsoft has lost the plot a long, long, long time ago.
    • UK enforces strict new online age checks today

      By Brian Miller · Posted

      How is it be technically implemented, I mean if you wanted to include this let's say on this website, at what point do you interrupt the user flow and say yo! Show me your ID or get the hell out? Please go into extreme technical detail. Is it using a third-party, how much information does neowin receive from that third-party, at what point would that information be abused? We all know it would be abused. So hypothetically what would neowin receive from that third-party company?

  • 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
      235
    3. 3
      Xenon
      164
    4. 4
      neufuse
      142
    5. 5
      +FloatingFatMan
      123
    Show More

  • Tell a friend

    Love Neowin? Tell a friend!