9TO5Host Blog
  • Home
  • Blog
  • Domains
  • Shared Hosting
    • wordpress hosting
  • VPS
  • Dedicated Hosting
    • Single Processor Servers
    • Budget Plan Servers
  • About us
    • why 9to5host 5 reasons
    • guarantees
    • Testimonials
    • Data Center
  • Contact Us

How to check the MySQL version

9TO5Host Blog > 9TO5Host wiki > How to check the MySQL version

How to check the MySQL version

Jul 26, 2015nazia afreen9TO5Host wiki, Hosting Questions, VPS Tutorials, Web hosting guides0 Comment

Process of checking the MySQL version

Process of checking the MySQL version

Certain pre-requisites that need to be kept in mind-

  • The instructions that are listed out are for the purpose of checking the MySQL version on your web server.
  • As an FYI, users need to know that we are logged in as root and we are working from a Liquid Web Core Managed CentOS 7 server.

Head to the command line and enter the following command/code-

1
mysql –v

 

The command on execution should give a response that is similar to the following line of code-

mysql Ver 15.1 Distrib 5.5.41-MariaDB, for Linux (x86_64) using readline 5.1

  • Once done, head to the MySQL Command Client.

The time you connect to the MySQL with the help of a command client and you use the following command, the current version of the MySQL server will be shown to you

1
mysql

 

Once again, the response you get on execution should be-

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.41-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

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

1
MariaDB [(none)]>

 

The server version in this example is Server version: 5.5.41-MariaDB MariaDB Server.

You can also easily run the following command after you are connected to the MySQL Command Client-

1
SHOW VARIABLES LIKE “%version%”;

 

Once executed, the result that comes should be-

+————————-+———————+
| Variable_name           | Value               |
+————————-+———————+
| innodb_version          | 5.5.40-MariaDB-36.1 |
| protocol_version        | 10                  |
| slave_type_conversions  |                     |
| version                 | 5.5.41-MariaDB      |
| version_comment         | MariaDB Server      |
| version_compile_machine | x86_64              |
| version_compile_os      | Linux               |
+————————-+———————+
7 rows in set (0.10 sec)

In this manner you can easily check the version of the MySQL that resides on your web server. We hope the tutorial and the codes were beneficial.

Written by nazia afreen

Leave a Reply

Cancel reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">

← chkconfig commands to be executed on Red Hat and the CentOS
Linux VPS Hosting →

Recent Posts

  • Configure VSFTPD on CentOS Server
  • How To Connect Your Server And Domain With Free DNS Manager
  • Tips To Configure Cyrus on CentOS
  • How To Configure Varnish 3 on Ubuntu To Run with Nginx
  • How to Configure Varnish 3 on Ubuntu Server To Run With Apache 2
  • How to Configure Varnish 3 on CentOS with Apache 2
  • How To Setup W3 Total Cache Plugin in A WordPress Blog Hosted In CentOS Nginx
  • A How-To Guide On Limiting Maximum Connections In Your Server
  • How To Protect Your Ubuntu Server From Brute Force SSH Login Attempts With Fail2Ban
  • How To Use SFTP To Upload And Manage Your Files On Your Server

WaybAck Machine

  • October 2017
  • September 2017
  • August 2017
  • October 2016
  • September 2016
  • December 2015
  • October 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014

Knowledge Base

  • 9TO5Host wiki
  • cPanel
  • General
  • Hosting Questions
  • VPS Tutorials
  • Web hosting guides

Follow us




Links

  • Privacy Policy
  • Terms Of Services
  • Acceptable Use Policy
  • Shared Services
  • Dedicated Services
  • E-Commerce Services
  • Offers
  • Client Login
  • Contact us

Latest Tweets

  • BackupBro - Perform backup manually: https://t.co/Zw0c5mpOY6 via @YouTube - 169 days ago
  • BackupBro by 9TO5Host: https://t.co/uyYtIMWIA5 via @YouTube - 169 days ago
  • @paygol do you provide services in India? - 231 days ago
© 9TO5Host.com - 2014-2015 All Rights Reserved.
  • Twitter
  • Facebook
  • Youtube
  • Google+