From owner-freebsd-questions@FreeBSD.ORG  Mon Jun 11 22:03:52 2012
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 3129B106567A
	for <freebsd-questions@freebsd.org>;
	Mon, 11 Jun 2012 22:03:52 +0000 (UTC)
	(envelope-from freebsd@dreamchaser.org)
Received: from nightmare.dreamchaser.org (nightmare.dreamchaser.org
	[12.32.44.142]) by mx1.freebsd.org (Postfix) with ESMTP id E84768FC21
	for <freebsd-questions@freebsd.org>;
	Mon, 11 Jun 2012 22:03:51 +0000 (UTC)
Received: from breakaway.dreamchaser.org (breakaway.dreamchaser.org.
	[12.32.36.73])
	by nightmare.dreamchaser.org (8.13.6/8.13.6) with ESMTP id
	q5BM3mnW031494; Mon, 11 Jun 2012 16:03:48 -0600 (MDT)
	(envelope-from freebsd@dreamchaser.org)
Message-ID: <4FD66B44.3080506@dreamchaser.org>
Date: Mon, 11 Jun 2012 16:03:48 -0600
From: Gary Aitken <freebsd@dreamchaser.org>
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64;
	rv:13.0) Gecko/20120609 Thunderbird/13.0
MIME-Version: 1.0
To: Subhro Sankha Kar <subhro@80386.org>, nightrecon@hotmail.com
References: <4FD62BA8.7030702@dreamchaser.org>
	<721F59E6-BCA8-4589-8BB2-A0BCD5613031@80386.org>
In-Reply-To: <721F59E6-BCA8-4589-8BB2-A0BCD5613031@80386.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.0.2
	(nightmare.dreamchaser.org [12.32.36.65]);
	Mon, 11 Jun 2012 16:03:49 -0600 (MDT)
Cc: FreeBSD Mailing List <freebsd-questions@freebsd.org>
Subject: [solved] Re: mysqld startup issue
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: freebsd@dreamchaser.org
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: Mon, 11 Jun 2012 22:03:52 -0000

Ugh.  Operator error.

I assumed from the docs there had to be a my.cnf file someplace,
if only to serve as the system default;
and that the my.cnf file was directing everything else.
It turns out there doesn't have to be one anywhere.
My thought process was hijacked by the errors produced 
from the missing --datadir option

starting using:

  mysqld --datadir=<path> 

was all that was required,
although clearly a my.cnf or ~/.my.cnf would make things easier.

> 120611 10:55:52 [Warning] Can't create test file /var/db/mysql/breakaway.lower-test
> mysqld: Table 'mysql.plugin' doesn't exist
> 120611 10:55:52 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
> 120611 10:55:52 InnoDB: The InnoDB memory heap is disabled
> 120611 10:55:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
> 120611 10:55:52 InnoDB: Compressed tables use zlib 1.2.5
> 120611 10:55:52 InnoDB: Initializing buffer pool, size = 128.0M
> 120611 10:55:52 InnoDB: Completed initialization of buffer pool
> 120611 10:55:52  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.