Solved

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

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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

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…
There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

623 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