From owner-freebsd-ports@FreeBSD.ORG Thu Mar 10 20:45:57 2011 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id A3C8C1065672 for ; Thu, 10 Mar 2011 20:45:57 +0000 (UTC) (envelope-from lars@larseighner.com) Received: from mail.team1internet.com (mail.team1internet.com [216.110.13.10]) by mx1.freebsd.org (Postfix) with ESMTP id 855FB8FC14 for ; Thu, 10 Mar 2011 20:45:57 +0000 (UTC) Received: from larseighner.com (unknown [216.110.13.95]) by mail.team1internet.com (Postfix) with SMTP id 1041B16B4B4 for ; Thu, 10 Mar 2011 14:14:47 -0600 (CST) Received: by larseighner.com (nbSMTP-1.00) for uid 1001 lars@larseighner.com; Thu, 10 Mar 2011 14:14:21 -0600 (CST) Date: Thu, 10 Mar 2011 14:14:20 -0600 (CST) From: Lars Eighner X-X-Sender: lars@noos.6dollardialup.com To: freebsd-ports In-Reply-To: Message-ID: References: User-Agent: Alpine 2.00 (BSF 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Subject: Re: FreeBSD Port: mysql-server-5.5.9 X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 10 Mar 2011 20:45:57 -0000 On Thu, 10 Mar 2011, joeb wrote: > I have been using mysql since fbsd 7.2 and always just issued the > mysql_install_db command on the command line to create mysql's control > databases and it always worked fine. > > But now with fbsd 8.2 I get the following error and have no idea why. > I installed using pkg_add -r mysql55-server command. > > I see that 3 weeks ago you updated the mysql55-server port from mysql 554 > to 559. I believe there is an error in your update causing the > mysql_install_db command to error out. The error message follows. > > > # /usr/local/bin >mysql_install_db --user=mysql or > #root >mysql_install_db --user=mysql I'm not sure I follow this, but if you have an existing db, the command to issue IMMEDIATELY after updating mysql is mysql_upgrade. (see man mysql_upgrade). If mysql_upgrade it not necessary (for example in a reinstall) it will say so harmlessly. Error messages you may get if you fail to mysql_upgrade, in my experience, vary from not pertinent to completely misleading. -- Lars Eighner http://www.larseighner.com/index.html 8800 N IH35 APT 1191 AUSTIN TX 78753-5266