can't connect to mySQL( unidentified error)

[Guest]

I've searched for help in the forums but nothing I can find helps solve my problem.

I'm trying to set up the database tutorial which is part of the MX2004 installation. I'm using XP Pro (fully up-to-date); iis; MySQL and PHP (all the latest versions just downloaded).

All seems fine until I try to connect to the db from mx2004 when I get an unidentified error response when I test the connection. As I'm obviously new to this I'm at a total loss how to proceed. All setup files/folders have been created and populated exactly as instructed in the mx2004 tutorial.

Any help would be very much appreciated.

Ken

[MikeL7]

You might have to modify the php.ini file, i had the same type of problem, with the new php 5.2.3, first check the php info file, make a page with just <? phpinfo(); ?> on it and look for the MySQL section, if you dont find it the follow this pages instrucions, it worked when i set up my php MySQL setup. If its your first install just go to step 3, as you wont have older versions of the php_mysql.dll. Be sure to restart apache or IIS when you make the changes
http://www.phplivesupport.com/documentation/viewarticle.php?aid=73&pid=3

[Guest]

Thanks very much for the advice which I'm about to try. However, I don't have a php_mysql.dll file anywhere on my PC!
I'm using PHP version 5.2.3 - is it possible that the dll could have been incorporated into another? My version of MySQL is 5.0.41.

[MikeL7]

You should look in the php folder, normally its C:\php\ext that folder is full of dlls, the dll is in there you need to move to the system32 folder check the link i followed it and presto mysql worked!

[Guest]

<p>I've done a complete search on all the hard drives on my machine. The file does not exist.</p>

Ken

[MikeL7]

You need to look in the folder C:\php\ext the dll might not show up in a xp search, if you are using php 5.2.3 then it will be there
Click >my computer >Local Disk (C:) >php >ext>
the ext folder is full of dlls look for php_mysql.dll, if you installed your php somewhere else then look there for the php folder, if you still cant find it send a private message and i will email you the dll in a zip file, it has to be somewhere because it comes with php, unless you deleted the php folder from your computer

[Guest]

Ah! That explains why I couldn't find the file - I had no ext folder at all.

I've installed the mysql extension and copied the php_mysql.dll into windows\system32. Running phpinfo() still doesn't show mysql anywhere in the list although I've restarted everything.

Tried again to make a DW connection - now I get a different error message:-
"HTTP Error Code 401 Unauthorised"

This doesn't make sense since I can access MySQL from the command line using the same username and password!

Ken

[MikeL7]

Look in your php.ini file and make sure you removed the ; before the lines, as the ; makes the line into a comment, the php.ini file should be in C:\windows als remember to put C:\PHP\libmysql.dll in the system32 folder also
extension=php_mysql.dll
extension=php_mysqli.dll

they are under the section windows extensions and there is a long list

[Guest]

I've checked and double-checked all that and everything is as you suggest.

Same problem as in my previous message.