This website is deprecated, and remains online only for historic access to old issues and docs for historic versions of Virtualmin. It has been unmaintained for several years, and should not be relied on for up-to-date information. Please visit www.virtualmin.com instead.

Limit Database User to 1 Database

5 posts / 0 new

Topic locked

Last post

#1 Sun, 03/04/2012 - 15:02

jsigned

Limit Database User to 1 Database

I have a virtualmin server with a number of domains. I want to setup a database that is limited to just one user. It's easy to create the database and it's easy to create a database user. But I can't seem to google my way out of how to limit that one user to that one database.

The reason I want to do this is outside developers will be working on that database and I don't want them to have access to anything else.

#2 Sun, 03/04/2012 - 15:06

Locutus

Are you using the Virtualmin or Webmin functions to create the database and user?

#3 Sun, 03/04/2012 - 15:12 (Reply to #2)

jsigned

I've been using the Virtualmin functions. Nothing is live right now so I can do it from either interface. If it matters the database will be used for a WordPress site.

#4 Sun, 03/04/2012 - 16:09

Locutus

Okay, in Virtualmin you can create users inside a virtual server, which can then be assigned database access in the "Other user permissions" section. The user will then have access to just that one database.

(Note though that the virtual server owner account always has access to the databases created for that virtual server, in addition to any users which you manually assign.)

Would that be what you're trying to achieve?

#5 Tue, 03/06/2012 - 22:52

jsigned

Thanks, that is just what I needed. The outside developers can get to the site and database that I want them to, but they are denied access to everything else.

Topic locked