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