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