can't connect to mySQL( unidentified error)

Forum|Forum|18 years ago
June 17, 2007
2 replies
663 views

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

Server side applications

This topic has been closed for replies.

M

MikeL7

Inspiring

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

A

Anonymous

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

M

MikeL7

Inspiring

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

M

MikeL7

Inspiring

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

A

Anonymous

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.

M

MikeL7

Inspiring

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!

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded