PHP Server version different from client version... I need them the same

I am using CentOS 6.4. When I log into mysql via SSH doing "mysql -u root -p", MySQL Server is reported as 5.1.69. But when I do a phpinfo it reports I am using a different client version:
mysql Client API Version: mysqlnd 5.0.8-dev - 20102224 - $Id: remove_a_long_number_here$
mysqli API Library Version: mysqlnd 5.0.8-dev - 20102224 - $Id: remove_a_long_number_here$
mysqlnd Version: mysqlnd 5.0.8-dev - 20102224 - $Id: remove_a_long_number_here$
pdo_mysql Version: mysqlnd 5.0.8-dev - 20102224 - $Id: remove_a_long_number_here$

Open in new window

I also recently installed Zend Server 5. So my questions are this:

1. Question 1

Please expand my understand of what version of MySQL is my content management system using... the server version or client version.

2. Question 2

What are some ways to get the mysql client version to match my server version. (I need to maintain PHP 5.3 and am also running Virtualmin/Webmin so solution need to be friendly with that)
LVL 2
matt1237Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
nemws1Connect With a Mentor Database AdministratorCommented:
Your CMS should be seeing a MySQL server of version 5.1.69.  The mysqli (Note the trailing 'i'!!!) is irrelevant (again - it just needs to be compatible).  That is a PHP library and not a system library.
0
 
nemws1Connect With a Mentor Database AdministratorCommented:
The version of mysqli can be whatever it wants to be.  There were versions of mysqli numbered 5.2 and 5.3 - there were never MySQL versions of the same number.  I grant you it is confusing because they are similar, but it can very well be that mysqli version 5.0.8 is using the MySQL 5.1.69 client *library* to connect to MySQL.  So everything is all good.
0
 
nemws1Database AdministratorCommented:
Maybe to clarify more.... mysqli is a PHP library.  It *uses* a MySQL client library to connect to MySQL.  This client and the version of the server need to work together (they don't need to be the same - just compatible).

The best thing for you to do - test and see if it works.  If it does, everything is good. ;-)
0
 
matt1237Author Commented:
I have a content management system that has a minimum mysql requirement of 5.1.x.  What version does my CMS see? Is the mysql client version irrelevant to my minimum mysql 5.1 requirement?
0
 
matt1237Author Commented:
Awesome, thank you.  That answers my question.  Maybe you know something about this other question I'm also asking right now to from my Apache error logs...

Apache error logs say... unable to write 'random state' e is 65537 (0x10001)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.