Date: Sun, 11 Apr 2010 11:41:54 +0930 From: Malcolm Kay <malcolm.kay@internode.on.net> To: freebsd-questions@freebsd.org, "Gene" <fbsd@bomgardner.net> Subject: Re: Can't get mysql to start - permission error Message-ID: <201004111141.54934.malcolm.kay@internode.on.net> In-Reply-To: <20100410231955.M8887@brightstar.bomgardner.net> References: <20100410231955.M8887@brightstar.bomgardner.net>
next in thread | previous in thread | raw e-mail | index | archive | help
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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201004111141.54934.malcolm.kay>