hi, I am working on Mysql Database. I am facing following problem while trying to grant permission after login as administrator mysql Ver 9.16 Distrib 3.21.33b, for pc-linux-gnu (i586) server version: 3.21.33b-log mysql> grant all on temp.* to ravi@localhost identified by 'ravi'; ERROR 1064: parse error near '* to ravi@localhost identified by 'ravi'' at line 1 mysql> grant all on temp.* to ravi@localhost identified by "ravi"; ERROR 1064: parse error near '* to ravi@localhost identified by "ravi"' at line 1 mysql> GRANT ALL ON temp.* to ravi@localhost IDENTIFIED BY "ravi"; ERROR 1064: parse error near '* to ravi@localhost IDENTIFIED BY "ravi"' at line 1 What does it mean? and how to correct it. I don't have any other problem in manupulating the data in exiting database. Thanking you in anticipation. Ravi
