{"id":705,"date":"2019-03-21T09:16:59","date_gmt":"2019-03-21T09:16:59","guid":{"rendered":"https:\/\/forumweb.hosting\/blog\/?p=705"},"modified":"2019-03-21T09:22:12","modified_gmt":"2019-03-21T09:22:12","slug":"how-to-check-the-mysql-version","status":"publish","type":"post","link":"https:\/\/forumweb.hosting\/blog\/how-to-check-the-mysql-version\/","title":{"rendered":"How to Check the MySQL Version"},"content":{"rendered":"<p>In this article, you will know how to check the version of a MySQL server, in the case you have errors that related to your website data, if you know the version of MySQL then you can quickly fix the errors. As we have to know MySQL is\u00a0 one of\u00a0the most popular relational database management system and is used by many webmasters to manage databases for their websites. However, this\u00a0RDBMS\u00a0 have many different versions, and each version has its unique features that you need to know to choose the best version for your website. Let&#8217;s start testing the version of Mysql that your website is using.<\/p>\n<p>The condition for you to check the version successfully is that you need to log in to ssh as root. At SSH, type:<\/p>\n<pre class=\"resultcode\">MySQL -V<\/pre>\n<p>The result can be returned.<\/p>\n<pre class=\"resultcode\">MySQL Ver 15.1 Distrib 10.1.34-MariaDB, for Linux (x86_64) using readline 5.1<\/pre>\n<p>From within the MySQL client, you can also run the following command for more details:<br \/>\nSHOW VARIABLES LIKE &#8220;%version%&#8221;;<\/p>\n<pre class=\"resultcode\">+-------------------------+----------------------------+\r\n| Variable_name           | Value                      |\r\n+-------------------------+----------------------------+\r\n| innodb_version          | 5.6.36-82.2                |\r\n| protocol_version        | 10                         |\r\n| slave_type_conversions  |                            |\r\n| version                 | 10.1.34-MariaDB            |\r\n| version_comment         | MariaDB Server             |\r\n| version_compile_machine | x86_64                     |\r\n| version_compile_os      | Linux                      |\r\n| version_malloc_library  | system                     |\r\n| version_ssl_library     | OpenSSL 1.1.0g  2 Nov 2017 |\r\n| wsrep_patch_version     | wsrep_25.21                |\r\n+-------------------------+----------------------------+\r\n10 rows in set (0.02 sec)<\/pre>\n<p>In the result above, you can find additional version details about your installed MySQL such as protocol_version, innodb_version,\u00a0version_ssl_library,\u00a0slave_type_conversions, and more.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article, you will know how to check the version of a MySQL server, in the case you have errors that related to your website data, if you know the version of MySQL then you can quickly fix the errors. As we have to know MySQL is\u00a0 one of\u00a0the most popular relational database management [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":707,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[112,65,113],"_links":{"self":[{"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/posts\/705"}],"collection":[{"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/comments?post=705"}],"version-history":[{"count":2,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/posts\/705\/revisions"}],"predecessor-version":[{"id":708,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/posts\/705\/revisions\/708"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/media\/707"}],"wp:attachment":[{"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/media?parent=705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/categories?post=705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/forumweb.hosting\/blog\/wp-json\/wp\/v2\/tags?post=705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}