From: Christian Mack
Date: April 8 1999 7:57pm
Subject: Re: Beginners - Privilage Setup Problem
List-Archive: http://lists.mysql.com/mysql/1543
Message-Id: <370D0A1A.4BD00E04@compal.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Jon Halton wrote:
> 
> First of all thank you to everyone who helped me yesterday with my Load Data
> Infile problems. That has now been solved. As you can probably tell I am
> very new to MySql and am now having problems setting up the privilege
> system. I don't expect a full explanation, but would appreciate a few
> pointers.
> 
> The host table already includes the following:
> 
> Host       Db Select Insert Update Delete Create Drop
> localhost   %   Y     Y       Y      Y      Y     Y
> 
> The User table includes
> 
> Host         User   Password Select ....
> localhost   admin      Y       Y   Y Y Y Y Y Y Y Y
> localhost              N       N   N N N N N N
> 
> The DB table includes
> 
> Host  Db          User Select Insert Update Delete Create Drop
>  %   test               Y      Y      Y      Y      Y     Y
>  %   test\_%            Y      Y      Y      Y      Y     Y
>  %   petholidays  admin Y      Y      Y      Y      Y     Y
> 
> I cant connect to the petholidays database using the admin user. What am I
> not setting correctly?
> 
> Thanks for your help

Hi Jon

Your user 'admin' is only allowed to connect from localhost.
So you need to add a line into the User table:
Host         User   Password Select ....
%            admin      Y       N   N N N N N N N N 

Tschau
Christian