Kaan, Tuesday, June 11, 2002, 11:04:36 AM, you wrote: KO> Thanks Dan And Okan for replying to my email but I have tried what you have KO> said but I still get the same problem.
KO> GRANT ALL ON newstesting.* 'clients'@'%' IDENTIFIED BY '123'; KO> ERROR 1064: You have an error in your SQL syntax near ''clients'@'%' KO> IDENTIFIED KO> BY '123'' at line 1 KO> GRANT ALL ON newstesting.* clients@'%' IDENTIFIED BY '123'; KO> ERROR 1064: You have an error in your SQL syntax near 'clients@'%' KO> IDENTIFIED BY KO> '123'' at line 1 KO> any ideas what is going on? You used a wrong GRANT syntax. You are missing 'TO' before user name. GRANT ALL ON newstesting.* TO 'clients'@'%' IDENTIFIED BY '123'; ^^^^^^ KO> MySQL is server version: 3.23.36 KO> Thanks, KO> Kaan -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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