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 _______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"