Date: Thu, 1 Mar 2007 14:21:21 -0800 (PST) From: Drew Jenkins <drewjenkinsjr@yahoo.com> To: freebsd-ports@freebsd.org Subject: Re: Can't Get MySQL Port Up Message-ID: <293676.56569.qm@web62210.mail.re1.yahoo.com>
next in thread | raw e-mail | index | archive | help
----- Original Message ----=0AFrom: Jeremy Chadwick <koitsu@FreeBSD.org>=0A= To: Drew Jenkins <drewjenkinsjr@yahoo.com>=0ACc: freebsd-ports@freebsd.org= =0ASent: Thursday, March 1, 2007 4:53:45 PM=0ASubject: Re: Can't Get MySQL = Port Up=0A=0AFirst up, thank you very much for your detailed analysis and c= omments. 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 dele= ted the /usr/local/include dir on my home server.=0A=0A>So chown mysql:mysq= l /etc/my.cnf && chmod 600 /etc/my.cnf.=0A=0AOkay, I did that.=0A=0A=0A>You= 're missing a ton of necessary tables in /var/db/mysql/mysql, which=0A>are = all required for MySQL to run. Authentication tables, host access=0A>table= s, etc..=0A>=0A>The MySQL startup script /usr/local/etc/rc.d/mysql-server i= s supposed to=0A>create all of these tables for you if the /var/db/mysql/my= sql directory=0A>does not exist (otherwise if it does, it assumes all the n= ecessary=0A>tables exist). The script that creates all the necessary table= s is=0A>/usr/local/bin/mysql_install_db and it comes from the MySQL guys. = The=0A>script is also supposed to fix permissions on /var/db/mysql and frie= nds=0A>-- so the fact that your mysql directory was not fixed up means this= =0A>script didn't run at all, or bailed out for some reason.=0A=0ANo, I hav= e a ton of files in said dir.=0A=0A>Before you installed the port, did you = have an existing /var/db/mysql=0A>directory? =0A=0ANo. This is (was) a cle= an build.=0A=0A>If not, then I'm stumped. =0A=0ADon't be. You led me to re= alize the ownership of /var/db/mysql/mysql was wrong :0 Changed it, cracked= it up, and away she went!=0AThanks!=0ADrew=0A=0A=0A=0A=0A=0A=0A =0A_______= ___________________________________________________________________________= __=0A8:00? 8:25? 8:40? Find a flick in no time =0Awith the Yahoo! Search mo= vie showtime shortcut.=0Ahttp://tools.search.yahoo.com/shortcuts/#news
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?293676.56569.qm>