Solved

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

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
The viewer will learn how to count occurrences of each item in an array.
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…

770 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