From owner-freebsd-questions@FreeBSD.ORG  Sun Apr 11 02:11:58 2010
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 9ACB91065677
	for <freebsd-questions@freebsd.org>;
	Sun, 11 Apr 2010 02:11:58 +0000 (UTC)
	(envelope-from malcolm.kay@internode.on.net)
Received: from ipmail06.adl6.internode.on.net (ipmail06.adl6.internode.on.net
	[150.101.137.145])
	by mx1.freebsd.org (Postfix) with ESMTP id 239E88FC18
	for <freebsd-questions@freebsd.org>;
	Sun, 11 Apr 2010 02:11:57 +0000 (UTC)
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: AvsEAO/KwEt20oy9/2dsb2JhbACbQnK3MYUMBIMj
Received: from ppp118-210-140-189.lns20.adl6.internode.on.net (HELO
	alpha.home) ([118.210.140.189])
	by ipmail06.adl6.internode.on.net with ESMTP; 11 Apr 2010 11:41:56 +0930
From: Malcolm Kay <malcolm.kay@internode.on.net>
Organization: at home
To: freebsd-questions@freebsd.org,
 "Gene" <fbsd@bomgardner.net>
Date: Sun, 11 Apr 2010 11:41:54 +0930
User-Agent: KMail/1.8
References: <20100410231955.M8887@brightstar.bomgardner.net>
In-Reply-To: <20100410231955.M8887@brightstar.bomgardner.net>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <201004111141.54934.malcolm.kay@internode.on.net>
Cc: 
Subject: Re: Can't get mysql to start - permission error
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 11 Apr 2010 02:11:58 -0000

On Sun, 11 Apr 2010 08:58 am, Gene wrote:
> Hi all:
>
> I'm running FBSD 8.0, amd64. After installing the mysql port:
> Mysql55-server and mysql55-client I've attempted to start
> using mysql_safe --user=mysql.

It is probably better to add:
 mysql_enable="YES"
to /etc/rc.conf and then run
 # /usr/local/etc/rc.d/mysql-server start
which amongst other things will run mysql_safe.

>
> It craps out and in the error log I find:
>
> 100410  7:25:36  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.
>
> I suspect incorrect permissions somewhere. The question is...
> Where? Does anyone have any idea where it's trying to create
> ibdata1?

With a new installation you need to run
 # mysql_install_db --ldata=/var/db/mysql
to create the data base structure, and
 # chown -R mysql:mysql /var/db/mysql

If /var/db/mysql/mysql does not already exist then
 # /usr/local/etc/rc.d/mysql-server start
should execute these commands for you.

You don't need to run mysql_safe from the command line.

(My systems are i386 but I don't expect that this will make any 
difference)

>
> And on a slightly related note - attempts to build the
> mysql60-server port rapidly dies with the error:
>
> ===>  mysql-server-6.0.11 cannot install: unknown MySQL
> version: 60. *** Error code 1

Hmm, seem to reacall discarding mysql60 for some reason but
I think not for the error you experienced.

Malcolm Kay

>
> Anyone know what that's all about?
>
> Thanks for any help or words of wisdom.
> IHN,
> Gene
>
> --
> To everything there is a season,
> And a time to every purpose under heaven.