Re: MYSQL Fresh Reinstall, How?

2003-08-29 Thread Aaron Wohl
Yeah I ran into that yesterday myself. The mysql_install_db doesnt leave you with a working mysql database lately. What did to fix it was mysqld -u mysql --skip-grant (Im assuming you have your mysql firewalled off, if not do that first ;) At that point mysql is up enough to restore the mysql

Re: MYSQL Fresh Reinstall, How?

2003-08-29 Thread Jez Hancock
On Fri, Aug 29, 2003 at 02:52:56AM -0400, Ben Dover wrote: I managed to mess up my MYSQL4.1 on my 5.1 box and I can't seem to get it straightened out. I think the best way to resolve this would be to do a fresh install of MYSQL server. I did a pkg_delete of MYSQL-server and client and

Re: MYSQL Fresh Reinstall, How?

2003-08-29 Thread Aaron Wohl
If you rm -rf /var/db/msyql then reinstall it doesnt work right now is the problem... at least on freebsd. It gives the host.frm error the poster asked about. Ive only been able to get a new system going by restoring the mysql database (/var/db/mysql/mysql) from elsewhere. On Fri, 29 Aug 2003

Re: MYSQL Fresh Reinstall, How?

2003-08-29 Thread Jez Hancock
On Fri, Aug 29, 2003 at 03:04:07AM -0600, Aaron Wohl wrote: If you rm -rf /var/db/msyql then reinstall it doesnt work right now is the problem... at least on freebsd. It gives the host.frm error the poster asked about. Ive only been able to get a new system going by restoring the mysql

Re: MYSQL Fresh Reinstall, How?

2003-08-29 Thread Jack L. Stone
At 02:52 AM 8.29.2003 -0400, Ben Dover wrote: I managed to mess up my MYSQL4.1 on my 5.1 box and I can't seem to get it straightened out. I think the best way to resolve this would be to do a fresh install of MYSQL server. I did a pkg_delete of MYSQL-server and client and installed again

Re: MYSQL Fresh Reinstall, How?

2003-08-29 Thread Ben Dover
[EMAIL PROTECTED] To: Ben Dover [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: Re: MYSQL Fresh Reinstall, How? Date: Fri, 29 Aug 2003 02:22:08 -0600 Yeah I ran into that yesterday myself. The mysql_install_db doesnt leave you with a working mysql database lately. What did to fix it was mysqld -u