From owner-freebsd-questions Mon Jan 21 7:58:10 2002 Delivered-To: freebsd-questions@freebsd.org Received: from cswgraphics.com (host-64-65-195-100.choiceone.net [64.65.195.100]) by hub.freebsd.org (Postfix) with ESMTP id 2CB8B37B400 for ; Mon, 21 Jan 2002 07:58:04 -0800 (PST) Received: from citystamp.com (wanid.cswgraphics.com [64.65.195.58]) by cswgraphics.com (8.9.1b+Sun/8.9.1) with ESMTP id KAA27847; Mon, 21 Jan 2002 10:55:36 -0500 (EST) Message-ID: <3C4C3A6B.BAE20ECD@citystamp.com> Date: Mon, 21 Jan 2002 10:57:31 -0500 From: "Matthew P. Marino" Reply-To: bind9@citystamp.com Organization: City Stamp Works Inc. X-Mailer: Mozilla 4.75C-CCK-MCD {C-UDP; EBM-APPLE} (Macintosh; U; PPC) X-Accept-Language: en,pdf MIME-Version: 1.0 To: twig les Cc: freebsd-questions@FreeBSD.org Subject: Re: Freebsd-specific mysql info References: <20020118205232.30753.qmail@web10106.mail.yahoo.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Oddly enough, some of the best documentation for MySQL comes from apps that use it. PHP4 is a great resource. You can also get something called phpMyAdmin that will give you a web interface to the tables that really takes a lot of the pain out of it. If your concerned about security (as you should be), set up the server with 2 NICs (or an alias) and have the phpMyAdmin app. run from an Apache virtual server that only listens on a private network(192.168.x.x) and use an 404 authentication via .htaccess. It's theoreticaly impossible too get packets for those addresses routed accross the net, so you mostly need to worry about inside jobs. twig les wrote: > > Hey all, I'm looking for some good docs on how to > install and administer Mysql on freebsd. I've scoured > the Mysql docs but I'm a database newbie so when > something doesn't work right I'm lost. Normally this > wouldn't bother me much but I'm kinda under the gun > here at work. > > I'm running freebsd 4.4 stable-minimum install, with > mysql-3.23.42. I've already got the sucker installed > and I can fumble around until it's running, but I'm > looking for additional docs. > > THanks. > > ===== > ------------------------------------------------------- > It is easier to denature Plutonium than to denature the evil spirit of man > ------------------------------------------------------- > Albert Einstein > > __________________________________________________ > Do You Yahoo!? > Send FREE video emails in Yahoo! Mail! > http://promo.yahoo.com/videomail/ > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-questions" in the body of the message To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message