TechSpot

MySQL & PhpMyAdmin on WinXP

By dravekx
Feb 8, 2008
  1. Hello,

    Ive installed MySQL server 5.0 with PhpMyAdmin 2.11.14 on Windows XP. When I login to phpmyadmin, I get this error at the bottom:

    Your PHP MySQL library version 5.0.51 differs from your MySQL server version 3.23.32. This may cause unpredictable behavior.

    Anyone have a clue????
     
  2. jobeard

    jobeard TS Ambassador Posts: 13,468   +327

    First though is "Did you verify the system requirements for each"?

    Which XP {home/pro} are you running and are you current with the updates?
     
  3. dravekx

    dravekx TS Rookie Topic Starter

    Thanks for the inquisition, jobeard! Yes. I'm running XP Home... but I've modified home to handle professional standards and have complete updates with Microsoft. PhpMyAdmin 2.11.4 has a bug which should be fixed in version 2.11.5. The fix is simple:

    Code:
    Open phpmyadmin\config.inc.php
    Find:
    $cfg['Servers'][$i]['extension'] = 'mysql';
    Replace with:
    $cfg['Servers'][$i]['extension'] = 'mysqli';
    Find:
    $cfg['Servers'][$i]['controluser'] = 'pma';
    $cfg['Servers'][$i]['controlpass'] = '';
    Replace with:
    $cfg['Servers'][$i]['controluser'] = '';
    $cfg['Servers'][$i]['controlpass'] = '';
    
    I feel like a guru after three long days of research and lots of coffee... If anyone has any questions, feel free to ask.
     
Topic Status:
Not open for further replies.


Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.