not recognizing mysql_connect() or mysql functions

sfullman

Hi There,

Am vnc'ing into a clients server who has win2003 server and apache 2.0.x and PHP 5 and mysql (5 I think). I run a linux server myself, but once installed a working WAMP platform (w for windows) on an old laptop.

apache sees php but apparently not mysql. running a phpinfo(), I don't see any reference to the mysql socket or anything like that.

My client's IT guy is totally a windows guy and doesn't know for sure. the error I'm getting is:

unrecognized function mysql_connect() on line __ .. etc.

any ideas? and many thanks.

Samuel

michaewlewis

I've been having the exact same problem on my linux box.
Not recognizing MySQL anything...

looking forward to help! 🙂

CaptainNinja

Same, my windows machine won't recognize. These are the things I have done:

Installed apache 2.055 / PHP 5.1.2

Configured httpd.conf according to php's install.txt

uncommented php.ini's mysql extension.

made sure extension_dir was set properly

moved libmysql.dll to the windows folder (or you could set it up in path but i just
want to get it running for now)

tested to see if php works, it does.

restarted server

tested php's mysql functions, none are recognized.

Which part did I do wrong?

gitab

yes php5 doesnt have mysql support builtin ! i recommend u to download the zip file instead of the installer.. i had some problems with the MSI installer.

change ur php.ini 's extension_dir value to c:\php\ext
also uncomment the phpmysql extension from the list

also in apache config file
let the phpIniDir to be C:\php

make sure u rename the php_dist to php.ini
keep the php.ini in the php folder then copy libmysql to the system32 folder which is inside windows. restart the server or test the config.. then execute phpinfo() . you should be alright by then.. see for mysql module in the info list.

Houdini

For Windows make sure for PHP 5 these extensions are done. There are two mysql.dll's

;extension=php_msql.dll
extension=php_mssql.dll //also not necessary
extension=php_mysql.dll//make sure this is uncommented
extension=php_mysqli.dll// not necessary but I'd uncomment it too
;extension=php_netools.dll
;extension=php_ntuser.dll
;extension=php_oci8.dll
;extension=php_oggvorbis.dll
extension=php_openssl.dll
;extension=php_parsekit.dll
extension=php_pdf.dll
extension=php_pdo.dll
;extension=php_pdo_firebird.dll
extension=php_pdo_mssql.dll
extension=php_pdo_mysql.dll //and this one too

CaptainNinja

I found the problems I had were
1. I used the MSI installer then copied over the dlls I needed from the zip (hey, worth a shot)
2. PATH in windows just wasnt liking what I was telling it, so i just threw the dlls in system32

Works like a charm, thanks!