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>