SV: SV: SV: GRANT problem

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

Re: SV: SV: GRANT problem

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

SV: SV: GRANT problem

2003-10-24 Thread Datatal AB - Gauffin, Jonas
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 @'%&#x

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 @'%' IDENTIFIED BY ''; FLUSH PRIVILEGES; yes. no diffrence. Specifying '%' or no host doesn't work for me. -- MySQL

SV: GRANT problem

2003-10-23 Thread Datatal AB - Gauffin, Jonas
> > GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO @'%' > IDENTIFIED BY ''; 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 PROTEC

SV: GRANT problem

2003-10-23 Thread Datatal AB - Gauffin, Jonas
ry I can't be of more help > > Rory McKinley > Nebula Solutions > +27 82 857 2391 > [EMAIL PROTECTED] > "There are 10 kinds of people in this world, > those who understand binary and those who don't" (Unknown) > - Original Message - > From: &

SV: GRANT problem

2003-10-23 Thread Datatal AB - Gauffin, Jonas
Jonas" <[EMAIL PROTECTED]> > To: "Rory McKinley" <[EMAIL PROTECTED]> > Sent: Thursday, October 23, 2003 11:45 AM > Subject: SV: GRANT problem > > > > Not sure if this will help - in your GRANT statement do you > > not need to specify a h

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: http://

SV: GRANT problem

2003-10-23 Thread Datatal AB - Gauffin, Jonas
a 'FLUSH PRIVILEGES' after the GRANT-Statement ? > If not, MySQL-Srver doesn't read the privileges-Table again. > > mfg > Klaus > > -Ursprungligt meddelande- > Från: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED] > Skickat: den 23

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