[K12OSN] MySQL installation
Jim Kronebusch
jim at winonacotter.org
Thu Apr 15 18:51:29 UTC 2004
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>
More information about the K12OSN
mailing list