On Tuesday 11 Jun 2002 11:04 am, Kaan Oglakci wrote: > Thanks Dan And Okan for replying to my email but I have tried what you have > said but I still get the same problem. > > GRANT ALL ON newstesting.* 'clients'@'%' IDENTIFIED BY '123'; > ERROR 1064: You have an error in your SQL syntax near ''clients'@'%' > IDENTIFIED > BY '123'' at line 1
GRANT ALL PRIVILEGES ON newstesting.* TO 'clients'@'%' IDENTIFIED BY '123'; You're missing the 'TO'. Cheers, Markus -- Markus Lervik Linux-administrator Vaasa City Library - Regional Library, Finland [EMAIL PROTECTED] +358-6-325 3589/+358-40-832 6709 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php