Have you tried: GRANT INSERT, DELETE, UPDATE, SELECT ON *.* TO <user>@'%' IDENTIFIED BY '<password>'; FLUSH PRIVILEGES;
On Thu, 2003-10-23 at 21:03, Nathaniel Mallet wrote: > 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] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]