SV: GRANT problem

2003-10-24 Thread Datatal AB - Gauffin, Jonas
Message - From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] To: Rory McKinley [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 12:05 PM Subject: SV: GRANT problem it works if I specify the host. Why doesn't % work as host? -Ursprungligt meddelande

SV: GRANT problem

2003-10-24 Thread Datatal AB - Gauffin, Jonas
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:

Re: SV: GRANT problem

2003-10-24 Thread gerald_clark
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.

SV: SV: GRANT problem

2003-10-24 Thread Datatal AB - Gauffin, Jonas
: 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

Re: SV: SV: GRANT problem

2003-10-24 Thread gerald_clark
. -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

SV: SV: SV: GRANT problem

2003-10-24 Thread Datatal AB - Gauffin, Jonas
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

SV: GRANT problem

2003-10-23 Thread Datatal AB - Gauffin, Jonas
Additional info: the user is added to mysql.user with no privileges. the user is added to mysql.db with insert,update,delete,select privileges on phonewatch db. When I try to connect to the db, C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -pMYPASSWORD, I get ERROR 1045: Access denied

SV: GRANT problem

2003-10-23 Thread Datatal AB - Gauffin, Jonas
doesn't read the privileges-Table again. mfg Klaus -Ursprungligt meddelande- Från: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED] Skickat: den 23 oktober 2003 10:44 Till: [EMAIL PROTECTED] Ämne: SV: GRANT problem Additional info: the user is added to mysql.user

SV: GRANT problem

2003-10-23 Thread Datatal AB - Gauffin, Jonas
Not sure if this will help - in your GRANT statement do you not need to specify a host for the user e.g. GRANT.. to datatal @ your_host_name.?. GRANT uses % as host if none is specified. % = all hosts. any other ideas? -- MySQL General Mailing List For list archives:

SV: GRANT problem

2003-10-23 Thread Datatal AB - Gauffin, Jonas
kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] To: Rory McKinley [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 11:45 AM Subject: SV: GRANT problem Not sure