Results 1 to 9 of 9
-
10-25-2007, 06:32 AM #1Junior Guru
- Join Date
- Apr 2007
- Posts
- 180
What version of MySQL do I really have?
I need MySQL 5.x for my IPB forum and took one host, but I cannot understand what version of MySQL i have, as:
cPanel says:
MySQL version: 5.0.45-community
but phpMyAdmin says:
Server version: 5.0.45-community
MySQL client version: 4.1.22
What version of MySQL do I really have?
What is difference with Server and client? and why version of client is not 5 ?!
Last edited by Glostar; 10-25-2007 at 06:44 AM. Reason: spelling correction
-
10-25-2007, 06:34 AM #2Web Hosting Evangelist
- Join Date
- Jul 2006
- Location
- Montreal, Canada
- Posts
- 497
The client version is the one that PHP uses or that is compilied with PHP as far as I know, the version of the MySQL server is 5 but you are running a 4 client.
VEXXHOST, Inc.
Secure & Reliable Hosting Solutions for Developers & Enterprises
High Performance OpenStack® Public Cloud | Cloud Servers | Web Hosting
-
10-25-2007, 06:42 AM #3Junior Guru
- Join Date
- Apr 2007
- Posts
- 180
-
10-25-2007, 08:38 AM #4Web Hosting Master
- Join Date
- Mar 2003
- Location
- Canada
- Posts
- 9,072
Your version of MySQL is 5.0.45... ignore the MySQL client version under phpMyAdmin. I see the same results on a few servers, where I know MySQL 4 was never installed...
RACK911 Labs | Penetration Testing | https://www.RACK911Labs.ca
www.HostingSecList.com - Security Notices for the Hosting Community.
-
10-25-2007, 09:10 AM #5Web Hosting Master
- Join Date
- Mar 2007
- Location
- UK
- Posts
- 852
Client is just the system used to connect to the mysql database, this is not always the same version as the server itself due to the fact they may not need to bring out a new client when they bring out a new server.
Think of it as in a client is what is between php and mysql server.ZXPlay
Premium Virtual Private Servers | Dedicated Media Streaming Servers
Dedicated Resources | EU Based
www.zxplay.co.uk
-
10-25-2007, 03:32 PM #6Web Hosting Master
- Join Date
- Oct 2004
- Location
- Kerala, India
- Posts
- 4,771
Use the following command from shell to know the exact versions.
rpm -qa | grep MySQLDavid | www.cliffsupport.com
Affordable Server Management Solutions sales AT cliffsupport DOT com
CliffWebManager | Access WHM from iPhone and Android
-
10-25-2007, 04:11 PM #7Junior Guru
- Join Date
- Apr 2007
- Posts
- 180
-
10-25-2007, 07:10 PM #8Hosting Billing Master
- Join Date
- May 2003
- Location
- California, USA, Earth
- Posts
- 1,098
This is your MySQL version
MySQL version: 5.0.45-community
the rpm -qa | grep MySQL command won't necessarily work for you.. I believe cPanel installs MySQL from source so there won't be an RPM.
-
10-26-2007, 12:52 AM #9Web Hosting Master
- Join Date
- Oct 2004
- Location
- Kerala, India
- Posts
- 4,771
David | www.cliffsupport.com
Affordable Server Management Solutions sales AT cliffsupport DOT com
CliffWebManager | Access WHM from iPhone and Android