Can't get mysql to start - permission error

[Malcolm Kay]

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.