/    Sign up×
Community /Pin to ProfileBookmark

phpmyadmin – error ( cannot load mysql )

Hey, I’m a noob, please point me to the proper place if I’ve knocked on the wrong thread.

  • 1.

    I’ve read just about every faq,post I could find on the subject and still cannot resolve my issue:
    phpMyAdmin – Error
    Connot load mysql extension. Please check your PHP configuration.

  • 2.

    System:
    WinXP Pro SP3
    Apache 2.2.9
    PHP 5.2.6
    myPhpAdmin 2.11.9.1

  • 3.

    php(info):
    Loaded Config File: C:phpphp.ini

  • 4.

    php.ini ( snippet )

    extension_dir = “C:/php/ext/”

    ;extension=php_ldap.dll
    extension=php_mbstring.dll

    extension=php_mysql.dll
    exension=php_mysqli.dll

  • 5.

    Server error log
    httpd.exe: Could not reliably determine the server’s fully qualified domain name, using 192.168.0.100 for ServerName
    httpd.exe: Could not reliably determine the server’s fully qualified domain name, using 192.168.0.100 for ServerName
    PHP Warning: PHP Startup: Unable to load dynamic library ‘C:/php/ext/php_mysql.dll’ – The specified procedure could not be found.rn in Unknown on line 0
    PHP Warning: PHP Startup: Unable to load dynamic library ‘C:/php/ext/php_mysqli.dll’ – The specified procedure could not be found.rn in Unknown on line 0
    [Sun Sep 28 00:02:42 2008] [notice] Child 2560: Child process is running
    [Sun Sep 28 00:02:42 2008] [notice] Child 3772: Released the start mutex
    [Sun Sep 28 00:02:42 2008] [notice] Child 2560: Acquired the start mutex.
    [Sun Sep 28 00:02:42 2008] [notice] Child 2560: Starting 64 worker threads.
    [Sun Sep 28 00:02:42 2008] [notice] Child 3772: All worker threads have exited.
    [Sun Sep 28 00:02:42 2008] [notice] Child 2560: Starting thread to listen on port 80.
    [Sun Sep 28 00:02:42 2008] [notice] Child 3772: Child precess is exciting

  • 6.

    php_mysql.dll & php_mysqli.dll are located within the C:/php/ext folder as is default

  • 7.

    This is on a clean XP Pro install, only programs loaded are apache, php, mysql, phpmyadmin on a 1T drive

  • 8.

    mysql works properly with the command line

  • Thanks for any assistance.

    Hag

    PS the server has no issues running multiple remote websites and no issues with pulling up docs via localhost. I’ve been doing this for quite some time, just thought I should step into the 21 century and start using a GUI database admin…

    to post a comment
    PHP

    3 Comments(s)

    Copy linkTweet thisAlerts:
    @ratcatemeSep 28.2008 — i had heaps of problems getting mysql to work on windows have you got the right php_mysql.dll file for your mysql server i had heaps of problems with that.

    looking at the mysql website the current release is for php 5.2.1 i dont know if that would work with your php version.

    what mysql version are you using?

    i use linux now far better ?

    Scott.
    Copy linkTweet thisAlerts:
    @hagauthorSep 28.2008 — It seems alot of users are having issues. I'm going to write a doc as soon as I get it figured out. LOL

    mySQL 5.0.67

    Good call on the correct version of the php_mysql.dll file. I can only assume it is correct as it came in the zip php folder.

    Any other guesses?

    Hag

    PS I'm not brave enough to go linux on my server. LOL
    Copy linkTweet thisAlerts:
    @ratcatemeSep 28.2008 — try download the php_mysql.dll file form mysql.com also i think you can right click a dll file to get version info from it.

    it should be compatible with your php and mysql i think

    and rember linux is not that hard and there are millions more tutorials on how to do everything

    Scott.
    ×

    Success!

    Help @hag spread the word by sharing this article on Twitter...

    Tweet This
    Sign in
    Forgot password?
    Sign in with TwitchSign in with GithubCreate Account
    about: ({
    version: 0.1.9 BETA 5.18,
    whats_new: community page,
    up_next: more Davinci•003 tasks,
    coming_soon: events calendar,
    social: @webDeveloperHQ
    });

    legal: ({
    terms: of use,
    privacy: policy
    });
    changelog: (
    version: 0.1.9,
    notes: added community page

    version: 0.1.8,
    notes: added Davinci•003

    version: 0.1.7,
    notes: upvote answers to bounties

    version: 0.1.6,
    notes: article editor refresh
    )...
    recent_tips: (
    tipper: @AriseFacilitySolutions09,
    tipped: article
    amount: 1000 SATS,

    tipper: @Yussuf4331,
    tipped: article
    amount: 1000 SATS,

    tipper: @darkwebsites540,
    tipped: article
    amount: 10 SATS,
    )...