Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 4 Jul 2007 16:00:48 -0600
From:      "Andrew Falanga" <af300wsm@gmail.com>
To:        "User Questions" <freebsd-questions@freebsd.org>
Subject:   How does one start mysql after installing from ports
Message-ID:  <340a29540707041500g25289b6la1aec3340b5cd628@mail.gmail.com>

Next in thread | Raw E-Mail | Index | Archive | Help
This is pretty pathetic but I'm batting a 1000 on this one.  I
installed mysql a few weeks ago on this web server I'm making for my
church and didn't do anything with it at that point (that was the
first mistake).  I've not used mysql (I usually use PostgreSQL) but
WebGUI wants mysql.  So, being completely unfamiliar with it, I cannot
figure out how to start this thing.

I eventually figured out that the mysqld process starts by using
mysqld_safe in /usr/local/bin.  However, I can't get it to start.  At
first it was because the directory /var/db/mysql didn't exist.  I
created that and now I get this:

whitbap# mysqld_safe
Starting mysqld daemon with databases from /var/db/mysql
STOPPING server from pid file /var/db/mysql/whitbap.pid
070704 16:09:42  mysqld ended

(And the contents of /var/db/mysql/whitbap.err:
whitbap# cat /var/db/mysql/whitbap.err
070704 16:02:41  mysqld started
070704 16:02:42  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.
070704 16:02:42  mysqld ended

070704 16:09:42  mysqld started
070704 16:09:42  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.
070704 16:09:42  mysqld ended


I'm assuming that a process, perhaps similar to PostgreSQL, is
applicable for MySQL too.  For example, in PostgreSQL, one must first
usr 'initdb' to initialize the data area.  Is this true for MySQL too?

Please tell me how to work MySQL (to anyone on this list that uses it).

Thanks,
Andy



Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?340a29540707041500g25289b6la1aec3340b5cd628>