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
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)
initially installed this from ports I didn't use any kind of extra
parameters. Are they needed?
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
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
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
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
Joe Tseng wrote:
Yeah that was it... The chown -R mysql:mysql /var/db/mysql was what did
it... Thx to all for the help.
- Joe
[snip]
Look in /usr/local/share/mysql for my.cnf examples you can use for tuning
your install. One thing that bit me once was the location of the my.cnf
