Yeah that was it... The chown -R mysql:mysql /var/db/mysql was what did it... Thx to all for the help.
- Joe > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Date: Mon, 8 Sep 2008 11:46:02 -0800 > CC: freebsd-questions@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: [EMAIL PROTECTED] > > > To: freebsd-questions@freebsd.org > > > Date: Mon, 8 Sep 2008 10:56:48 -0800 > > > CC: [EMAIL PROTECTED] > > > 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 - [EMAIL PROTECTED] > /"\ 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@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "[EMAIL PROTECTED]" _________________________________________________________________ See how Windows connects the people, information, and fun that are part of your life. http://clk.atdmt.com/MRT/go/msnnkwxp1020093175mrt/direct/01/_______________________________________________ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"