----- Original Message ---- From: Jeremy Chadwick <[EMAIL PROTECTED]> To: Drew Jenkins <[EMAIL PROTECTED]> Cc: freebsd-ports@freebsd.org Sent: Thursday, March 1, 2007 4:53:45 PM Subject: Re: Can't Get MySQL Port Up
First up, thank you very much for your detailed analysis and comments. Concerning rebuilding the ports, I don't believe this is necessary because I have the exact same problems on my home server, and I never deleted the /usr/local/include dir on my home server. >So chown mysql:mysql /etc/my.cnf && chmod 600 /etc/my.cnf. Okay, I did that. >You're missing a ton of necessary tables in /var/db/mysql/mysql, which >are all required for MySQL to run. Authentication tables, host access >tables, etc.. > >The MySQL startup script /usr/local/etc/rc.d/mysql-server is supposed to >create all of these tables for you if the /var/db/mysql/mysql directory >does not exist (otherwise if it does, it assumes all the necessary >tables exist). The script that creates all the necessary tables is >/usr/local/bin/mysql_install_db and it comes from the MySQL guys. The >script is also supposed to fix permissions on /var/db/mysql and friends >-- so the fact that your mysql directory was not fixed up means this >script didn't run at all, or bailed out for some reason. No, I have a ton of files in said dir. >Before you installed the port, did you have an existing /var/db/mysql >directory? No. This is (was) a clean build. >If not, then I'm stumped. Don't be. You led me to realize the ownership of /var/db/mysql/mysql was wrong :0 Changed it, cracked it up, and away she went! Thanks! Drew ____________________________________________________________________________________ 8:00? 8:25? 8:40? Find a flick in no time with the Yahoo! Search movie showtime shortcut. http://tools.search.yahoo.com/shortcuts/#news _______________________________________________ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to "[EMAIL PROTECTED]"
