Problem installing MYSQL with PHP

[klitscher]

Hello,

I'm having some problems installing MySql with PHP and Apache2.  I followed the guide athttp://www.expertsrt.com/tutorials/Matt/install-apache.html and did everything exactly what it says.  I have installed Apache/PHP5 and Mysql from scratch and have apache and php5 working well.  It's installed on an XP box used just for development. I'm able to serve up phpinfo fine.  I am also able to use mysql to run on the command line.  I've uncommented extension=php_mysql.dll in php.ini but I can't for the life of me get phpinfo to show the mysql info.  I'm able to manipulate the php.ini file to change other extensions, but not mysql or mysqli, and the dll's are in the right spot.  Any help?  I wish i could show you, but like i said, it's a development machine and not online.  Thanks in advance.

I have also posed this question at PHPFreaks.com and the suggested resolutions and responses are here: http://www.phpfreaks.com/forums/index.php?topic=99751.0

Thanks,
Ken

[sajuks]

Few things to check :
Check the location of your php,ini file .Are you working with the right ini file? The php,ini file location will be available to you with the phpinfo() fnction.

Do you have multiple copies of libmysql.dll. DO a search from windows explorer to confirm.Ensure that the libmysql.dll are both of the same versions (Did you upgrade from an older version  ? ) .If not available in the ystem32 directory yhen Copy libmysql.dll to the system32 directory .

Set the extension_dir in php.ini to the extension directory of your PHP installation directory (e.g.extension_dir=d:\php\ext)
Uncomment the line extension=php_mysql.dll

[klitscher]

Okay, that did it....There were other versions of libmysql.dll in system32 from when I installed sokkit to test it out...apparently uninstalling sokkit does not remove these...I went through my php root folder and deleted all of the the same files in system32 and all is well...thanks for the help!

Ken

[COBOLdinosaur]

Nice catch Saju.  :thumbup:

[nicholassolutions]

Hi Ken,

I'm glad to see you took my advice to come to the forum, and even happier to see you got your problem sorted out. Hats off to Saju for a really nice catch - it takes a real veteran to spot something like that, when none of the information given would suggest it  :notworthy:

[klitscher]

I appreciate the help here, and have noticed that you are looking for more forum posts, so i'll come here when (and it will probably be soon and often) i'm struggling setting this stuff up and making it run as it should...i'll be back

Ken

[sajuks]

:oops:  :oops:
you guys hell bent on embarassing me are you ?
Glad we could solve it for you ken.

[COBOLdinosaur]

you guys hell bent on embarassing me are you ?

Just encouraging continued participation... Maybe get you to consider writing an article, so we can make you famous.  :^)

[guldar]

i having the same problem.  i followed matts guide.  I followed what sajuks  suggested

and I still don't have a mysql section on my phpinfo.php

any other ideas?  I'm almost ot the point where I'm going to wipe all that crap off my computer completly and start over.  and I really don't want to do that.

[DougB]

Hey Gang,

Oh boy, another newbie for you with dozens of questions. I too followed the same article and ended up with the same problem, I can't get my MySql info to show when I do a localhost/phpinfo.php run. My libmysql.dll file is showing up in my folders D:/webserver/php and my D:/webserver/MySql/bin but not in my system32 folder. Should I copy and paste it into my system32 folder in Widows?

At this point I have done everything else (including uncommenting the extension=php_mysql.dll in php.ini). PLease advise before I go further...

Many thanks gang for your help here,

DougB

[rdivilbiss]

My libmysql.dll file is showing up in my folders D:/webserver/php and my D:/webserver/MySql/bin but not in my system32 folder. Should I copy and paste it into my system32 folder in Widows?

You can do that, but copy the most recent version.

One problem I have with that method is updates.  Every time you update MySQL you'll need to remember to copy that file to system32.

I would first try editing your computer's path statement to append the MySQL bin directory.

e.g. Right-Click MyComputer, choose Properties, the Advanced tab, Environment variables button, scroll the system variables to find path, click and choose the edit button. Append ;D:/webserver/MySql/bin to the end.  You'll probably need to reboot.

Now when you installed MySQL, following Matt's tutorial, he had the include the MySQL bin directory in Windows path checkbox "checked" during install, and if you also choose that option it should be in your path already.  If the path to the MySQL\bin directory is in your path environment variable and it still doesn't work, copy the lib file to system32.

[DougB]

rdivilbiss,

Checked to see if the appended D:/webserver/MySql/bin/libMySql.dll was in the "path" variable first. It was there already. I then pasted it (libMySql.dll) into my sys32 folder where it wasn't. Rebooted the box and then opened Apache and did anhttp:// localhost/phpinfo.php test. The MySql information is still not there. Have I missed something here or what am I doing wrong...? Many thanks for your patience with a newbie to php and server environments.
BTW everything was new downlaod yesterday when I originally started so I'm assuming I have the most recent files. The Apache server and PHP are coming up fine...The MD5 codes were also verified as per Matt's instructions with all files verifying properly before installation...
DougB

[klitscher]

Doug,

A couple of things that helped me figure this out when I had a problem:

Also verify that PHP is using the correct php.ini too, by running the phpinfo function. Check that Configuration File (php.ini) Path is pointing to the correct folder in which your php.ini file is located in. If PHP is not pointing to the correct php.ini file then, Add the following line:

Code:

PHPIniDir "C:/php"

Change C:/php to the correct folder location in which the php.ini file is located in. Restart Apache and check that php is using the correct php.ini file.

If it is using the correct php.ini and mysql extension still isn't loaded, Check that the extension_dir setting is point to PHPs extension folder which stores all your extensions in. Also find display_startup_errors = off and change off to on. Save your php.ini and restart Apache. If PHP is having any trouble loading up it should popup a little error message with whats wrong.


Ken

[DougB]

Greeting Gang,

The correct path for the new install is D:/webserver/folders(MySql,php, apache)

This information is taken from my php.ini

extension_dir = D:webserverphpext
extension=php_mysql.dll

From my phpinfo.php information: Configuration File (php.ini) Path  D:\webserver\php\php.ini 

Are these settings correct?

Thanks again guys but it still ain't showing up...sigh
DougB

[stone]

For what it's worth, I'm in the same boat. My situation is nearly identical to DougB's, except I'm also currently unable to change my PHPIniDir for some sinister reason. I'd really appreciate any help.

-Jason