[webstack-discuss] LSARC/2007/608 create mysql user and group in Solaris

[Martin MC Brown]

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