{"id":4793,"date":"2020-03-04T18:39:06","date_gmt":"2020-03-04T23:39:06","guid":{"rendered":"https:\/\/www.globo.tech\/learning-center\/?p=4793"},"modified":"2020-03-12T14:04:50","modified_gmt":"2020-03-12T18:04:50","slug":"how-to-check-mysql-version","status":"publish","type":"post","link":"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/","title":{"rendered":"How to check MySQL version"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"628\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckMySQLVersion.jpg\" alt=\"How to check MySQL version\" class=\"wp-image-4794\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to check MySQL version<\/h2>\n\n\n\n<p>If you are a database administrator or system administrator, it is essential to know how to check <a href=\"https:\/\/dev.mysql.com\/downloads\/\">version of MySQL<\/a> you have installed. This will helps you to find which feature is available for your installed MySQL version. For example, if you want to install some application that requires a specific MySQL version. In this case, you will need to find out the MySQL version in your <a href=\"https:\/\/www.globo.tech\/dedicated-server-hosting\">server<\/a> before installing your application.<\/p>\n\n\n\n<p>There are several ways to check the MySQL version in Linux operating systems.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Check MySQL Version with Command Line<\/h2>\n\n\n\n<p>The simple and easiest way to find the MySQL version installed on your system using the MySQL client command.<\/p>\n\n\n\n<p><strong>Option 1:<\/strong> Open your terminal interface and run the following command:<\/p>\n\n\n\n<p><code> mysql -V<\/code><\/p>\n\n\n\n<p>You should get the MySQL version in the following output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">  mysql  Ver 8.0.19 for Linux on x86_64 (MySQL Community Server - GPL)<\/pre>\n\n\n\n<br class=\"custom-break\">\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/mysql-v.png\" alt=\"Type &quot;mysql -v&quot; into SSH console to check mysql version.\" class=\"wp-image-4795\" width=\"686\" height=\"76\"\/><\/figure>\n\n\n\n<p> <strong>Option 2:<\/strong> You can also check the MySQL version by login to MySQL Shell:<\/p>\n\n\n\n<p><code> mysql -u root -p<\/code><\/p>\n\n\n\n<p>Provide your root password (can be your any database user) and hit Enter to log in to MySQL shell as with version information shown below:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Enter password: \n Welcome to the MySQL monitor.  Commands end with ; or \\g.\n Your MySQL connection id is 9\n Server version: 8.0.19 MySQL Community Server - GPL\n Copyright (c) 2000, 2020, Oracle and\/or its affiliates. All rights reserved.\n Oracle is a registered trademark of Oracle Corporation and\/or its\n affiliates. Other names may be trademarks of their respective\n owners.\n Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.<\/pre>\n\n\n\n<br class=\"custom-break\">\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/mysql-u.png\" alt=\"Type the following syntax to log to MySQL via SSH Console: mysql -u user -p; were &quot;user&quot; is the your mysql user.\" class=\"wp-image-4796\" width=\"525\" height=\"209\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Check MySQL Version Within MySQL Shell<\/h2>\n\n\n\n<p>You can also verify the MySQL version by querying the version variables inside the MySQL shell.<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>First, log in to MySQL Shell with the following command:<\/p>\n\n\n\n<p><code> mysql -u root -p<\/code><\/p>\n\n\n\n<p>Provide your root password and hit Enter to log in the MySQL shell.<\/p>\n\n\n\n<p><strong>Step 2: <\/strong>Next, run the following command to display the MySQL version into mysql prompt:<\/p>\n\n\n\n<p><code>SHOW VARIABLES LIKE \"%version%\";<\/code><\/p>\n\n\n\n<p>You should get the following output with, were you can find the MySQL version:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> +--------------------------+-------------------------------+\n | Variable_name            | Value                         |\n +--------------------------+-------------------------------+\n | immediate_server_version | 999999                        |\n | innodb_version           | 8.0.19                        |\n | original_server_version  | 999999                        |\n | protocol_version         | 10                            |\n | slave_type_conversions   |                               |\n | tls_version              | TLSv1,TLSv1.1,TLSv1.2,TLSv1.3 |\n | version                  | 8.0.19                        |\n | version_comment          | MySQL Community Server - GPL  |\n | version_compile_machine  | x86_64                        |\n | version_compile_os       | Linux                         |\n | version_compile_zlib     | 1.2.11                        |\n +--------------------------+-------------------------------+\n 11 rows in set (0.02 sec)<\/pre>\n\n\n\n<br class=\"custom-break\">\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/mysql-u-1.png\" alt=\"Type the following command into mysql shell, to see your mysql version: SHOW VARIABLES LIKE &quot;%version%&quot;;\" class=\"wp-image-4797\" width=\"525\" height=\"209\"\/><\/figure>\n\n\n\n<p><strong>Alternative option: <\/strong>You can also use the SELECT VERSION() statement inside MySQL shell to display MySQL version information:<\/p>\n\n\n\n<p><code> SELECT VERSION();<\/code><\/p>\n\n\n\n<p>You should get the following output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> +-----------+\n | VERSION() |\n +-----------+\n | 8.0.19    |\n +-----------+\n 1 row in set (0.00 sec) <\/pre>\n\n\n\n<br class=\"custom-break\">\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/select-version.png\" alt=\"Into the MySQL Shell, type &quot;SELECT VERSION();&quot; to check the MySQL version.\" class=\"wp-image-4798\" width=\"525\" height=\"120\"\/><\/figure>\n\n\n\n<p><strong>Another alternative option:<\/strong> The STATUS command also displays the information about MySQL version and the server status:<\/p>\n\n\n\n<p><code> STATUS;<\/code><\/p>\n\n\n\n<p>You should get the following output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> mysql  Ver 8.0.19 for Linux on x86_64 (MySQL Community Server - GPL)\n \n \n Connection id: 10\n Current database: \n Current user: root@localhost\n SSL: Not in use\n Current pager: stdout\n Using outfile: ''\n Using delimiter: ;\n Server version: 8.0.19 MySQL Community Server - GPL\n Protocol version: 10\n Connection: Localhost via UNIX socket\n Server characterset: utf8mb4\n Db     characterset: utf8mb4\n Client characterset: utf8mb4\n Conn.  characterset: utf8mb4\n UNIX socket: \/var\/run\/mysqld\/mysqld.sock\n Binary data as: Hexadecimal\n Uptime: 16 min 55 sec\n \n \n Threads: 2  Questions: 14  Slow queries: 0  Opens: 132  Flush tables: 3  Open tables: 52  Queries per second avg: 0.013<\/pre>\n\n\n\n<br class=\"custom-break\">\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/select-status.png\" alt=\"Into the MySQL Shell, type &quot;STATUS;&quot; to check the MySQL version.\" class=\"wp-image-4799\" width=\"646\" height=\"357\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Check MySQL Version from PHPMyAdmin Interface<\/h2>\n\n\n\n<p>PHPMyAdmin is a graphical interface for managing the databases. You can also verify the MySQL version from the PHPMyAdmin interface.<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>Open your web browser and type the URL bellow. You will be redirected to the PHPMyAdmin login page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"241\" height=\"24\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/PhpMyAdmin-url-1.png\" alt=\"phpmyadmin url\" class=\"wp-image-4802\"\/><\/figure>\n\n\n\n<p>Then you should see the phpMyAdmin login page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/PhpMyAdmin-Login.png\" alt=\"Phpmyadmin login page.\" class=\"wp-image-4800\" width=\"617\" height=\"300\"\/><\/figure>\n\n\n\n<p><strong>Step 2: <\/strong>Provide your MySQL root username and password, and click on the <strong>Go<\/strong> button. You should see the PHPMyAdmin web interface in the following screen:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/PhpMyAdmin-version.png\" alt=\"When logged into phpmyadmin, you can see the mysql version into the &quot;database server&quot; panel.\" class=\"wp-image-4803\" width=\"643\" height=\"337\"\/><figcaption> <br> <br>In the above screen, you should see the MySQL version information under the \u201cDatabase server\u201d section on the right side. <\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>In the above guide, you have seen how to check the MySQL version in Linux with several methods. You have also learned how to get additional data from within the MySQL client.<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>How to check MySQL version If you are a database administrator or system administrator, it is essential to know how to check version of MySQL you have installed. This will helps you to find which feature is available for your installed MySQL version. For example, if you want to install some application that requires a<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":3,"featured_media":4823,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[61],"tags":[161,163,24,162],"class_list":["post-4793","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","tag-database","tag-db","tag-mysql","tag-version"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to check MySQL version - Globo.Tech<\/title>\n<meta name=\"description\" content=\"MySQL server is a database engine largely used on Linux and Windows servers. Find out how to find the version of MySQL you&#039;re running on your server.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to check MySQL version - Globo.Tech\" \/>\n<meta property=\"og:description\" content=\"MySQL server is a database engine largely used on Linux and Windows servers. Find out how to find the version of MySQL you&#039;re running on your server.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/\" \/>\n<meta property=\"og:site_name\" content=\"Globo.Tech\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-04T23:39:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-12T18:04:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckMySQLVersion-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"GloboTech Communications\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"GloboTech Communications\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/\",\"url\":\"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/\",\"name\":\"How to check MySQL version - Globo.Tech\",\"isPartOf\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckMySQLVersion-1.jpg\",\"datePublished\":\"2020-03-04T23:39:06+00:00\",\"dateModified\":\"2020-03-12T18:04:50+00:00\",\"author\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87\"},\"description\":\"MySQL server is a database engine largely used on Linux and Windows servers. Find out how to find the version of MySQL you're running on your server.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/#primaryimage\",\"url\":\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckMySQLVersion-1.jpg\",\"contentUrl\":\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckMySQLVersion-1.jpg\",\"width\":1200,\"height\":628,\"caption\":\"How to check MySQL version\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.globo.tech\/learning-center\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to check MySQL version\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#website\",\"url\":\"https:\/\/www.globo.tech\/learning-center\/\",\"name\":\"Globo.Tech\",\"description\":\"Welcome to the Official Globo.Tech Learning Center\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.globo.tech\/learning-center\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87\",\"name\":\"GloboTech Communications\",\"sameAs\":[\"http:\/\/www.gtcomm.net\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to check MySQL version - Globo.Tech","description":"MySQL server is a database engine largely used on Linux and Windows servers. Find out how to find the version of MySQL you're running on your server.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/","og_locale":"en_US","og_type":"article","og_title":"How to check MySQL version - Globo.Tech","og_description":"MySQL server is a database engine largely used on Linux and Windows servers. Find out how to find the version of MySQL you're running on your server.","og_url":"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/","og_site_name":"Globo.Tech","article_published_time":"2020-03-04T23:39:06+00:00","article_modified_time":"2020-03-12T18:04:50+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckMySQLVersion-1.jpg","type":"image\/jpeg"}],"author":"GloboTech Communications","twitter_misc":{"Written by":"GloboTech Communications","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/","url":"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/","name":"How to check MySQL version - Globo.Tech","isPartOf":{"@id":"https:\/\/www.globo.tech\/learning-center\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/#primaryimage"},"image":{"@id":"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/#primaryimage"},"thumbnailUrl":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckMySQLVersion-1.jpg","datePublished":"2020-03-04T23:39:06+00:00","dateModified":"2020-03-12T18:04:50+00:00","author":{"@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87"},"description":"MySQL server is a database engine largely used on Linux and Windows servers. Find out how to find the version of MySQL you're running on your server.","breadcrumb":{"@id":"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/#primaryimage","url":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckMySQLVersion-1.jpg","contentUrl":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckMySQLVersion-1.jpg","width":1200,"height":628,"caption":"How to check MySQL version"},{"@type":"BreadcrumbList","@id":"https:\/\/www.globo.tech\/learning-center\/how-to-check-mysql-version\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.globo.tech\/learning-center\/"},{"@type":"ListItem","position":2,"name":"How to check MySQL version"}]},{"@type":"WebSite","@id":"https:\/\/www.globo.tech\/learning-center\/#website","url":"https:\/\/www.globo.tech\/learning-center\/","name":"Globo.Tech","description":"Welcome to the Official Globo.Tech Learning Center","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.globo.tech\/learning-center\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87","name":"GloboTech Communications","sameAs":["http:\/\/www.gtcomm.net"]}]}},"_links":{"self":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/4793","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/comments?post=4793"}],"version-history":[{"count":20,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/4793\/revisions"}],"predecessor-version":[{"id":4865,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/4793\/revisions\/4865"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/media\/4823"}],"wp:attachment":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/media?parent=4793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/categories?post=4793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/tags?post=4793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}