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.
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"