At 4:43 PM -0500 09-13-2000, Jonathan D. Hoover wrote:
>It is version 3.20.32a as shown below by mysqladmin:
>
>Server version 3.20.32a
>Protocol version 9
>Connection Localhost via UNIX socket
>TCP port 3306
>UNIX socket /var/lib/mysql/mysql.sock
>Uptime: 2 hours 29 min 31 sec
That's why the statement doesn't work. The syntax you are using
was added in 3.22.11.
>
>-----Original Message-----
>From: Paul DuBois [mailto:paul@stripped]
>Sent: Wednesday, September 13, 2000 4:00 PM
>To: jon.hoover@stripped
>Cc: mysql@stripped
>Subject: Re: Basic User Add Form Manual Section 6.13
>
>
>>Any ideas why I get the following parse error after executing the command
>in
>>Section 6.13 of the MySQL manual?
>>
>>[jdhoover@sqltest bin]$ mysql --user=root mysql
>>Welcome to the mysql monitor. Commands ends with ; or \g.
>>Type 'help' for help.
>>
>>mysql> GRANT ALL PRIVILEGES ON *.* to jdhoover@localhost IDENTIFIED BY
>>'blahblah' with GRANT OPTION;
>>ERROR: parse error near '*.* to jdhoover@localhost IDENTIFIED BY 'blahblah'
>>with GRANT OPTION' at line 1
>
>Is your version of MySQL older than 3.22.11?
--
Paul DuBois, paul@stripped
