[K12OSN] MySQL installation

[Jim Kronebusch]

I would have to agree with Les, I didn't think of that.  But yeah, that
would be a major pain and require a lot of user training. 

Maybe there is a way to sync local users with the MySQL user base to at
least eliminate a couple steps, then all you would need to do is set
permissions, but I doubt it.


-----Original Message-----
From: k12osn-bounces at redhat.com [mailto:k12osn-bounces at redhat.com] On
Behalf Of Les Mikesell
Sent: Thursday, April 15, 2004 1:41 PM
To: Support list for opensource software in schools.
Subject: RE: [K12OSN] MySQL installation


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



_______________________________________________
K12OSN mailing list
K12OSN at redhat.com https://www.redhat.com/mailman/listinfo/k12osn
For more info see <http://www.k12os.org>