List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:June 10 2002 4:19pm
Subject:Re: GRANTs and %
View as plain text  
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
Thread
GRANTs and %Kaan Oglakci10 Jun
  • Re: GRANTs and %Dan Nelson10 Jun