I would like to thank everyone who gave suggestions about how to fix the mysql privileges. Here's what we did: We did a mysqldump on the mysql table on the old machine. We brought the mysqldump into the mysql table on the new machine We ran mysql_fix_privilege_tables We gave the command flush privileges Everything worked perfectly after that. Thanks again to everyone who helped. --
Malka Cymbalista Webmaster, Weizmann Institute of Science [EMAIL PROTECTED] 08-934-3036 >>> On 3/19/2008 at 6:10 PM, in message <[EMAIL PROTECTED]>, Sebastian Mendel <[EMAIL PROTECTED]> wrote: > Brown, Charles schrieb: >> Here is a follow-up question: Using mysqldump, I'm about to dump all >> databases and import to another instance - new . My question is do I >> need to define all security and users in the new mysql or the security >> definitions and privileges will be included in the dump file created by >> mysqldump. > > i am not sure if mysqldump does include `mysql` database, but you will see > if you look into it, > > you should run mysql_fix_privilege_tables after importing `mysql` database > > and FLUSH PRIVILEGES; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
