[K12OSN] MySQL installation

Les Mikesell les at futuresource.com
Thu Apr 15 18:40:36 UTC 2004

On Thu, 2004-04-15 at 13:00, Jim Kronebusch wrote:
> I see nobody has responded yet, and I am no expert, but here is what I
> think I know.
> In my experience MySQL has its own set of users independent of the OS.
> Each user is assigned by Database administrators manually and the
> permissions for each user are individually assigned to each database,
> table, etc.  In my opinion I wouldn't think that you could give a
> separate instance of MySQL to each individual user with full control
> over it and have it reside in their user folder just because of how it
> is structured and handles permissions.  I may of course be way out of
> line with my answer.  Good luck.

It should be possible to run multiple instances of mysql, each started
with a different my.cnf location specified on the command line and
the my.cnf specifying different locations for the data directory and
socket and a different tcp port number for access.   However it is
probably not worth the trouble compared to having someone create all
the users in the system mysql and a few databases that they can control.

  Les Mikesell
    les at futuresource.com

More information about the K12OSN mailing list