List:General Discussion« Previous MessageNext Message »
From:Jonas Datatal AB - Gauffin Date:October 24 2003 2:15pm
Subject:SV: SV: SV: GRANT problem
View as plain text  
> Use  'localhost' as the host unless you are specifying the 
> grant to be 
> for users on another machine.
> '%'  stands for all machines except 'localhost'.

I know. And the is exactly what I want.

> 
> Datatal AB - Gauffin, Jonas wrote:
> 
> >I get access denied (from mysql.exe and myodbc) when 
> specifying no host 
> >or % as host in the grant statement.
> >
> >  
> >
> >>-----Ursprungligt meddelande-----
> >>Från: gerald_clark [mailto:gerald_clark@stripped]
> >>Skickat: den 24 oktober 2003 15:11
> >>Till: Datatal AB - Gauffin, Jonas
> >>Kopia: mysql@stripped
> >>Ämne: Re: SV: GRANT problem
> >>
> >>
> >>What do you mean by ' doesn't work ' ?
> >>Have you tried connecting from another machine?
> >>
> >>Datatal AB - Gauffin, Jonas wrote:
> >>
> >>    
> >>
> >>>>GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO <user>@'%' 
> IDENTIFIED 
> >>>>BY '<password>'; FLUSH PRIVILEGES;
> >>>>
> >>>>   
> >>>>
> >>>>        
> >>>>
> >>>yes. no diffrence. Specifying '%' or no host doesn't work for me.
> >>>
> >>> 
> >>>
> >>>      
> >>>
> >>
> >>    
> >>
> >
> >
> >  
> >
> 
> 
> 
> 
Thread
SV: SV: SV: GRANT problemJonas Datatal AB - Gauffin24 Oct