PHPMyadmin中的数据库客户端版本

Question

I installed mysql 5.6 all packages completely and I have the updated PHPMyadmin and PHP 7.0 and have latest php7.0-mysql library installed

My server is showing the version no. as MySQL 5.6 when test from mysql terminal as well as in PHPMyadmin.

But, the database client version is showing somewhere around 5.0xxx

I browsed through and saw that I had to update mysqlnd (What really causes PHP MySQL library version differs from your MySQL server version?)

But I am not sure how to proceed. What should I do? Thanks in advance

Running Ubuntu, Apache2

Answer 1

MySQL Server and MySQL Client mysqld are two different executable programs, with different versions. MySQL don't always need to update the client tools every time there is a new server release.

there may still be newer versions of the library, and the link I post below shows how to do it, however you are unlikely to encounter any issues.

Please refer to this Q&A Quote

In theory, this should not cause any real problem : minor versions tend to be compatible ; but you might need to update the library that's used by PHP ; maybe some package like "libmysql", or something like that (I don't have a Debian machine)

Is the other system with PHP 5.6 a different OS than ubuntu? I believe the issue is that the different packages that you download with different OS's will be packaged with different libraries, this may be for various reasons, such as compatibility with the OS.