So, you've just managed to get everything working with the latest version of phpMyAdmin and MySQL 5.1.30, but then you get this annoying message at the bottom of your admin screen:
Your PHP MySQL library version 5.0.67 differs from your MySQL server version 5.1.30. This may cause unpredictable behavior.
What do you do?
Well, don't fret. This is more of an annoyance than anything else. We can go down the path of updating various libraries, which could lead to other problems, we can ignore the warning, or we can disable the warning message. In my case, I've opted to disable the warning in phpMyAdmin/main.php (lines 295 through 311).
-
/**
-
* Warning about different MySQL library and server version
-
* (a difference on the third digit does not count).
-
* If someday there is a constant that we can check about mysqlnd, we can use it instead
-
* of strpos().
-
* If no default server is set, PMA_DBI_get_client_info() is not defined yet.
-
*/
-
//comment added to ignore the library mismatch
-
/*
-
if (function_exists('PMA_DBI_get_client_info')) {
-
$_client_info = PMA_DBI_get_client_info();
-
if ($server> 0 && strpos($_client_info, 'mysqlnd') === false && substr(PMA_MYSQL_CLIENT_API, 0, 3) != substr(PMA_MYSQL_INT_VERSION, 0, 3)) {
-
trigger_error(PMA_sanitize(sprintf($strMysqlLibDiffersServerVersion,
-
$_client_info,
-
substr(PMA_MYSQL_STR_VERSION, 0, strpos(PMA_MYSQL_STR_VERSION . '-', '-')))),
-
E_USER_NOTICE);
-
}
-
unset($_client_info);
-
}
-
*/ //ending comment to ignore the mismatch
This simple little change will get rid of the annoyance and things will continue to work fine. You'll have a nice clean interface without the worry of having mucked up something on your system. Of course you could simply do things via the CLI and avoid phpMyAdmin. That's another option.
02/01/2009 at 8:30 am Permalink
This is a test of my openid registration.
06/01/2009 at 10:05 am Permalink
Thanks,
that was very usefulle cos that warning went on my nerves ; )
06/01/2009 at 1:38 pm Permalink
Glad I could help.
09/01/2009 at 2:48 pm Permalink
Nice hack. Thanks. Any idea where this 5.0.67 is coming from?
12/01/2009 at 9:06 am Permalink
Nik: Thanks! I’m not sure where it’s coming from. I could probably look into it, but am having fun working on new adventures now
16/05/2009 at 10:33 am Permalink
Or simply use 5.0.67 version:
http://downloads.mysql.com/archives.php?p=mysql-5.0&v=5.0.67
29/06/2009 at 3:10 am Permalink
Wonderful! You made my day and now, I have the peace of mind I was looking for…