Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 26 Jun 2002 20:10:51 -0400
From:      Miroslav Pendev <shadow@CPE0004761ac738-CM00109515bc65.cpe.net.cable.rogers.com>
To:        "Defryn, Guy" <G.P.Defryn@massey.ac.nz>
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>
In-Reply-To: <98B01D2717B9D411B38F0008C7840931057F3980@its-xchg2.massey.ac.nz>
References:  <98B01D2717B9D411B38F0008C7840931057F3980@its-xchg2.massey.ac.nz>

next in thread | previous in thread | raw e-mail | index | archive | help
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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20020627001051.GA9596>