From: Dan Nelson
Date: June 10 2002 4:19pm
Subject: Re: GRANTs and %
List-Archive: http://lists.mysql.com/mysql/111503
Message-Id: <20020610161941.GA53051@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jun 10), Kaan Oglakci said:
> Hi, 
> For some reason when I try to set up grants for a database by typing this
> GRANT ALL ON newstesting.* to clients@%  IDENTIFIED BY 'pass';
> 
> I get this error
> ERROR 1064: You have an error in your SQL syntax near '%  IDENTIFIED BY
> 'pass'' a
> t line 1

Try quoting the %:   '%'

In fact, to be safe, I always quote the username and the hostname:
'clients'@'%'

-- 
	Dan Nelson
	dnelson@stripped