• 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

    • To be fair, I haven't seen a BSOD since years ago, seriously. Windows has been pretty stable for me always.
    • Nobody is "shoving" anything down anybody's throats. The feature is turned off by default, so the user needs to explicitly enable it. How is that "shoving down" anything? Again: this is OPT-IN. If you don't like the feature for whatever reason, just ignore it or turn it off if you already enabled it.
    • Kioxia is Toshiba rebranded? Did not know that. 
    • I use to buy only Samsung and Crucial MX but things have change a lot in the last 5 years.   Western Digital Black ssd are very good. Corsair MP too (specially when it comes to gen 5) The Patriot 2TB Viper VP4300 Lite is a good cheap option with decent perf Crucial Txxx is pretty good too. I had bad exp with TeamGroup when they initially came out but i bought two TEAMGROUP T-Force Vulcan Z 2TB SLC Cache for my new computer because they were the cheapest 2 tb with any kind of cache and i've been pleasantly surprised.   You got to do your own research. Does it have dram cache? If yes which type of dram cache. Does it have a large SLC cache? If so how large is it? 20% of the drive? 30% of the drive? For example the TG 2TB i posted above has a 650GB SLC cache which is about 30% of the drive capacity. Is it TLC or QLC. I'd avoid QLC drive without any type of cache unless it's for storage they tend to perform badly with small writes. I'm not an expert so do your own research  https://www.techpowerup.com/ , https://www.tweaktown.com/ and https://www.tomshardware.com/ are usually good sources to know the real spec of a ssd and nvme specially the cache since a lot of manufacturer are not clear about this.
  • Recent Achievements

    • Week One Done
      SmileWorks Dental earned a badge
      Week One Done
    • Community Regular
      vZeroG went up a rank
      Community Regular
    • Collaborator
      Snake Doc earned a badge
      Collaborator
    • Week One Done
      Snake Doc earned a badge
      Week One Done
    • One Month Later
      Johnny Mrkvička earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      582
    2. 2
      Michael Scrip
      199
    3. 3
      ATLien_0
      198
    4. 4
      +FloatingFatMan
      129
    5. 5
      Xenon
      125
  • Tell a friend

    Love Neowin? Tell a friend!