Date: Mon, 8 Sep 2008 15:55:40 -0400 From: Joe Tseng <joe_tseng@hotmail.com> To: <freebsd-questions@freebsd.org> Subject: RE: Can't start MySQL 5.0.67 Message-ID: <BAY117-W4BE18FE32381C854A29FF9B550@phx.gbl> In-Reply-To: <200809081146.06240.beech@freebsd.org> References: <20080908162020.QYGI28383.dukecmmtar01.coxmail.com@696908E74163425> <200809081056.51762.beech@freebsd.org> <BAY117-W4218C5B5340992445C7C2C9B550@phx.gbl> <200809081146.06240.beech@freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help
Yeah that was it... The chown -R mysql:mysql /var/db/mysql was what did it= ... Thx to all for the help. - Joe > From: beech@freebsd.org > To: joe_tseng@hotmail.com > Date: Mon=2C 8 Sep 2008 11:46:02 -0800 > CC: freebsd-questions@freebsd.org > Subject: Re: Can't start MySQL 5.0.67 >=20 > On Monday 08 September 2008=2C Joe Tseng said: > > So I checked in that directory you suggested and I found this: > > > > 080908 13:35:05 mysqld started > > 080908 13:35:05 [Warning] option 'max_join_size': unsigned value > > 18446744073709551615 adjusted to 4294967295 080908 13:35:05 > > [Warning] option 'max_join_size': unsigned value > > 18446744073709551615 adjusted to 4294967295 080908 13:35:05=20 > > InnoDB: Operating system error number 13 in a file operation. > > InnoDB: The error means mysqld does not have the access rights to > > InnoDB: the directory. > > InnoDB: File name ./ibdata1 > > InnoDB: File operation call: 'create'. > > InnoDB: Cannot continue operation. > > 080908 13:35:05 mysqld ended > > > > So my questions are: > > 1. What directory is it referring to? Is it /var/db/mysql by > > default? I just tried to give ownership using chown -R mysql > > /var/db/mysql but that made no difference. 2. I've read also for > > this kind of issue I have to reinstall the software... When I > > initially installed this from ports I didn't use any kind of extra > > parameters. Are they needed? >=20 > Yes=2C the /var/db/mysql dir needs to be readable and writeable by=20 > mysql. Try the following: chown -R mysql:mysql /var/db/mysql. >=20 > The error is telling you that innodb can't=20 > create /var/db/mysql/ibdata1. After fixing permissions=2C you may need=20 > to do another initdb. >=20 > Beech >=20 > > > > > From: beech@freebsd.org > > > To: freebsd-questions@freebsd.org > > > Date: Mon=2C 8 Sep 2008 10:56:48 -0800 > > > CC: joe_tseng@hotmail.com > > > Subject: Re: Can't start MySQL 5.0.67 > > > > > > On Monday 08 September 2008=2C Joe Tseng said: > > > > I've got a server running FreeBSD7 and got MySQL 5.0.67 > > > > installed on it today. I ran mysql_install_db and then > > > > assigned the root password. I tried to get it running on boot > > > > (mysql_enable=3D"YES") and by hand > > > > (/usr/local/etc/rc.d/mysql-server start) but I can't get the > > > > daemon to start. What else do I need to do to get this > > > > working? > > > > > > > > - Joe > > > > > > Check the logfiles in /var/db/mysql=2C they will usually tell you > > > what it's choking on. My first guess without more info would be > > > you probably don't have something configured correctly. > > > > > > Beech >=20 >=20 >=20 > --=20 > -------------------------------------------------------------------------= -------------- > Beech Rintoul - FreeBSD Developer - beech@FreeBSD.org > /"\ ASCII Ribbon Campaign | FreeBSD Since 4.x > \ / - NO HTML/RTF in e-mail | http://people.freebsd.org/~beech > X - NO Word docs in e-mail | Skype: akbeech > / \ - http://www.FreeBSD.org/releases/7.0R/announce.html > -------------------------------------------------------------------------= -------------- >=20 >=20 >=20 > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe=2C send any mail to "freebsd-questions-unsubscribe@freebsd= .org" _________________________________________________________________ See how Windows connects the people=2C information=2C and fun that are part= of your life. http://clk.atdmt.com/MRT/go/msnnkwxp1020093175mrt/direct/01/=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?BAY117-W4BE18FE32381C854A29FF9B550>