As bizarre as it sounds, it works now.

I thought just on a whim I would try it again.  I scrolled up and used the 
exact same commands as before (without retyping them) and it worked fine.

I don't know what was wrong, but I suspect it may have had something to do 
with the amount of activity of MySQL stuff on my server at the time.

Thanks all for your input!

Mark

At 06:10 PM 5/9/2002 -0500, Mark Shade wrote:
>The command
>
> > mysql -u root -p mysql
>
>is what I used to get in.  That is why I am confused.  I have always gotten
>into MySQL that way before, and done the "granting" with no problems.
>
>I can't get to a shell just now, but I will checkthe myisamchk command as
>soon as I can.
>
>Thanks.
>
>Mark
>
> > Hmm, I am kinda new at this, but what happens if you specifically log
> > into the user database first?
> >
> > mysql -u root -p mysql
> >
> > It could perhaps also mean your database is corrupted somehow; what do
> > you get when you are running this below?
> >
> > /usr/local/bin/myisamchk /var/db/mysql/*/*.MYI
> >
> > (adjust paths to your install, of course).
> >
> > - Mark
> >
> >
> > ----- Original Message -----
> > From: "Mark Shade" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Friday, May 10, 2002 12:16 AM
> > Subject: RE: error granting rights
> >
> >
> >> Yep...
> >>
> >> I am in as root, so I should have rights to everything.
> >>
> >> Yep, I have confirmed that the dbname is right, but doublechecking it
> >> multiple times.  Plus, this happens even on db that I did the same
> >> thing to only a week ago.  The * just says "all tables" as I
> >> understand it.
> >>
> >> And, that is what I am doing - setting up the user.  That is the whole
> >> point.
> >
> >
> > ---------------------------------------------------------------------
> > 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


---------------------------------------------------------------------
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

Reply via email to