On 24 Jan 2008, at 17:28, James Gates wrote: > Looking at the default /etc/passwd issued with Nevada, uid 27 is free. > These are the uid's (below 100) curently allocated: > > 0 1 2 3 4 5 9 15 25 37 50 71 80 90 95 > > I searched the mysql website, but it doesn't seem to make any > recommendations about uids & gids.
We don't make recommendations on uid/gid because it doesn't matter as long as it doesn't conflict :) It's possible that we could argue about synergy across NFS mounts, but we *really* don't recommend providing any of the files that really rely on the uid/gid (i.e. mainly the database files in the configured datadir) over NFS for performance, lock and stability reasons. When I last updated the documentation the basic advice was create a group and then a user (using useradd/adduser) and just make sure you use that when changing ownership. I've already agreed with Jan that I'll update the documentation for MySQL accordingly. In this instance, I can make the recommendation based on what is automatically created so that those using OpenSolaris and installing MySQL on existing environments can synchronize. MC (also mc at mysql.com) -- Martin 'MC' Brown, mc at mcslp.com Everything MCslp: http://planet.mcslp.com