Re: [MLUG] file permissions in mysql

[Shawn Parker <EMAIL:PROTECTED>]

mysql has a user account system of its own. the root in mysql is
different from the root in linux. as long as you grant permissions in
mysql to user, he/she can do what ever they want.

it is possible to grant all to any mysql user. this gives them
complete control over the database they are assigned to, or any
database on any host...it just depends on what privileges you grant
them.

log into mysql using root and query the mysql.user table to see how
and what user accounts are set up. usually on a default install it is
4. 2 blank and 2 root...if memory serves me correctly.

true, mysqld is generally run as root initially...and then spawns
child processes as needed. much like apache. especially since in most
cases  you want mysql to start at boot.

i suggest picking up a copy of o'reilly's managing and use mysql. or
at least hitting the website docs to get a better feel for it.

admin'ing mysql is much easier than at first thought, and is sure
easier than designing an efficient, normalized db.

:)

On 5/9/05, Michael <EMAIL:PROTECTED> wrote:
> 
> > I just started trying to use mysql.  I had no idea that it was so
> > complex for a single user.  I guess you have to have mysqld running,
> > and root has to start mysqld.  It also looks like root has to
> > configure mysql user accounts with permissions for various databases.
> > It seems that a user can't just create his own database and control
> > access rights.  Is that correct?  I hope I'm missing something.
> 
> That sounds about right. It's really not as much work as it seems like
> though. If you want something that is more individual then I suggest
> trying SQLlite.
> 
> --
> Michael <EMAIL:PROTECTED>
> http://kavlon.org
> 
> _______________________________________________
> members mailing list
> EMAIL:PROTECTED
> http://mlug.missouri.edu/mailman/listinfo/members
> 


-- 

"You drink the Imp Ale. It's full-bodied and tasty, but you feel a
little guilty about supporting the breweries of the Damned."

_______________________________________________
members mailing list
EMAIL:PROTECTED
http://mlug.missouri.edu/mailman/listinfo/members