From owner-freebsd-questions@FreeBSD.ORG Tue May 20 20:35:19 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 2937937B404 for ; Tue, 20 May 2003 20:35:19 -0700 (PDT) Received: from p6m7g8.com (pcp02835904pcs.hyatsv01.md.comcast.net [68.54.254.42]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0329E43F85 for ; Tue, 20 May 2003 20:35:18 -0700 (PDT) (envelope-from philip@p6m7g8.com) Received: from p6m7g8.com (localhost [127.0.0.1]) by p6m7g8.com (8.12.9/8.12.9) with ESMTP id h4L4ZICE006176; Tue, 20 May 2003 23:35:18 -0500 (EST) (envelope-from philip@p6m7g8.com) Received: (from philip@localhost) by p6m7g8.com (8.12.9/8.12.9/Submit) id h4L4ZIGo006175; Tue, 20 May 2003 23:35:18 -0500 (EST) From: "Philip M. Gollucci" Organization: eJournalPress To: Gary D Kline Date: Tue, 20 May 2003 23:35:17 -0500 User-Agent: KMail/1.5.1 References: <20030521032950.GA29147@tao.thought.org> In-Reply-To: <20030521032950.GA29147@tao.thought.org> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200305202335.17901.philip@p6m7g8.com> cc: questions@FreeBSD.org 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:35:19 -0000 I just did this yesterday 4.1 gives me my subselects !!!!! whowhoooo! su cvsup -g -L2 /usr/share/examples/cvsup/ports-supfile cd /usr/ports/databases/mysql4.1-server make install distclean rehash mysqld_safe & mysqladmin -u root password 'this_is_the_password' mysql -u root --password='this_is_the_password'' mysql> FYI: mysql 5.0 compiles on FreeBSD aswell depending on your compile options. On Tuesday 20 May 2003 10:29 pm, Gary D Kline wrote: > 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. -- END ------------------------------------------------------------------------------ Philip M. Gollucci Consultant E-Mail: philip@p6m7g8.com URL : http://p6m7g8.net/Resume/resume.shtml Phone : 301.474.9598 eJournalPress DBA / Software Engineer / System Administrator E-Mail: pgollucci@ejournalpress.com URL : http://www.ejournalpress.com Phone : 301.530.6375 $Id: .signature,v 1.4 2003/05/02 23:46:37 philip Exp $