At 7:21 PM -0500 7/13/01, Mike<mickalo>Blezien wrote:
>thanks for the info. So if I'm ready this correctly, I would log
>into the server
>under my UNIX account, not as root, do the install of the server/client Mysql,
>create the new user/group, which would make me part of the new
>start the server under this user/group. Is this correct??
Not really. You have to be root to create the new user/group, for example.
And creating it doesn't make you part of that user/group.
Or I may just not be understanding you. Here's one way to do it:
- As the UNIX root user, create the user/group that you intend to use
for running the MySQL server
- Log in as that user and build/install MySQL. (By doing this as that
user, all the files will be owned by that user.)
- Start the server, either as that user, or as root. In the latter case,
specify the --user=xxx flag where xxx is the account you want to use for
running the server.
There are other variations, such as installing everything as root.
In this case, you may have to change the ownership of the stuff in
the data directory to the non-root account or the server won't be able
to access database files when you run the server as that user.
>>>On Fri, 13 Jul 2001 19:14:48 -0500, Paul DuBois <paul@stripped>
>>>>I'm a bit confused on this issue of installing MySQL and creating
>>>>user/group ownership. Now I've read thru many resources, and it
>>>>installing MySQL as root, or is this incorrect??
>>>That's correct, you don't want to run the server as root.
>>>>Is it better to create the new user/groups, then install MySQL under
>>>>user/groups or install MySQL as root, then after the install,
>>>>create the new
>>>>user/groups before starting the MySQL server after the install??
>Thunder Rain Internet Publishing
>Providing Internet Solutions that work!
Paul DuBois, paul@stripped