Re: [MLUG] file permissions in mysql

[Shawn Parker <EMAIL:PROTECTED>]

everything you need to know can be found here:
http://dev.mysql.com/doc/mysql/en/index.html

On 5/10/05, Shawn Parker <EMAIL:PROTECTED> wrote:
> 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."
> 


-- 

"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