PhpMyAdmin MySQL Version Difference

[dravekx]

When I log into 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.

[dravekx]

I just tried updating the MySQL server... I still get the same error.

[sari42]

try

Code: Select all

$cfg['Servers'][$i]['extension'] = 'mysqli';


(instead of "mysql") in your config.inc

will be fixed in pma 2.11.5, see https://sourceforge.net/tracker/index.p ... tid=377408

[dravekx]

try

Code: Select all

$cfg['Servers'][$i]['extension'] = 'mysqli';


(instead of "mysql") in your config.incwill be fixed in pma 2.11.5, see https://sourceforge.net/tracker/index.p ... tid=377408

Did that... TY Sari, but now I get this error:

Connection for controluser as defined in your config.inc.php failed.

[dravekx]

NVM.. easy fix.. I just needed to change this:

$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';

to this:

$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = '';

[sari42]

this was already discussed in the bug-tracker (IIRC, see link above) .

how to fix pma 2.11.<5 (if you need to use mysql):
in libraries/dbi/mysql.dbi.lib.php
change line 84 from

Code: Select all

if (empty($link) && ! $is_controluser) {

to

Code: Select all

if (empty($link)) {

p.s.
a controluser must only be set in config.inc.php after creating such user, see http://wiki.cihar.com/pma/controluser .

[dravekx]

So changing this:

$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

to this:

$cfg['Servers'][$i]['controluser'] = 'actual username in database';
$cfg['Servers'][$i]['controlpass'] = 'actual password in database';

Doesnt fix the problem? because I did that and its working fine now WITH MYSQL and not MYSQLi...

[sari42]

it was merely meant as an explanation/hint for any other visitors

[dravekx]

it was merely meant as an explanation/hint for any other visitors

ahhh.. ok... sry... lol. I went back and removed the data for the controluser/controlpass and changed to MySQLi after a misfortunate database crash and SSL error. I love this stuff!