hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : What version of MySQL do I really have?
Reply

Forum Jump

What version of MySQL do I really have?

Reply Post New Thread In Hosting Security and Technology Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old
WHT Addict
 
Join Date: Apr 2007
Posts: 169
Question

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


Sponsored Links
  #2  
Old
Web Hosting Evangelist
 
Join Date: Jul 2006
Location: Montreal, Canada
Posts: 455
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

  #3  
Old
WHT Addict
 
Join Date: Apr 2007
Posts: 169
Quote:
Originally Posted by vx|brian View Post
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.
Sorry do not understand ... what is really client ?

I really run PHP5 using .htaccess with record "AddHandler application/x-httpd-php5 .php .php4 .php3 .phtml"

so, why client version is 4 ?

how can I compile 5 version?

Sponsored Links
  #4  
Old
Security Ninja
 
Join Date: Mar 2003
Location: Canada
Posts: 8,750
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...

__________________
Patrick William | RACK911 Labs | Software Security Auditing
300+ Vulnerabilities Found - Get a Quote @ http://www.RACK911Labs.com

www.HostingSecList.com - Security notices for the hosting community.

  #5  
Old
Web Hosting Master
 
Join Date: Mar 2007
Location: UK
Posts: 805
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.

__________________
ZXHost
Premium Virtual Private Servers | SSD Virtual Private Servers
Dedicated Resources | EU Based
www.zxhost.co.uk

  #6  
Old
Web Hosting Master
 
Join Date: Oct 2004
Location: Kerala, India
Posts: 4,740
Use the following command from shell to know the exact versions.

rpm -qa | grep MySQL

__________________
David | www.cliffsupport.com
Affordable Server Management Solutions sales AT cliffsupport DOT com
CliffWebManager | Access WHM from iPhone and Android

  #7  
Old
WHT Addict
 
Join Date: Apr 2007
Posts: 169
Quote:
Originally Posted by david510 View Post
Use the following command from shell to know the exact versions.

rpm -qa | grep MySQL
Unfortunately, I do not have access to SSH.

  #8  
Old
Web Hosting Master
 
Join Date: May 2003
Location: California, USA, Earth
Posts: 1,000
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.

__________________
Blesta - Professional Billing Software
Innovation that benefits the user experience
Trial - Demo | 866.478.7567 | Twitter @blesta

  #9  
Old
Web Hosting Master
 
Join Date: Oct 2004
Location: Kerala, India
Posts: 4,740
Quote:
Originally Posted by pphillips View Post
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.
Cpanel install Mysql as rpm only.

__________________
David | www.cliffsupport.com
Affordable Server Management Solutions sales AT cliffsupport DOT com
CliffWebManager | Access WHM from iPhone and Android

Reply

Related posts from TheWhir.com
Title Type Date Posted
Google Releases Hosted Database Service Cloud SQL to General Availability Web Hosting News 2014-02-12 13:46:02
Flexiant Launches Cloud Orchestrator Version 4, Plans OpenStack Support Web Hosting News 2013-11-04 14:09:12
Google Cloud Provides Support For Native MySQL Connections Web Hosting News 2013-11-01 14:36:06
PHP Creator Rasmus Lerdorf Joins Jelastic as Advisor Web Hosting News 2013-07-05 13:06:00
HostingCon 2013: Media Temple Updates Managed VPS Hosting, Launches CloudTech Support Web Hosting News 2013-06-18 09:38:06


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
WHT Host Brief Email:

We respect your privacy. We will never sell, rent, or give away your address to any outside party, ever.

Advertisement:
Web Hosting News:
WHT Membership
WHT Membership



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?