From: Sebastian Mendel (listssebastianmendel.de)
Date: Wed Mar 19 2008 - 11:10:47 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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;

--
Sebastian

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]