Can't start MySQL 5.0.67

[Joe Tseng]

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  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?


> From: beech at freebsd.org
> To: freebsd-questions at freebsd.org
> Date: Mon, 8 Sep 2008 10:56:48 -0800
> CC: joe_tseng at hotmail.com
> Subject: Re: Can't start MySQL 5.0.67
> 
> On Monday 08 September 2008, 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="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, 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
> 
> -- 
> ---------------------------------------------------------------------------------------
> Beech Rintoul - FreeBSD Developer - beech at 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
> ---------------------------------------------------------------------------------------
> 
> 
> 
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"

_________________________________________________________________
Want to do more with Windows Live? Learn “10 hidden secrets” from Jamie.
http://windowslive.com/connect/post/jamiethomson.spaces.live.com-Blog-cns!550F681DAD532637!5295.entry?ocid=TXT_TAGLM_WL_domore_092008