Re: [PHP] How to install PHP 5.x on Windows Server 2000 with IIS 5and MySQL 5.x

---- edwardspl@ita.org.mo wrote:
> Hello to All,
>
> Would you mind to help as the title of mail ?
>
> Thanks !
>
> Edward.
>

What problems are you having?

Have you read the Manual yet?

I'd suggest going with a real operating system (linux) which keeps patches updated quicker...

Wolf

On Thu, 2008-03-27 at 10:32 -0400, Wolf wrote:
> I'd suggest going with a real operating system (linux) which keeps patches updated quicker...
>

As much of a Free Software advocate as I am, that is not the answer to
the question. That being said, however, I would replace the IIS with
Apache2 at least...

I seem to remember someone posting a really good guide to setting this
all up at some stage, so a quick search through the archives should
reveal all.


--Paul

--
------------------------------------------------------------.
| Chisimba PHP5 Framework - http://avoir.uwc.ac.za |
:------------------------------------------------------------:


All Email originating from UWC is covered by disclaimer
http://www.uwc.ac.za/portal/public/p...disclaimer.htm

Paul Scott wrote:
> On Thu, 2008-03-27 at 10:32 -0400, Wolf wrote:
>> I'd suggest going with a real operating system (linux) which keeps patches updated quicker...
>>
>
> As much of a Free Software advocate as I am, that is not the answer to
> the question. That being said, however, I would replace the IIS with
> Apache2 at least...
>
> I seem to remember someone posting a really good guide to setting this
> all up at some stage, so a quick search through the archives should
> reveal all.
>
>
> --Paul
>
>
>
> ------------------------------------------------------------------------
>
> All Email originating from UWC is covered by disclaimer
> http://www.uwc.ac.za/portal/public/p...disclaimer.htm

Download the zip and read the install.txt. It doesn't get any easier
than that. It's very straight forward and has worked for me every time.

-Shawn

Shawn McKenzie wrote:

>Paul Scott wrote:
>
>
>>On Thu, 2008-03-27 at 10:32 -0400, Wolf wrote:
>>
>>
>>>I'd suggest going with a real operating system (linux) which keeps patches updated quicker...
>>>
>>>
>>>
>>As much of a Free Software advocate as I am, that is not the answer to
>>the question. That being said, however, I would replace the IIS with
>>Apache2 at least...
>>
>>I seem to remember someone posting a really good guide to setting this
>>all up at some stage, so a quick search through the archives should
>>reveal all.
>>
>>
>>--Paul
>>
>>
>>
>>------------------------------------------------------------------------
>>
>>All Email originating from UWC is covered by disclaimer
>>http://www.uwc.ac.za/portal/public/p...disclaimer.htm
>>
>>
>
>Download the zip and read the install.txt. It doesn't get any easier
>than that. It's very straight forward and has worked for me every time.
>
>-Shawn
>
>
>
Hello Shawn,

How to enable php 5.2.5 with MySQL 5.0.51a ?

Thank for your help !

Edward.

edwardspl@ita.org.mo wrote:
> Shawn McKenzie wrote:
>
>> Paul Scott wrote:
>>
>>
>>> On Thu, 2008-03-27 at 10:32 -0400, Wolf wrote:
>>>
>>>
>>>> I'd suggest going with a real operating system (linux) which keeps patches updated quicker...
>>>>
>>>>
>>>>
>>> As much of a Free Software advocate as I am, that is not the answer to
>>> the question. That being said, however, I would replace the IIS with
>>> Apache2 at least...
>>>
>>> I seem to remember someone posting a really good guide to setting this
>>> all up at some stage, so a quick search through the archives should
>>> reveal all.
>>>
>>>
>>> --Paul
>>>
>>>
>>>
>>> ------------------------------------------------------------------------
>>>
>>> All Email originating from UWC is covered by disclaimer
>>> http://www.uwc.ac.za/portal/public/p...disclaimer.htm
>>>
>>>
>> Download the zip and read the install.txt. It doesn't get any easier
>> than that. It's very straight forward and has worked for me every time.
>>
>> -Shawn
>>
>>
>>
> Hello Shawn,
>
> How to enable php 5.2.5 with MySQL 5.0.51a ?
>
> Thank for your help !
>
> Edward.
>
Make sure your extensions path is correct in php.ini and uncomment the
extension=mysql.ini line in php.ini.

-Shawn

Shawn McKenzie wrote:

>edwardspl@ita.org.mo wrote:
>
>
>>Shawn McKenzie wrote:
>>
>>
>>
>>>Paul Scott wrote:
>>>
>>>
>>>
>>>
>>>>On Thu, 2008-03-27 at 10:32 -0400, Wolf wrote:
>>>>
>>>>
>>>>
>>>>
>>>>>I'd suggest going with a real operating system (linux) which keeps patches updated quicker...
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>As much of a Free Software advocate as I am, that is not the answer to
>>>>the question. That being said, however, I would replace the IIS with
>>>>Apache2 at least...
>>>>
>>>>I seem to remember someone posting a really good guide to setting this
>>>>all up at some stage, so a quick search through the archives should
>>>>reveal all.
>>>>
>>>>
>>>>--Paul
>>>>
>>>>
>>>>
>>>>------------------------------------------------------------------------
>>>>
>>>>All Email originating from UWC is covered by disclaimer
>>>>http://www.uwc.ac.za/portal/public/p...disclaimer.htm
>>>>
>>>>
>>>>
>>>>
>>>Download the zip and read the install.txt. It doesn't get any easier
>>>than that. It's very straight forward and has worked for me every time.
>>>
>>>-Shawn
>>>
>>>
>>>
>>>
>>>
>>Hello Shawn,
>>
>>How to enable php 5.2.5 with MySQL 5.0.51a ?
>>
>>Thank for your help !
>>
>>Edward.
>>
>>
>>
>Make sure your extensions path is correct in php.ini and uncomment the
>extension=mysql.ini line in php.ini.
>
>-Shawn
>
>
>
Hello,

1, I had edited with extension=php_mysql.dll
2, Test the php with mysql by using php page with phpinfo() function,the
result of mysql is enabled.
3, I can edit the db data though the phpmyadmin tools.
4, BUT test the connection with mysql as the following code is fail :

<?PHP
//remember to change the password to whatever you set
//it to in mysql instance configuration

//first parameter is server name, 2nd username 'root', 3rd is password
$rst = @mysql_connect("localhost","root","root");

if (!$rst){
echo( "<p>Unable to connect to database manager.</p>");
die('Could not connect: ' . mysql_error());
exit();
} else {
echo("<p>Successfully Connected to MySQL Database Manager!</p>");
}

if (! @mysql_select_db("mysql") ){
echo( "<p>Unable to connect database...</p>");
exit();
} else {
echo("<p>Successfully Connected to Database 'MYSQL'!</p>");
}
?>

The warning message is "Access denied...."
So, any more help ?

For the IIS configuration, load the c:\php\php-cgi.exe...

Thanks !

Edward.

On 3/29/08, edwardspl@ita.org.mo <edwardspl@ita.org.mo> wrote:
> Shawn McKenzie wrote:
>
> >edwardspl@ita.org.mo wrote:
> >
> >
> >>Shawn McKenzie wrote:
> >>
> >>
> >>
> >>>Paul Scott wrote:
> >>>
> >>>
> >>>
> >>>
> >>>>On Thu, 2008-03-27 at 10:32 -0400, Wolf wrote:
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>I'd suggest going with a real operating system (linux) which keeps patches updated quicker...
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>As much of a Free Software advocate as I am, that is not the answer to
> >>>>the question. That being said, however, I would replace the IIS with
> >>>>Apache2 at least...
> >>>>
> >>>>I seem to remember someone posting a really good guide to setting this
> >>>>all up at some stage, so a quick search through the archives should
> >>>>reveal all.
> >>>>
> >>>>
> >>>>--Paul
> >>>>
> >>>>
> >>>>
> >>>>------------------------------------------------------------------------
> >>>>
> >>>>All Email originating from UWC is covered by disclaimer
> >>>>http://www.uwc.ac.za/portal/public/p...disclaimer.htm
> >>>>
> >>>>
> >>>>
> >>>>
> >>>Download the zip and read the install.txt. It doesn't get any easier
> >>>than that. It's very straight forward and has worked for me every time.
> >>>
> >>>-Shawn
> >>>
> >>>
> >>>
> >>>
> >>>
> >>Hello Shawn,
> >>
> >>How to enable php 5.2.5 with MySQL 5.0.51a ?
> >>
> >>Thank for your help !
> >>
> >>Edward.
> >>
> >>
> >>
> >Make sure your extensions path is correct in php.ini and uncomment the
> >extension=mysql.ini line in php.ini.
> >
> >-Shawn
> >
> >
> >
> Hello,
>
> 1, I had edited with extension=php_mysql.dll
> 2, Test the php with mysql by using php page with phpinfo() function,the
> result of mysql is enabled.
> 3, I can edit the db data though the phpmyadmin tools.
> 4, BUT test the connection with mysql as the following code is fail :
>
> <?PHP
> //remember to change the password to whatever you set
> //it to in mysql instance configuration
>
> //first parameter is server name, 2nd username 'root', 3rd is password
> $rst = @mysql_connect("localhost","root","root");
>
> if (!$rst){
> echo( "<p>Unable to connect to database manager.</p>");
> die('Could not connect: ' . mysql_error());
> exit();
> } else {
> echo("<p>Successfully Connected to MySQL Database Manager!</p>");
> }
>
> if (! @mysql_select_db("mysql") ){
> echo( "<p>Unable to connect database...</p>");
> exit();
> } else {
> echo("<p>Successfully Connected to Database 'MYSQL'!</p>");
> }
> ?>
>
> The warning message is "Access denied...."
> So, any more help ?

That means that the user "root" with the password "root" does not have
permission to connect to the MySQL server. I'm late to this thread,
but if you have not touched MySQL's user accounts in any way, there
should be a user "root" with an empty password.

Try: $rst = @mysql_connect("localhost","root","");

--

-David.

When the power of love
overcomes the love of power,
the world will know peace.

-Jimi Hendrix