PHP/MySQL/Apache

Terran

Ok this is the deal:

This morning I decided to get back into PHP. When I quit I was just learning MySQL/PHP interaction. But that's beyond the point.

My problem is that I cannot get MySQL working properly. I've already installed (and got working) Apache 2.0.53 and PHP 5.0.3. I wrote some PHP scripts earlier. They're fine.

So I just downloaded and installed MySQL 4.1. I set it up with my root password and all and then I downloaded phpMyAdmin and put it into my htdocs folder in my Apache directory.

So I try to launch phpMyAdmin and it says this:

cannot load mysql extension,
please check PHP Configuration

It gives me a link to a help file. I went there and it said to get the php_mysql.dll extension file.

Well, I had it in C:\PHP\ext. So I moved it out of the ext folder into C:\PHP.

Then I went into PHP.ini and removed the ";" in front of the MySQL extension.

Now, when I start Apache, I get this error message:

PHP Startup: Unable to load dynamic library: 'C:\PHP\php_mysql.dll' - The specified module could not be found.

However, C:\PHP\php_mysql.dll DOES exist according to my own PHP script that I wrote earlier to check a file's existence. Not to mention I see it with my own eyes...

I'm clueless right now. Any help would be greatly appreciated. Thanks!

-Terran

Note: I posted this in the installation forum as well because I was not sure which would be the best choice. If this is a problem, feel free to remove any of my topics/posts. Thanks and sorry for the inconvenience.

bpat1434

I'm not sure but what about:
Permissions
Moving the file back to where it was?

~Brett

Terran

Originally posted by bpat1434
I'm not sure but what about:
Permissions
Moving the file back to where it was?

~Brett

Hmm. Well lets see...

It was originally in C:\PHP\ext but PHP.ini is set to:

extension_dir = "C:\PHP\"

So I moved the file into that directory thinking that it should be in there or else it won't be found. But then that message that I wrote comes up.

As far as permissions go, the only file attribute is "Archive." That's all I know.

tomhath

Did you try the suggestions in the Sticky post at the top of this forum? It mentions a second dll.

Terran

Originally posted by tomhath
Did you try the suggestions in the Sticky post at the top of this forum? It mentions a second dll.

That could be the reason. But the problem is I cannot find a "dll" folder in my PHP directory.

There is no such file as C:\PHP\dll\libmySQL.dll.

EDIT: Well I just found out that it's actually already in C:\PHP. Apparently the latest version of PHP elimiates the \dll\ directory and simply puts the dlls in the master folder. So this can't be it...

I'm a little confused about what he means by putting

if (!class_exists('mysql')) {
if (strtoupper(substr(PHP_OS, 0, 3)) == 'WIN')
dl('php_mysql.dll');
else
dl('php_mysql.so');
}

into a database file. Which file? For example, to get phpMyAdmin to work, do I have to put this in those files? Thanks.

Update:

Well I got it sorted out. Thanks! Apparently I just had to mess with my PHP.ini and extension file setup. As you probably know, there are multiple ways to run PHP and Apache together. Either by placing some of the PHP files directly into the Apache folder or creating references to them and etc...

All I did was move the DLLs to System32 rather than relying on php.ini to find them (in the same folder) and it worked.

But now there's another problem. When I run phpMyAdmin I get this error from phpMyAdmin:

#2003 - The server is not responding

Anyone know why? Thanks.

tomhath

#2003 - The server is not responding

Are you sure the mysql service is running? What happens when you run it from a command tool (something like c:\mysql\bin\mysql.exe) ?