• 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

    • I am using Waterfox Private Search now that I started using the Waterfox browser on my PC and Android. Both work great* search waterfox net with full stops in between. * I have an issue where making comments on articles on various websites is difficult with Waterfox on Android as it randomly adds spaces and doubles up on text.
    • I can't believe it was only two years since the last time MS raised their prices and now they think they can do it again so soon. Of course they needed to backtrack on this. I hope Nintendo is next.
    • I guess I gotta be even more specific then since I'm looking for an absolute confirmation.  The mini PC has never booted up or powered on by me. I'm assuming it'll be like buying a new PC from a store. Nothing is set up. Like absolutely nothing on the mini PC because I can't emphasize this enough. My USB drive already has Windows set up on it from my other desktop so I know it's clean. So now I connect it to the mini PC before it's even booted up or go to the desktop. I then turn on the mini PC and boot into the USB drive. I should see an existing partition. I'll delete it and then install Windows again over the entire drive. I don't necessarily want to create a separate partition. Once it installs and boots to the desktop, I'm assuming the drive is "clean" and free of any malware/viruses. Basically, this process will eliminate any potential for malware/viruses to still somehow hide in the SSD and then potentially affect me later.  I'm being very anal about this because I really don't trust anything bought from AliExpress, but the price was very tempting.  Is Windows Defender reliable? Afterwards, if I do a full scan and it doesn't find anything in the SSD and the USB drive, can I be confident the mini PC is now safe and secured to enter my banking credentials? If not, what else can I do to be absolutely certain?
    • I got an ESR Qi2 vent charger for my car and it's fantastic. It's very strong magnet and holds the phone securely over the worst potholes/roads, and my iPhone does charge. In Summer, the AC blows on the vent keeps and keeps the phone cold. In winter, I just close that vent, so it still stays cold. I agree with you on the Android front. Why not just build in the magnets like Apple does? It's frustrating to buy a case that adds magnets.
    • Hey, I've been using Windows since I was a little tyke. But for the last 15 years, I have been using Linux. I'm using EndeavourOS/Arch atm. wipe it, as in deleting anything from the SSD in the computer. Make a new partition. USB booting device should be free of malware, as long as you download it directly friom MS. Not some XYZ company.
  • Recent Achievements

    • Collaborator
      fernan99 earned a badge
      Collaborator
    • Collaborator
      MikeK13 earned a badge
      Collaborator
    • One Month Later
      Alexander 001 earned a badge
      One Month Later
    • One Month Later
      Antonio Barboza earned a badge
      One Month Later
    • Week One Done
      Antonio Barboza earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      581
    2. 2
      ATLien_0
      216
    3. 3
      Michael Scrip
      168
    4. 4
      Xenon
      136
    5. 5
      +FloatingFatMan
      125
  • Tell a friend

    Love Neowin? Tell a friend!