Date: Sat, 25 Mar 2006 22:08:50 +0000 From: Matthew Seaman <m.seaman@infracaninophile.co.uk> To: Vaaf <vaaf@broadpark.no> Cc: questions@freebsd.org Subject: Re: E-mail server, minimalist approach Message-ID: <20060325220850.GA24910@happy-idiot-talk.infracaninophile.co.uk> In-Reply-To: <7.0.1.0.2.20060325213043.023916c8@broadpark.no> References: <7.0.1.0.2.20060325213043.023916c8@broadpark.no>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060325220850.GA24910>