Re: GRANT ANNOYANCE REVISITED
> >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 Bonjour, Are root privileges really established? I had that error message once a day. If root password is not set, in extenso there is no root, you cannot use GRANT statement. Have a look in mysql.user table to see check for root password. jean-michel - 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
RE: GRANT ANNOYANCE REVISITED
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 >> >> >>!!&#(%&@(#&%@(&% G... >> >>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
THANKS! RE: GRANT ANNOYANCE REVISITED
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
RE: GRANT ANNOYANCE REVISITED
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. -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 > > >!!&#(%&@(#&%@(&% G... > >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
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
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 > > >!!(%&@(#&%@(&% G... > >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