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 ON newstesting.* clients@'%' IDENTIFIED BY '123'; ERROR 1064: You have an error in your SQL syntax near 'clients@'%' IDENTIFIED BY '123'' at line 1 any ideas what is going on? MySQL is server version: 3.23.36 Thanks, Kaan --------------------------------------------------------------------- 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