> 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:[EMAIL PROTECTED] > >>Skickat: den 24 oktober 2003 15:11 > >>Till: Datatal AB - Gauffin, Jonas > >>Kopia: [EMAIL PROTECTED] > >>Ä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. > >>> > >>> > >>> > >>> > >>> > >> > >> > >> > > > > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]