From owner-freebsd-questions@FreeBSD.ORG Sat Mar 25 22:09:04 2006 Return-Path: X-Original-To: questions@freebsd.org 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 E87C816A401 for ; Sat, 25 Mar 2006 22:09:04 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (ns0.infracaninophile.co.uk [81.187.76.162]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2028343D45 for ; Sat, 25 Mar 2006 22:09:03 +0000 (GMT) (envelope-from m.seaman@infracaninophile.co.uk) Received: from happy-idiot-talk.infracaninophile.co.uk (localhost [IPv6:::1]) by smtp.infracaninophile.co.uk (8.13.4/8.13.4) with ESMTP id k2PM8olA071792 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Sat, 25 Mar 2006 22:08:50 GMT (envelope-from matthew@happy-idiot-talk.infracaninophile.co.uk) Received: (from matthew@localhost) by happy-idiot-talk.infracaninophile.co.uk (8.13.4/8.13.4/Submit) id k2PM8ojF071787; Sat, 25 Mar 2006 22:08:50 GMT (envelope-from matthew) Date: Sat, 25 Mar 2006 22:08:50 +0000 From: Matthew Seaman To: Vaaf Message-ID: <20060325220850.GA24910@happy-idiot-talk.infracaninophile.co.uk> Mail-Followup-To: Matthew Seaman , Vaaf , questions@freebsd.org References: <7.0.1.0.2.20060325213043.023916c8@broadpark.no> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable In-Reply-To: <7.0.1.0.2.20060325213043.023916c8@broadpark.no> User-Agent: Mutt/1.5.11 X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.0.2 (smtp.infracaninophile.co.uk [IPv6:::1]); Sat, 25 Mar 2006 22:08:50 +0000 (GMT) X-Virus-Scanned: ClamAV version 0.88, clamav-milter version 0.87 on happy-idiot-talk.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-3.5 required=5.0 tests=AWL,BAYES_00, UNPARSEABLE_RELAY autolearn=ham version=3.1.1 X-Spam-Checker-Version: SpamAssassin 3.1.1 (2006-03-10) on happy-idiot-talk.infracaninophile.co.uk Cc: questions@freebsd.org Subject: Re: E-mail server, minimalist approach 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: Sat, 25 Mar 2006 22:09:05 -0000 On Sat, Mar 25, 2006 at 09:38:42PM +0100, Vaaf wrote: > My minimalist approach to using MySQL for instance, is to stay away > from phpMyAdmin and just create my databases like this: >=20 > CREATE DATABASE IF NOT EXISTS database; > GRANT USAGE ON database.* TO database@localhost IDENTIFIED BY 'password'; > GRANT ALL ON database.* TO database@localhost; Ummm... the minimalist approach would only require /two/ lines: CREATE DATABASE IF NOT EXISTS database ;=20 GRANT ALL ON database.* TO database@localhost IDENTIFIED BY 'password' ; More pertinently, the really big advantage of doing stuff the command-line way is that you can arrange all this sort of thing as a series of scripts preserved under CVS or the like. Takes a little more effort the first time you do it, then saves you having to rediscover it all the next or any subsequent time. Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW