Can't start MySQL 5.0.67
Joe Tseng
joe_tseng at hotmail.com
Mon Sep 8 19:55:40 UTC 2008
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 at freebsd.org
> To: joe_tseng at hotmail.com
> Date: Mon, 8 Sep 2008 11:46:02 -0800
> CC: freebsd-questions at freebsd.org
> Subject: Re: Can't start MySQL 5.0.67
>
> On Monday 08 September 2008, 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
> > 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?
>
> Yes, the /var/db/mysql dir needs to be readable and writeable by
> mysql. Try the following: chown -R mysql:mysql /var/db/mysql.
>
> The error is telling you that innodb can't
> create /var/db/mysql/ibdata1. After fixing permissions, you may need
> to do another initdb.
>
> Beech
>
> >
> > > 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"
_________________________________________________________________
See how Windows connects the people, information, and fun that are part of your life.
http://clk.atdmt.com/MRT/go/msnnkwxp1020093175mrt/direct/01/
More information about the freebsd-questions
mailing list