From owner-freebsd-questions Wed Jun 26 17:33: 1 2002 Delivered-To: freebsd-questions@freebsd.org Received: from CPE0004761ac738-CM00109515bc65.cpe.net.cable.rogers.com (CPE0004761ac738-CM00109515bc65.cpe.net.cable.rogers.com [24.103.39.131]) by hub.freebsd.org (Postfix) with SMTP id 863AD37CA62 for ; Wed, 26 Jun 2002 17:10:24 -0700 (PDT) Received: (qmail 11618 invoked by uid 1001); 27 Jun 2002 00:10:52 -0000 Date: Wed, 26 Jun 2002 20:10:51 -0400 From: Miroslav Pendev To: "Defryn, Guy" Cc: questions@freebsd.org Subject: Re: Using Mysql on freebsd in a windows network Message-ID: <20020627001051.GA9596@CPE0004761ac738-CM00109515bc65.cpe.net.cable.rogers.com> References: <98B01D2717B9D411B38F0008C7840931057F3980@its-xchg2.massey.ac.nz> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <98B01D2717B9D411B38F0008C7840931057F3980@its-xchg2.massey.ac.nz> X-Divine-Shadow-Zone: Beware of Lexxx! X-Operating-System: FreeBSD 4.6 User-Agent: Mutt/1.5.1i 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 On Thu, Jun 27, 2002 at 11:04:41AM +1200, Defryn, Guy wrote: > > > Hi there, > > > I have an IIS web server running on W2K. I want to use > A dedicated Mysql server that will be used by web sites > stored on the W2K server. > > We use the IUSR_Machinename account. Is there anyway that this user can have access to mysql, preferably on freebsd but windows is ok as well. > You can access any MySQL server from anywhere with MySQL client! The account for access to the MySQL server have nothing to do with the Win account. It can be (and is good to be) different. Because you need access from web server (as I got your point), you must use 'scripts': PHP is pretty good with MySQL. I think there is a version for IIS, too (not for Apache only) I do not know if you can use ASP for access to MySQL! For M$ SQL - yes. With PHP you can login to remote MySQL server even with different user names and pass from the different web pages - if you need so... > I have tried this with access on a different server but it does not work > Because the IUSR_Machinename is a local account. I do not have access to the > domain controller so I can't create accounts for the domain > > Cheers There is probaly one more way - with CGI MySQL wrapper, altough i can't recall anything about such beast ;-) Hope that helps! --Miro To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message