From owner-freebsd-questions@FreeBSD.ORG Wed Jul 4 22:00:50 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 2038C16A46B for ; Wed, 4 Jul 2007 22:00:50 +0000 (UTC) (envelope-from af300wsm@gmail.com) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.181]) by mx1.freebsd.org (Postfix) with ESMTP id B35DB13C4AE for ; Wed, 4 Jul 2007 22:00:49 +0000 (UTC) (envelope-from af300wsm@gmail.com) Received: by py-out-1112.google.com with SMTP id u77so4542721pyb for ; Wed, 04 Jul 2007 15:00:49 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=INGLAmGlI6GYmXTj/NWNiELXWQ7rbTfnrP+PNoc1Wox1jTsOKNAmIircFMbYCpgojSXQSYOP6xaDtMuM5lKO6lHN2zm+XO+LbZOhUz31nzvOwlno0gIgnbU9x5FP+3lpK7Ok43NTodAQGAWKezqjrhsMULf7n4/MVXkItglWLMU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=CcI6jmGZwNomz+b+ewxUVTEFYK6jNv6WIi7IPR/RdBfXgEV64KuEwh7slpRmm+k7bAQz7CdXWBp71xzADPmHP4ePfq/Nfzmm5x3DjYl7MoT7IM9cVd/zQ+3OB71dEZvqZtcXi60li/23KtFAytKGBM0wrTcIixKsHVnGji2brIk= Received: by 10.35.109.2 with SMTP id l2mr10461308pym.1183586448518; Wed, 04 Jul 2007 15:00:48 -0700 (PDT) Received: by 10.35.17.4 with HTTP; Wed, 4 Jul 2007 15:00:48 -0700 (PDT) Message-ID: <340a29540707041500g25289b6la1aec3340b5cd628@mail.gmail.com> Date: Wed, 4 Jul 2007 16:00:48 -0600 From: "Andrew Falanga" To: "User Questions" MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Subject: How does one start mysql after installing from ports X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 04 Jul 2007 22:00:50 -0000 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