phpMyAdmin Help!

[Raistlfiren]

Hey,
I was setting up a webserver with Apache 2.0.54, MySQL Client Version 5.0.4, PHP 5, and of course phpMyAdmin 2.6.3... Anyway after spending hours setting up my PHP with Apache I go to install phpMyAdmin onto my server. Though as you can see it didnt go well...

Before I get started on my problem, thought I might tell you some info about the os and other helpful information. I currently have Windows XP Professional SP2 on it. I have also tested my webserver by typing 127.0.0.1 in my url bar and was able to succesfully get into my server. I am also able to access PHP, by typing 127.0.0.1/phpinfo.php.

Whenever I try to connect to 127.0.0.1/phpMyAdmin/index.php it does not work! Whenever I go to the website I first recieve this message :

cannot load mysql extension;
please check PHP configuration
Documentation

Of course "Documentation is leading off to another site on my server that gives a FAQ of information about the problem. This is what it says :

[1.20] I receive the error "cannot load MySQL extension, please check PHP Configuration".
To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL extension". This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed.

Usually, the problem is solved by installing a software package called "PHP-MySQL" or something similar.


After checking multiple sites on the web, I have encountered not a whole lot as you can see me coming here... People have either went to a lower php or did unethical things by moving files to System32 and configuring things in your Enviroment Variables. I am trying to not have to have to go to a lower php. I was wondering if any of you knew what I mjay be doing wrong. I might also want to add that I really don't have much experience in making a server, and I'm just doing it to get the experince of doing it! Oh yes, I would also like to add that these are the running php modules after typing php -m in cmd prompt:

[PHP Modules]

bcmath
calendr
com_dotnet
ctype
dom
ftp
iconv
libxml
odbc
pcre
session
SimpleXML
SPL
SQLite
standard
tokenizer
wddx
xml
zlib

[Zend Modules]


Please help me, because I have totally run out of patience and I really do not want to screw up my settings with php 5! After spending hours configuring that... I also think that php comes out with more security each update... I am not totally sure about that...

Anyway,
Rat

[Xnuiem]

Funny how in the windows world it is "unethical" to change enviroment variables, and yet in the *nix world, it is called system adminstration.

[Raistlfiren]

If I may ask, what is the relevancy of that? Not trying to be rude, I am just trying to ask a question.

[Xnuiem]

The proper way to resolve this issue, as I am aware, is something that is considered "unethical".

[Raistlfiren]

Whenever I said "unethical" I said it because many people have said the same thing to me. I have been too a few forums and websites by way of Google and people have said that is not how your supposed to do it

So I have to do this :
1. Get ZIPPED version of PHP for windows from www.php.net
2. Extract the contents.
3. Find php_mysql.dll in EXT folder.
4. Copy and paste it in C:WINNT/SYSTEM32
5. Modify php.ini in C:WINNT as below.

extension_dir = "C:\WINNT\SYSTEM32"
extension=php_mysql.dll

Will this then cause future problems with my webserver? Shouldn't the extension_dir point to the php folder and not to your System32 folder?

Should I be following these directions, or does it have any relevancy to my problem at all? Foundation Dreamweaver
Raistlin

[Raistlfiren]

Oh yes I would also like to add, that put php_mysql.dll into my System32 folder did not help. Everything else works but that still. I tryed both ways! I also have my enviromental variables changed to one too :

Variable Name : PHPRC
variable Value : C:\Server\PHP

I also inserted C:\Server\PHP into my Enviromental viariables path. Anything I might be missing? Any other ways to troubleshoot this?
Rat