"GRANT insert,delete,update,select on phonewatch.* to [EMAIL PROTECTED] identified by '<password>'" works. "GRANT insert,delete,update,select on phonewatch.* to datatal identified by '<password>'" do not.
Can someone please test this and verify if it's a bug? > -----Ursprungligt meddelande----- > Från: Nathaniel Mallet [mailto:[EMAIL PROTECTED] > Skickat: den 24 oktober 2003 03:04 > Till: Rory McKinley; Datatal AB - Gauffin, Jonas > Kopia: [EMAIL PROTECTED] > Ämne: RE: GRANT problem > > > I was having the same problems trying to get a user added to > a new DB, so here's are the commands I used: > > GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO > <user>@localhost IDENTIFIED BY '<password>'; FLUSH PRIVILEGES; > > where <user> and <password> are whatever you need it to be. > > I've never had much luck with % as host, so specify localhost > for you user, and you should be all set. > > Nat > > -----Original Message----- > From: Rory McKinley [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 23, 2003 6:21 AM > To: Datatal AB - Gauffin, Jonas > Cc: [EMAIL PROTECTED] > Subject: Re: GRANT problem > > > Ok. > > I'm stumped. If I'm reading the manual correctly, you were > right about not hving to specify the host..the only > difference between your version and the manual is that they > use single quotes around the user name but I can't see how > that makes any difference. I normally just specfiy hosts > because using wildcards for hosts makes me nervous - hey, > even paranoid people have enemies :) > > If anyone knows the answer to this I would be interested in > knowing what it is too > > Sorry 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: "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----- > > Från: Rory McKinley [mailto:[EMAIL PROTECTED] > > Skickat: den 23 oktober 2003 11:56 > > Till: Datatal AB - Gauffin, Jonas > > Ämne: Re: GRANT problem > > > > > > thinking..... > > > > In one of your follow up posts I see that you have the > command as this > > : > > > > C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -pMYPASSWORD > > > > Try > > > > C:\mysql\bin\mysql phonewatch -h ts2test -u datatal -p > > > > And enter password at the prompt > > > > > > 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: "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 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://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED]> forums.net > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
