PHP MySQL library version 5.0.67 differs from your MySQL server version 5.1.30

Written by Mike Young on December 31, 2008 at 7:04 am

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).

MIKE'S CODE SNIPPET

PHP:

1. /**
2. * Warning about different MySQL library and server version
3. * (a difference on the third digit does not count).
4. * If someday there is a constant that we can check about mysqlnd, we can use it instead
5. * of strpos().
6. * If no default server is set, PMA_DBI_get_client_info() is not defined yet.
7. */
8. //comment added to ignore the library mismatch
9. /*
10. if (function_exists('PMA_DBI_get_client_info')) {
11.     $_client_info = PMA_DBI_get_client_info();
12.     if ($server> 0 && strpos($_client_info, 'mysqlnd') === false && substr(PMA_MYSQL_CLIENT_API, 0, 3) != substr(PMA_MYSQL_INT_VERSION, 0, 3)) {
13.         trigger_error(PMA_sanitize(sprintf($strMysqlLibDiffersServerVersion,
14.                 $_client_info,
15.                 substr(PMA_MYSQL_STR_VERSION, 0, strpos(PMA_MYSQL_STR_VERSION . '-', '-')))),
16.             E_USER_NOTICE);
17.     }
18.     unset($_client_info);
19. }
20. */ //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.

Comments (7)

Category: Techy Stuff

• Add this post to
• Del.icio.us -
• Digg

Name (required)

Mail (will not be published) (required)

Website

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>