Web Hosting Forum Login
Not a member yet? Sign up

How to check the MySQL Version

  • FORUMS
  • WEB DESIGN
  • WEB HOSTING OFFERS
  • ADVERTISING
  • WEB HOSTING
  • REQUEST A HOST
  • BEST WEB HOSTING
  • QUICK MENU
  • REGISTER HERE - Join us for FREE
Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2016
    Posts
    94
    Thanks
    30
    Thanked 2 Times in 2 Posts
    Thumbs Up/Down
    Received: 8/0
    Given: 158/0

    How to check the MySQL Version

    Are there any commands to check MySQL Version on my VPS Centos? I am new to VPS hosting and just bought a new VPS package to install for testing and hosting my sites on it.

  2. #2
    Join Date
    Apr 2016
    Posts
    22
    Thanks
    5
    Thanked 1 Time in 1 Post
    Thumbs Up/Down
    Received: 2/0
    Given: 14/0
    From the Command Line

    Type the following command:

    Code:
    mysql -V
    The output can be as follows

    [email protected][~]# mysql -V
    mysql Ver 14.14 Distrib 5.5.51-38.2, for Linux (x86_64) using readline 5.1

    From the MySQL Command Client

    If you logged into your VPS and running this Mysql command

    Code:
    mysql
    For example, I can get the output as follows

    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 9687
    Server version: 5.5.51-38.2 Percona Server (GPL), Release 38.2, Revision 6a9ff9a

    Copyright (c) 2009-2016 Percona LLC and/or its affiliates
    Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    mysql>

    When you are prompted at mysql> then you can use this command to show the version of your Mysql

    Code:
    SHOW VARIABLES LIKE "%version%";
    It will show the information you need to know.

    For example:

    Code:
    mysql> SHOW VARIABLES LIKE "%version%";
    +-------------------------+------------------------------------------------------+
    | Variable_name           | Value                                                |
    +-------------------------+------------------------------------------------------+
    | innodb_version          | 5.5.51-38.2                                          |
    | protocol_version        | 10                                                   |
    | slave_type_conversions  |                                                      |
    | tls_version             | TLSv1.1,TLSv1.2                                      |
    | version                 | 5.5.51-38.2                                          |
    | version_comment         | Percona Server (GPL), Release 38.2, Revision 6a9ff9a |
    | version_compile_machine | x86_64                                               |
    | version_compile_os      | Linux                                                |
    +-------------------------+------------------------------------------------------+
    8 rows in set (0.01 sec)

    Hope with these commands you can find out which version of MySQL you are using on your VPS.

    Good luck!

  3. #3
    Join Date
    Apr 2017
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thumbs Up/Down
    Received: 4/0
    Given: 4/0
    mysql -V
    or
    mysqld -V

  4. #4
    Join Date
    Jun 2017
    Location
    Estonia
    Posts
    47
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Thumbs Up/Down
    Received: 20/3
    Given: 13/3
    From SSH:
    ysql -V
    From MySQL Command Client:
    mysql
    Or just ask your hosting provider, if they're kind enough.

  5. #5
    Join Date
    Jun 2017
    Posts
    88
    Thanks
    0
    Thanked 1 Time in 1 Post
    Thumbs Up/Down
    Received: 19/0
    Given: 0/0
    Option 1: In case of the command line use the command below.

    mysql -V
    Option 2: If you are using the CPanel then you can check out the about page of the MySQL wizard or the MySQL database page. You can also do the same on the PHPMyAdmin home page. That should show you the MySQL version installed on your server account.

    You can choose either one of the option to look for the mysql version.

  6. #6
    Join Date
    Sep 2017
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thumbs Up/Down
    Received: 0/0
    Given: 0/0
    Try this command: mysql -v

    This is one is easier. If you have a GUI tool, you can check it in the it under "Server Information". Just make sure that you have admin privileges and you are connected to the server. I hope this helps

  7. #7
    Join Date
    Sep 2017
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thumbs Up/Down
    Received: 0/0
    Given: 0/0
    Hi Gjgcint.

    The GUI tool is absolutely considered by many to be much easier to use, than attempting to accomplish the same tasks without the GUI tool. The reason for this is because of what a GUI tool is. A GUI being a Graphical User Interface does just that; it allows users to interact with one another by way of such things such as pictures and animations, as opposed to only text-based commands. An added factor is your kindly reminding us to always first check to verify that we do have administrative privileges; way to go.

  8. #8
    Join Date
    Jul 2017
    Location
    Nashik, Maharashtra, India
    Posts
    177
    Thanks
    0
    Thanked 5 Times in 5 Posts
    Thumbs Up/Down
    Received: 29/0
    Given: 5/0
    That's correct!

    mysql -V

    OR
    mysqld -V

    These command will provide you the total description of MySQL installed on the server.

Newer Threads

  1. DaRecordon
    DaRecordon
    Replies: 6 | Views: 383
    Last post by DaRecordon, 12-30-2016, 07:13 AM
  2. laurence
    IgorG
    Replies: 3 | Views: 682
    Last post by IgorG, 10-10-2016, 05:19 AM
  3. uniwebhosting
    uniwebhosting
    Replies: 0 | Views: 356
    Last post by uniwebhosting, 10-07-2016, 10:11 PM
  4. uniwebhosting
    uniwebhosting
    Replies: 0 | Views: 982
    Last post by uniwebhosting, 10-07-2016, 10:15 PM
  5. Maxoq
    Nixtree
    Replies: 3 | Views: 952
    Last post by Nixtree, 10-18-2016, 10:56 PM

Older Threads

  1. Igor Liferenko
    Maria_C
    Replies: 29 | Views: 2280
    Last post by Maria_C, 06-27-2017, 10:56 AM
  2. Igor Liferenko
    RDO Servers
    Replies: 9 | Views: 1488
    Last post by RDO Servers, 01-09-2017, 12:48 AM
  3. Joseph_Hill
    tlhIngan
    Replies: 1 | Views: 357
    Last post by tlhIngan, 10-06-2016, 08:52 AM
  4. SpecialRDP
    fwh
    Replies: 5 | Views: 508
    Last post by fwh, 10-10-2016, 11:47 AM
  5. David Makogon
    UWH-David
    Replies: 1 | Views: 573
    Last post by UWH-David, 10-06-2016, 10:00 PM

Latest Threads

  1. Raman
    Raman
    Replies: 0 | Views: 10
    Last post by Raman, Today, 05:02 AM
  2. jpsail
    jpsail
    Replies: 4 | Views: 63
    Last post by jpsail, Yesterday, 08:35 PM
  3. Geoffrey09
    Geoffrey09
    Replies: 0 | Views: 25
    Last post by Geoffrey09, 09-19-2017, 02:41 PM
  4. mfin
    24x7servermanageme
    Replies: 3 | Views: 79
    Last post by 24x7servermanageme, Today, 09:13 AM
  5. Nins_809
    24x7servermanageme
    Replies: 3 | Views: 72
    Last post by 24x7servermanageme, 09-20-2017, 11:22 AM

Similar Threads

  1. Chris Worner
    sh-admin
    Replies: 5 | Views: 1234
    Last post by sh-admin, 09-30-2016, 03:30 AM
  2. fwh
    StackNetwork
    Replies: 4 | Views: 709
    Last post by StackNetwork, 09-25-2016, 05:04 AM
  3. coredump
    GswHosting
    Replies: 7 | Views: 1548
    Last post by GswHosting, 09-12-2016, 08:25 AM
  4. TheCompWiz
    FerdieQO
    Replies: 6 | Views: 732
    Last post by FerdieQO, 08-21-2016, 03:00 AM
  5. Natcoweb
    Malabari
    Replies: 9 | Views: 2702
    Last post by Malabari, 05-04-2014, 11:34 AM

Posting Permissions

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

Web Hosting Forum

ForumWeb.Hosting is a web hosting forum where you’ll find in-depth discussions and resources to help you find the best hosting providers for your websites or how to manage your hosting whether you are new or experienced. You’ll find it all here. With topics ranging from web hosting, internet marketing, search engine optimization, social networking, make money online, affiliate marketing as well as hands-on technical support for web design, programming and more. We are a growing community of like-minded people that is keen to help and support each other with ambitions and online endeavors. Learn and grow, make friends and contacts for life.

Community

The world's smartest hosting providers come here to discuss & share what's trending in the web hosting world!
Copyright ©2017, ForumWeb.Hosting. All rights reserved. Web Hosting Forum for webmasters, web hosting providers, designers and web developers.

Welcome to Forum Web Hosting

The World's Number 1 Web Hosting Community, Reviews & Services

Log in!

Continue with Facebook
Continue With Email. By signing up you indicate that you have read and agree to the Terms of Service and Privacy Policy.

Sign in Manually

Need an account? Sign up now!