MYSQL Version in Linux

Posted on 2007-10-12
Last Modified: 2013-12-16
I ran a mysql -V in Linux to see what version of mysql is on my server.

What version is this:

"mysql  Ver 14.7 Distrib 4.1.21, for portbld-freebsd6.0 (i386) using  5.0"

I am very confused as it saysin Using 5.0 at the end.


Question by:robertarmbrister
    LVL 48

    Accepted Solution

    using 5.0 tells you that you mysql-client is using readline version 5.0. On my SuSe i get for  mysql -V :
    mysql  Ver 14.12 Distrib 5.0.18, for suse-linux (x86_64) using readline 5.1
    * 14.12 is the version the mysql-client tool
    * 5.0.18 is the version of the used mysql-client-libs
    * 5.1 is the version of readline used (so the text readline is missing in your bsd-port)

    LVL 30

    Assisted Solution

    by:Kerem ERSOY
    BTW - you told you're running Linux but your mysql is not agree that. It seems to me that you're rather running freebsd but not linux.  

    The version of mysql you're running is "4.1.21" and "5.0" is the version of readline as hernst42 told. This library is responsible for reading your responses from the console.

    To display full version varables you'd run mysql and issue this command:
    # mysql
    > show variables like "%version%"

    Also if you want to display your os version use this command
    uname -a

    LVL 30

    Expert Comment

    by:Kerem ERSOY
    oops please don't forgert to add a semicolon after the show variables command such as this:
    > show variables like "%version%";

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
    Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

    733 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now