Check the file ownership, and make sure that its the same as the mysql user.
Barry Gold wrote: > I duplicated the mysql database from another machine by copying over the > table files. But now I find myself unable to access the tables. > > I restarted the mysql server using the --skip-grant-tables option. Then > I could access the tables, but the grant command wasn't recognized so I > couldn't just add my root id to the permissions. > > I tried adding myself by inserting rows into the user and host tables, > but it still didn't work. > > Anybody got any ideas? I want to get this cleaned up so I can slave the > new copy to the old one, to act as a backup server. > > --------------------------------------------------------------------- > 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
