Solved

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

Posted on 2013-05-31
5
856 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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
migrating to phpbb forum from vBulletin 4.2 3 37
Wordpress and Wufoo 1 39
Problem with MySQL query - graph 3 26
php output utf-8 problem 6 23
It is possible to boost certain documents at query time in Solr. Query time boosting can be a powerful resource for finding the most relevant and "best" content. Of course the more information you index, the more fields you will be able to use for y…
This article discusses four methods for overlaying images in a container on a web page
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

733 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