Date: Sun, 10 Jan 2010 12:08:40 -0700 (MST) From: Warren Block <wblock@wonkity.com> To: jaymax <jaymax36@gmail.com> Cc: freebsd-questions@freebsd.org Subject: Re: Catastrophic Installation Failure now! Message-ID: <alpine.BSF.2.00.1001101159420.78081@wonkity.com> In-Reply-To: <27100257.post@talk.nabble.com> References: <27100257.post@talk.nabble.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Sun, 10 Jan 2010, jaymax wrote: > > MAJOR SCREWUP > > I was frustrated by a failure to create a ROOT password and decided to do a > clean reinstall > Did a "make deinstall" from the following ports > > [i] /usr/ports/databases/mysql54-server > [ii] /usr/ports/databases/mysql54-client > [iii] /usr/ports/databases/mysql54-scripts > > Did a rm of the /etc/my.cnf file (There were no others in related or > relevant areas) FreeBSD standard should be in /usr/local/etc. I don't know mysql, though. > Reinstallation proceeded as follows: > in /usr/ports/databases/mysql54-server ==> > make 'pager=more' 'prompt=mysql54' 'socket=/usr/tmp/mysql.sock' > 'localstatedir=/disk02/db/mysql/DATA' 'with_linuxthreads=yes' 'with_ssl=yes' > install clean & > > in /usr/ports/databases/mysql54-scripts ==> > make install clean > > mysql client apparently installed as a dependency by the server Those are outdated ports, or at least the only thing close in my ports tree is mysql55. > Did the following: > [i] /usr/local/bin/mysql_install_db then > [ii] /usr/local/bin/mysqld_safe & first startup > > Stdout ==> > [1] 37786 > ax# 100110 07:05:36 mysqld_safe Logging to > '/disk02/db/mysql/DATA/ax.lall.com.err'. ... > 100110 7:05:38 [ERROR] Fatal error: Can't open and lock privilege tables: > Can't find file: './mysql/host.frm' (errno: 13) According to some web searching, host.frm is supposed to be created by mysql_install_db. Looking at the log file it created may help; suspect directory ownership or permissions, or maybe it is working in the wrong directory entirely. -Warren Block * Rapid City, South Dakota USA
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?alpine.BSF.2.00.1001101159420.78081>