Catastrophic Installation Failure now!

[Warren Block]

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