Thanks to all of those who lent their advice. Seems that when you initialize
MySQL using the --skip-grant-tables option enabled, it disallows the ability
to use the GRANT command. I guess that makes perfect sense. I also forgot
the use the PASSWORD() function when I used SQL to update my root account
before. Anyhow, I updated my account using good ol' SQL, restarted the MySQL
instance (sans the option), reloaded the tables just in case, logged in and
used GRANT to my hearts content.
Thanks again,
DTS
-----Original Message-----
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 11:15 AM
To: David Simcik
Cc: Mysql
Subject: Re: GRANT ANNOYANCE REVISITED
Hello.
On Wed, Jun 13, 2001 at 10:16:36AM -0500, [EMAIL PROTECTED] wrote:
> Thank you all for your original suggestions, but I'm still having
problems.
> I copied this verbatim from the MySQL docs and tried it on two seperate
> servers:
>
> mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%"
> -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
> ERROR 1047: Unknown command
It seems that you use a MySQL version which doesn't support
GRANT/REVOKE. These commands were introduced in MySQL 3.22.11
according to the change history
(http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News-3.
23.x)
Bye,
Benjamin.
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
