Re: [Sheflug] MySQL access

[Craig Andrews <xxxxx [at] xxxxxxxxxxxxxx>]

Did you modify the user table with grant or update?

Craig

On Fri, 9 Nov 2001, Ruth Gunstone wrote:

> Hi all,
>
> Could anyone tell me how I set-up rights for user 'ruthie' to create and
> modify a database in MySQL?
>
> I've tried modifying the 'user' table:
>
> Host        | User      | Password	 . . . (lots of priv options)
> gallifrey   | ruthie    | wibble        . . .(all set to 'Y')
>
> The command: create database mystuff;
>
> results in:
> Access denied for user: ' [at] localhost' to database 'mystuff'
>
> MySQL server sits on the Linux box 'mondas', and I telnet in from
> 'gallifrey', but it makes no difference if I use a terminal on the Linux box.
>
>
> Baffled, of Sheffield!
>
>

___________________________________________________________________

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.