WEB MySQL On PHP5 / Apache2.2

Discussion in 'OT Technology' started by Fase, Feb 12, 2010.

  1. Fase

    Fase Your Face, In A Pickle Jar.

    Joined:
    Apr 6, 2004
    Messages:
    29,540
    Likes Received:
    0
    Location:
    Windsor, Ont, Canada.
    Just downloaded and installed the latest Apache and PHP on a Win XP machine along with MySQL and PHPMyAdmin.

    Problem I'm having is:
    Never had this problem when I installed them all on Server 2008. Anyways, looking at PHP's website I see:

    All the stuff I've Googled as to how to get this to work hasn't helped me. My PHPInfo() doesn't show MySQL linked. Can anyone give me little help here as to where I get the headers for php_mysql.dll?
     
  2. drpepper

    drpepper Active Member

    Joined:
    Nov 13, 2006
    Messages:
    38,076
    Likes Received:
    2
    Location:
    San Antonio
    you need to compile php with mysql support?
     
  3. Supergeek

    Supergeek New Member

    Joined:
    Jan 23, 2007
    Messages:
    1,855
    Likes Received:
    0
    Location:
    Colorado
    WAMP bundle should include MySQL and most of that common crap. Did you install it all separately or get a bundle?
     
  4. Fase

    Fase Your Face, In A Pickle Jar.

    Joined:
    Apr 6, 2004
    Messages:
    29,540
    Likes Received:
    0
    Location:
    Windsor, Ont, Canada.
    All separate.

    I just seem to be missing the php_mysql package which I can't find. PHP's site directs me to MySQL's site, but there's nothing there.
     
  5. telc

    telc OT Supporter

    Joined:
    Aug 29, 2003
    Messages:
    18,580
    Likes Received:
    0
    1. Getting PHP5 to work with MySQL - Official Info [​IMG]

      Unfortunately PHP5 removed built-in support for MySQL. To get it to work, the easiest way is to copy the mysql library file by hand. Open the folder you unzipped your PHP to. Copy the libmysql.dll file (should be located like C:\php\libmysql.dll ) into your Window's System folder (usually C:\Windows\System32\ although might be C:\WinNT\System\ or something).

      Then open up your php.ini in a text editor and search for ;extension=php_mysql.dll and remove the ; infont of that line.

      Restart Apache and see if you get any errors. If it complains about "php_mysql.dll" either your extension directory isn't correct or windows can't find libmysql.dll
     
  6. Fase

    Fase Your Face, In A Pickle Jar.

    Joined:
    Apr 6, 2004
    Messages:
    29,540
    Likes Received:
    0
    Location:
    Windsor, Ont, Canada.
    This is still not solving the problem.

    Event Viewer shows:

    Faulting application httpd.exe, version 2.2.14.0, faulting module php5ts.dll, version 5.2.12.12, fault address 0x000f34bc.
     
  7. 2ofdem

    2ofdem OT Supporter

    Joined:
    Jun 17, 2003
    Messages:
    114,854
    Likes Received:
    8
    Location:
    aus.vic.mel
    install wamp
     
  8. brujito

    brujito New Member

    Joined:
    Aug 10, 2004
    Messages:
    366
    Likes Received:
    0
    Do you have other versions of PHP installed on the system? Happened to me once and took me hours to figure out I was editing the wrong php.ini file.
     
  9. Fase

    Fase Your Face, In A Pickle Jar.

    Joined:
    Apr 6, 2004
    Messages:
    29,540
    Likes Received:
    0
    Location:
    Windsor, Ont, Canada.
    I'm guessing I should uninstall Apache/PHP/MySQL before running wamp?

    I just installed it over top of my Apache/PHP/MySQL and I still get an error in event logs when the program launches. Faulting module php5ts.dll
     
  10. Fase

    Fase Your Face, In A Pickle Jar.

    Joined:
    Apr 6, 2004
    Messages:
    29,540
    Likes Received:
    0
    Location:
    Windsor, Ont, Canada.
    No.
     
  11. SLED

    SLED build an idiot proof device and someone else will

    Joined:
    Sep 20, 2001
    Messages:
    28,118
    Likes Received:
    0
    Location:
    AZ, like a bauce!
    why windows?
     
  12. Fase

    Fase Your Face, In A Pickle Jar.

    Joined:
    Apr 6, 2004
    Messages:
    29,540
    Likes Received:
    0
    Location:
    Windsor, Ont, Canada.
    Because it's just a simple PC that is also running other services (windows only). Not dedicated and won't be heavily used.
     
  13. SLED

    SLED build an idiot proof device and someone else will

    Joined:
    Sep 20, 2001
    Messages:
    28,118
    Likes Received:
    0
    Location:
    AZ, like a bauce!
    virtual pc, install linux, win
     
  14. Fase

    Fase Your Face, In A Pickle Jar.

    Joined:
    Apr 6, 2004
    Messages:
    29,540
    Likes Received:
    0
    Location:
    Windsor, Ont, Canada.
    K well after uninstalling and reinstalling this shit including manual directory cleaning for the 5th time, MySQL has decided that the service won't run anymore. Some fucking fantastic software package here. Never had a fucking problem with any Microsoft IIS/MSSQL and PHP web installer.
     
  15. Fase

    Fase Your Face, In A Pickle Jar.

    Joined:
    Apr 6, 2004
    Messages:
    29,540
    Likes Received:
    0
    Location:
    Windsor, Ont, Canada.
    Error 1067.

    Resolved this by deleting \Documents and Settings\All Users\Application Data\MySQL

    Then install
     
  16. Fase

    Fase Your Face, In A Pickle Jar.

    Joined:
    Apr 6, 2004
    Messages:
    29,540
    Likes Received:
    0
    Location:
    Windsor, Ont, Canada.
    Alright well finally got this shit working.

    Used PHP installer
    http://ca.php.net/get/php-5.2.12-win32-installer.msi/from/a/mirror

    Which has all modules built in so you can add them with the installer. That worked but I had to comment out the MSSQL module because it errors. Don't need it right now and to tired with this shit to bother.
     

Share This Page