From owner-freebsd-questions@FreeBSD.ORG Tue May 20 20:30:02 2003 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id EECF137B408 for ; Tue, 20 May 2003 20:30:02 -0700 (PDT) Received: from sage.thought.org (dsl231-043-140.sea1.dsl.speakeasy.net [216.231.43.140]) by mx1.FreeBSD.org (Postfix) with ESMTP id CD01D43F85 for ; Tue, 20 May 2003 20:30:01 -0700 (PDT) (envelope-from kline@thought.org) Received: from thought.org (root@tao [10.0.0.247]) by sage.thought.org (8.12.9/8.11.4) with ESMTP id h4L3TrG4002400; Tue, 20 May 2003 20:29:58 -0700 (PDT) (envelope-from kline@thought.org) Received: (from kline@localhost) by thought.org (8.12.6/8.11.3) id h4L3TqS4029192; Tue, 20 May 2003 20:29:52 -0700 (PDT) (envelope-from kline) Date: Tue, 20 May 2003 20:29:50 -0700 From: Gary D Kline To: Aaron Peterson Message-ID: <20030521032950.GA29147@tao.thought.org> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-Organization: Thought Unlimited. Public service Unix since 1986. X-Of_Interest: Observing 16 years of service to the Unix community User-Agent: Mutt/1.5.3i cc: FreeBSD Mailing List Subject: Re: mysql-4.1.0? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 21 May 2003 03:30:03 -0000 On Tue, May 20, 2003 at 07:58:34PM -0700, Aaron Peterson wrote: > > Hi, > > > > Can anyone give me the magic incantation to get mysql4 > > running and howto set up the admin acct? > > > > I am trying to get phpbbs running on my domain and test > > several other BBS and message-board apps that require an > > SQL database. For the time being I'm wedged, so any > > help or pointers to tutorials would be very welcome. > > > > tia, y'all, > --- > > install mysql-server from ports or pkg, whatever your choice. after > installation execute "/usr/local/bin/mysql_install_db && > /usr/local/etc/rc.d/mysql-server.sh start" > > after that, you can set the root password with > "/usr/local/bin/mysqladmin -u root password 'newrootpassword'" > > to enter the sql shell and talk to the database interactively, you can > then use "/usr/local/bin/mysql -u root -p" after which it will ask for a > password and drop you at a mysql shell console prompt. to create a new > database there you might try "create database phpbb" after which you can > create a user with permissions only to that database from localmachine > with "grant all on phpbb.* to phpbb_user@localhost identified by > 'phpbbpassword';" > > then when you configure phpbb, you would use database name "phpbb" > username "phpbb_user" and password "phpbbpassword". mysql operates on > port 3306 by default and the server name would be "localhost" > > hope that helps. you should really buy a book on mysql or visit the > docs on the mysql.com site if you use it any more than i just described. I looked for some kin d of installation script; found none. Maybe trying v4 was too ambitious; I'll try an earlier version. Here's what happened with the -alpha port: root@sage:/etc# /usr/local/bin/mysql_install_db /usr/local/bin/mysql_install_db: Command not found. thanks, gary PS: I have been digging into the www.mysql.com site. It should help later on. -gdk. -- Gary Kline kline@thought.org www.thought.org Public service Unix