At 1:31 PM -0500 6/13/01, David Simcik wrote:
>Nope, it says version 3.23.38. However, I should point out that I started
>the service (under NT) with the --skip-grant-tables option enabled. Was
>locked out of my database when I updated my password manually using a SQL
>Update on the User table, so I am trying to change that using the method
>described on page 421 of your book to get around that.
Huh! Looks like --skip-grant-tables disables the GRANT command.
You can still update the mysql.user table by manipulating it directly:
mysql> UPDATE user SET password=PASSWORD('abc') WHERE User='root'
-> AND Host='whichever host you want to match';
>-----Original Message-----
>From: Paul DuBois [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, June 13, 2001 10:47 AM
>To: David Simcik; Mysql
>Subject: Re: GRANT ANNOYANCE REVISITED
>
>
>At 10:16 AM -0500 6/13/01, David Simcik 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
>>
>>
>>!!&#(%&@(#&%@(&% Grrrrrrrr...
>>
>>Where have I gone wrong???
>
>Server version is older than 3.22.11?
>
>
>>
>>
>>Thanks again,
>>David
>
>
>--
>Paul DuBois, [EMAIL PROTECTED]
>
>---------------------------------------------------------------------
>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
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
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
