Results 1 to 9 of 9
  1. #1

    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

  2. #2
    Join Date
    Jul 2006
    Location
    Montreal, Canada
    Posts
    473
    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. #3
    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?

  4. #4
    Join Date
    Mar 2003
    Location
    Canada
    Posts
    8,861
    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
    400+ Vulnerabilities Found - Free Quote @ https://www.RACK911Labs.com

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

  5. #5
    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

  6. #6
    Join Date
    Oct 2004
    Location
    Kerala, India
    Posts
    4,743
    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. #7
    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. #8
    Join Date
    May 2003
    Location
    California, USA, Earth
    Posts
    1,025
    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. #9
    Join Date
    Oct 2004
    Location
    Kerala, India
    Posts
    4,743
    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

  10. Newsletters

    Subscribe Now & Get The WHT Quick Start Guide!

Related Posts from theWHIR.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •