Re: [Sheflug] MySQL access

[Craig Andrews <xxxxx [at] xxxxxxxxxxxxxx>]

Check out the mysql manual about the grant command. The easiest (although
least secure) way to set yourself up is as follows:

grant all on <database>.* to <username> [at] localhost identified by
'<password>';

This will give you complete access to <database> on the local machine. To
use a different machine, use that machines name, or "%" for all hosts.

The manual will describe the various permissions available.

Craig


On Sat, 10 Nov 2001, Ruth Gunstone wrote:

> In message
> <Pine.LNX.4.33.0111091446070.19946-100000 [at] webtech25.hq.insight.com>
>           Craig Andrews <candrews [at] fishbot.org.uk> wrote:
>
> > Did you modify the user table with grant or update?
> >
> [snip]
>
> I used 'insert into user ..(etc)' to add these details to the db
> > >
> > > Host        | User      | Password	 . . . (lots of priv options)
> > > gallifrey   | ruthie    | wibble        . . .(all set to 'Y')
> > >
> [snip]
>
>
>
> --
> Ruth Gunstone          (ruth at bolsterstone dot demon dot co dot uk)
>
>  /====================================================\
>  ||  Web-Site: http://www.bolsterstone.demon.co.uk/  ||
>  \====================================================/
> ___________________________________________________________________
>
> Sheffield Linux User's Group - http://www.sheflug.co.uk .
> To unsubscribe from this list send mail to
> shef-lug-request [at] list.sheflug.org.uk with the word
> "unsubscribe" in the body of the message.
>
>   GNU the choice of a complete generation.
>
>

___________________________________________________________________

Sheffield Linux User's Group - http://www.sheflug.co.uk . 
To unsubscribe from this list send mail to 
shef-lug-request@list.sheflug.org.uk with the word
"unsubscribe" in the body of the message. 

  GNU the choice of a complete generation.