Re: SV: SV: GRANT problem

[gerald_clark]

Use  'localhost' as the host unless you are specifying the grant to be 
for users on another machine.
'%'  stands for all machines except 'localhost'.

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]