[SOLVED] Apache 1.3 and php 4.4.2 installed - add mysql 4
Posted: Thu Jul 13, 2006 12:33 pm
Hi guys
I've been using Apache 1.3.33 on our local intranet and today I upgraded php to 4.4.2 from
http://www.php.net/downloads.php
I used the zip file version and just overwrote all the existing files I had in my c:\php directory and removed and copied all the extensions.
This is on windows 2000 and I just use it as a windows test machine on our local network as I develop more and more intranet services.
I need to now add mysql support and I've installed it and successfully connected to localhost as root using the windows mysql administrator, so mysql's all working.
But what do I need to do to get php and apache to recognise the new existance of mysql, if anything?
My aim is to get phpmyadmin installed to manage the databases.
I've tried a test script...
and I get the following error...
And I've copied the files php5ts.dll, libmysql.dll to my c:\php directory (which is in the path variable), and php_mysqli.dll to c:\php\extensions as per...
viewtopic.php?p=250571#250571
But I'm still getting that error.
Is there anything else I need to do to tell php and apache that mysql exists?
I've searched on google loads and found loads of tutorials all designed for getting a full apache, php and mysql installation working from nothing, but there doesn't seem to be any information on adding mysql to an existing apache / php installation.
Also, should I upgrade to Apache 2 and PHP5??
I currently use OpenSSL 0.9.8 to create a self-signed certificate for remote use of our intranet with http auth password protection.
Would all that still be possible with apache 2 and php 5?
I'm guessing though I could equally just upgrade apache to v2 and leave php at 4.4.2.
Would upgrading to PHP5 break all of my php4 scripts? From what I've seen of php 5 code so far - it looks almost identical but with certain functions having new options / parameters.
Thanks
Ben
I've been using Apache 1.3.33 on our local intranet and today I upgraded php to 4.4.2 from
http://www.php.net/downloads.php
I used the zip file version and just overwrote all the existing files I had in my c:\php directory and removed and copied all the extensions.
This is on windows 2000 and I just use it as a windows test machine on our local network as I develop more and more intranet services.
I need to now add mysql support and I've installed it and successfully connected to localhost as root using the windows mysql administrator, so mysql's all working.
But what do I need to do to get php and apache to recognise the new existance of mysql, if anything?
My aim is to get phpmyadmin installed to manage the databases.
I've tried a test script...
Code: Select all
$user="root";
$password="rootpassword";
mysql_connect(localhost,$user,$password) or die ("Can’t connect to MySQL.");
echo "Connected to MySQL.";
mysql_close();and I get the following error...
Code: Select all
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in...viewtopic.php?p=250571#250571
But I'm still getting that error.
Is there anything else I need to do to tell php and apache that mysql exists?
I've searched on google loads and found loads of tutorials all designed for getting a full apache, php and mysql installation working from nothing, but there doesn't seem to be any information on adding mysql to an existing apache / php installation.
Also, should I upgrade to Apache 2 and PHP5??
I currently use OpenSSL 0.9.8 to create a self-signed certificate for remote use of our intranet with http auth password protection.
Would all that still be possible with apache 2 and php 5?
I'm guessing though I could equally just upgrade apache to v2 and leave php at 4.4.2.
Would upgrading to PHP5 break all of my php4 scripts? From what I've seen of php 5 code so far - it looks almost identical but with certain functions having new options / parameters.
Thanks
Ben