From: Johan De Meersman
Date: March 16 2012 9:59pm
Subject: Re: how to sync mysql.user table between to two mysql instances
List-Archive: http://lists.mysql.com/mysql/227000
Message-Id: <c30bb5ce-5fdb-4aef-8594-71c77e1f86fe@zimbra>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

----- Original Message -----
> From: "Baron Schwartz" <baron@stripped>
> 
> 1. With mysqldump. mysqldump -hmysql-inst1 mysql | mysql
> -hmysql-inst2 mysql

And then, of course, issue a FLUSH PRIVILEGES on mysql-inst2 :-)


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel