Date: Thu, 10 Mar 2011 14:14:20 -0600 (CST) From: Lars Eighner <portsuser@larseighner.com> To: freebsd-ports <freebsd-ports@freebsd.org> Subject: Re: FreeBSD Port: mysql-server-5.5.9 Message-ID: <alpine.BSF.2.00.1103101401370.5278@abbf.6qbyyneqvnyhc.pbz> In-Reply-To: <NBECLJEKGLBKHHFFANMBIEOICOAA.joeb@a1poweruser.com> References: <NBECLJEKGLBKHHFFANMBIEOICOAA.joeb@a1poweruser.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?alpine.BSF.2.00.1103101401370.5278>