Solved

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

Posted on 2013-05-31
5
862 Views
Last Modified: 2013-05-31
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)
0
Comment
Question by:matt1237
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 23

Assisted Solution

by:nemws1
nemws1 earned 500 total points
ID: 39211802
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
 
LVL 23

Expert Comment

by:nemws1
ID: 39211810
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
 
LVL 2

Author Comment

by:matt1237
ID: 39211812
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
 
LVL 23

Accepted Solution

by:
nemws1 earned 500 total points
ID: 39211822
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
 
LVL 2

Author Comment

by:matt1237
ID: 39211833
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

Featured Post

Don't Cry: How Liquid Web is Ensuring Security

WannaCry is just the start. Read how Liquid Web is protecting itself and its customers against new threats.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

These days socially coordinated efforts have turned into a critical requirement for enterprises.
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to dynamically set the form action using jQuery.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question