From owner-freebsd-questions@FreeBSD.ORG Tue May 20 19:58:55 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 B289037B401 for ; Tue, 20 May 2003 19:58:55 -0700 (PDT) Received: from host02.ipowerweb.com (host02.ipowerweb.com [12.129.206.102]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0555843F85 for ; Tue, 20 May 2003 19:58:55 -0700 (PDT) (envelope-from alpetec@host02.ipowerweb.com) Received: from alpetec by host02.ipowerweb.com with local (Exim 3.36 #1) id 19IJoI-0003MD-00; Tue, 20 May 2003 19:58:34 -0700 From: "Aaron Peterson" To: Gary D Kline , FreeBSD Mailing List X-Mailer: NeoMail 1.25 X-IPAddress: 139.55.49.242 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Message-Id: Date: Tue, 20 May 2003 19:58:34 -0700 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - host02.ipowerweb.com X-AntiAbuse: Original Domain - freebsd.org X-AntiAbuse: Originator/Caller UID/GID - [33877 2452] / [33877 2452] X-AntiAbuse: Sender Address Domain - host02.ipowerweb.com Subject: Re: mysql-4.1.0? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: aaron@alpete.com List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 21 May 2003 02:58:56 -0000 > 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.