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 10-25-2007, 06:32 AM
Glostar Glostar is offline
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
Reply With Quote


Sponsored Links
  #2  
Old 10-25-2007, 06:34 AM
vx|brian vx|brian is offline
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

Reply With Quote
  #3  
Old 10-25-2007, 06:42 AM
Glostar Glostar is offline
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?

Reply With Quote
Sponsored Links
  #4  
Old 10-25-2007, 08:38 AM
Patrick Patrick is offline
Security Ninja
 
Join Date: Mar 2003
Location: Canada
Posts: 8,703
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
250+ Vulnerabilities Found - Get a Quote @ http://www.RACK911Labs.com

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

Reply With Quote
  #5  
Old 10-25-2007, 09:10 AM
Ashley Merrick Ashley Merrick is offline
Web Hosting Master
 
Join Date: Mar 2007
Location: UK
Posts: 768
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

Reply With Quote
  #6  
Old 10-25-2007, 03:32 PM
david510 david510 is offline
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

Reply With Quote
  #7  
Old 10-25-2007, 04:11 PM
Glostar Glostar is offline
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.

Reply With Quote
  #8  
Old 10-25-2007, 07:10 PM
pphillips pphillips is offline
Web Hosting Master
 
Join Date: May 2003
Location: California, USA, Earth
Posts: 994
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

Reply With Quote
  #9  
Old 10-26-2007, 12:52 AM
david510 david510 is offline
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 With Quote
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?
Advertisement:
Web Hosting News:



 

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?