From owner-freebsd-questions@FreeBSD.ORG Thu Jul 5 12:15:01 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 CA6CF16A41F for ; Thu, 5 Jul 2007 12:15:01 +0000 (UTC) (envelope-from Johan@double-l.nl) Received: from smtp-vbr3.xs4all.nl (smtp-vbr3.xs4all.nl [194.109.24.23]) by mx1.freebsd.org (Postfix) with ESMTP id 6A8D613C459 for ; Thu, 5 Jul 2007 12:15:01 +0000 (UTC) (envelope-from Johan@double-l.nl) Received: from w2003s01.double-l.local (dpm.xs4all.nl [213.84.11.61]) by smtp-vbr3.xs4all.nl (8.13.8/8.13.8) with ESMTP id l65Bpgqx005282; Thu, 5 Jul 2007 13:51:42 +0200 (CEST) (envelope-from Johan@double-l.nl) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="windows-1250" Content-Transfer-Encoding: quoted-printable X-MimeOLE: Produced By Microsoft Exchange V6.5 Date: Thu, 5 Jul 2007 13:51:40 +0200 Message-ID: <57200BF94E69E54880C9BB1AF714BBCB19BB73@w2003s01.double-l.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How does one start mysql after installing from ports Thread-Index: Ace+ppD1ZOS6lxaBSKWXOMt1F6djlAAU7Seg References: From: "Johan Hendriks" To: X-Virus-Scanned: by XS4ALL Virus Scanner Cc: freebsd-questions@freebsd.org Subject: RE: 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: Thu, 05 Jul 2007 12:15:01 -0000 >To autostart mysql at boot add this to /etc/rc.conf >mysql_enable=3D"YES" >Add this to /etc/rc.conf to direct to use location where there is a = large >enough free disk space >to hold your databases >mysql_dbdir=3D"/usr/local/mysql" >To start or stop mysql server do this >/usr/local/share/mysql/mysql.server start >/usr/local/share/mysql/mysql.server stop Better is to use /usr/local/etc/rc.d/mysql start cq stop >You have to tell mysql to create its internel control db >by running this command one time first before trying to create = databases. >mysql_install_db --user=3Dmysql If you did use /usr/local/etc/rc.d/mysql start, the above is not needed, = it will do it automaticly if it does not find any database at startup. >To verify mysql is operational issue these commands >mysqladmin version >mysqladmin variables >To start command line session with mysql server to >create a DB enter >mysql -u root >The online mysql manual is at >http://dev.mysql.com/doc/refman/5.0/en/index.html =20 No virus found in this outgoing message. Checked by AVG Free Edition.=20 Version: 7.5.476 / Virus Database: 269.10.0/886 - Release Date: 4-7-2007 = 13:40 =20