{"id":7484,"date":"2021-02-03T12:01:30","date_gmt":"2021-02-03T12:01:30","guid":{"rendered":"https:\/\/cpanelplesk.com\/wp62\/?p=7484"},"modified":"2021-02-04T07:03:49","modified_gmt":"2021-02-04T07:03:49","slug":"5-ways-to-check-mysql-version-in-cpanel-or-linux","status":"publish","type":"post","link":"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/","title":{"rendered":"5 Ways to Check MySQL version in cPanel or Linux"},"content":{"rendered":"

MySQL is one of the most popular Relational database management system options available. Knowing which version is running on your server might be important in some situations. It helps to determine if a specific feature is available or compatible with your system.<\/p>\n

This article helps you to check the version of the MySQL server installed on your WHM\/ cPanel (or any Linux)<\/p>\n

From the command line:<\/h3>\n

If you have SSH access to the server, There are several commands that can help to find the version of your MySQL.<\/p>\n

\n
# mysqld -V<\/pre>\n<\/div>\n
\n
mysqld Ver 5.7.33 for Linux on x86_64 (MySQL Community Server (GPL))<\/pre>\n<\/div>\n
From the MySQL Client<\/h3>\n
Login to your server via SSH and enter:<\/p>\n
\n
mysql<\/pre>\n<\/div>\n
\n
Welcome to the MySQL monitor. Commands end with ; or \\g.\r\nYour MySQL connection id is 3676619\r\nServer version: 5.7.33 MySQL Community Server (GPL)\r\nCopyright (c) 2000, 2021, Oracle and\/or its affiliates.\r\n\r\nOracle is a registered trademark of Oracle Corporation and\/or its\r\naffiliates. Other names may be trademarks of their respective\r\nowners.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nmysql><\/pre>\n<\/div>\n
The server version in this example is \u00a05.7.33 MySQL Community Server.<\/p>\n
SHOW VARIABLES LIKE Statement<\/h3>\n
You can also run the following command for more details, like protocol version and InnoDB version:<\/p>\n
\n
SHOW VARIABLES LIKE \"%version%\";<\/pre>\n<\/div>\n
\n
+-------------------------+------------------------------+\r\n| Variable_name | Value |\r\n+-------------------------+------------------------------+\r\n| innodb_version | 5.7.33 |\r\n| protocol_version | 10 |\r\n| slave_type_conversions | |\r\n| tls_version | TLSv1,TLSv1.1,TLSv1.2 |\r\n| version | 5.7.33 |\r\n| version_comment | MySQL Community Server (GPL) |\r\n| version_compile_machine | x86_64 |\r\n| version_compile_os | Linux |\r\n+-------------------------+------------------------------+\r\n8 rows in set (0.00 sec)<\/pre>\n<\/div>\n
<\/h3>\n
STATUS Command<\/h3>\n
The status\u00a0<\/strong>command displays the version as well as the uptime of the MySQL server, the number of active threads, and other useful information.<\/p>\n
\n
mysql> status<\/pre>\n<\/div>\n
\n
--------------\r\nmysql Ver 14.14 Distrib 5.7.33, for Linux (x86_64) using EditLine wrapper\r\n\r\nConnection id: 3676619\r\nCurrent database:\r\nCurrent user: root@localhost\r\nSSL: Not in use\r\nCurrent pager: stdout\r\nUsing outfile: ''\r\nUsing delimiter: ;\r\nServer version: 5.7.33 MySQL Community Server (GPL)\r\nProtocol version: 10\r\nConnection: Localhost via UNIX socket\r\nServer characterset: latin1\r\nDb characterset: latin1\r\nClient characterset: utf8\r\nConn. characterset: utf8\r\nUNIX socket: \/var\/lib\/mysql\/mysql.sock\r\nUptime: 14 days 2 hours 10 min 37 sec\r\n\r\nThreads: 3 Questions: 181834225 Slow queries: 0 Opens: 109263829 Flush tables: 57 Open tables: 2000 Queries persecond avg: 149.358\r\n--------------<\/pre>\n<\/div>\n
<\/h3>\n
From The PHPMyAdmin Interface<\/h3>\n
If you are not familiar with SSH and not easy to run commands, You may have access to PHPMyAdmin on your server which is a graphical interface for managing the databases. In PHPMyAdmin on the right side, under the \u201cDatabase server\u201d section you will see the \u201cServer version\u201d which is the current\u00a0 MySQL or MariaDB version running on your server.<\/p>\n
\"\"<\/a><\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
MySQL is one of the most popular Relational database management system options available. Knowing which version is running on your server might be important in some situations. It helps to determine if a specific feature is available or compatible with your system. This article helps you to check the version of the MySQL server installed […]<\/p>\n
Continue Reading…<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7484","post","type-post","status-publish","format-standard","hentry","category-cpanel"],"yoast_head":"\n5 Ways to Check MySQL version in cPanel or Linux - cPanel Plesk<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"5 Ways to Check MySQL version in cPanel or Linux - cPanel Plesk\" \/>\n<meta name=\"twitter:description\" content=\"MySQL is one of the most popular Relational database management system options available. Knowing which version is running on your server might be important in some situations. It helps to determine if a specific feature is available or compatible with your system. This article helps you to check the version of the MySQL server installed [...]Continue Reading...\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2021\/02\/mysql-version-1.png\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Seemab Saleem\" \/>\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\":\"Article\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/\"},\"author\":{\"name\":\"Seemab Saleem\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648\"},\"headline\":\"5 Ways to Check MySQL version in cPanel or Linux\",\"datePublished\":\"2021-02-03T12:01:30+00:00\",\"dateModified\":\"2021-02-04T07:03:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/\"},\"wordCount\":230,\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"image\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2021\/02\/mysql-version-1.png\",\"articleSection\":[\"Cpanel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/\",\"name\":\"5 Ways to Check MySQL version in cPanel or Linux - cPanel Plesk\",\"isPartOf\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2021\/02\/mysql-version-1.png\",\"datePublished\":\"2021-02-03T12:01:30+00:00\",\"dateModified\":\"2021-02-04T07:03:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/#primaryimage\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2021\/02\/mysql-version-1.png\",\"contentUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2021\/02\/mysql-version-1.png\",\"width\":1100,\"height\":454},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cpanelplesk.com\/wp62\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"5 Ways to Check MySQL version in cPanel or Linux\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#website\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/\",\"name\":\"cPanel Plesk\",\"description\":\"Blog on famous hosting control panels\",\"publisher\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13\",\"name\":\"Farooq Omer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"contentUrl\":\"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png\",\"width\":300,\"height\":44,\"caption\":\"Farooq Omer\"},\"logo\":{\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648\",\"name\":\"Seemab Saleem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g\",\"caption\":\"Seemab Saleem\"},\"description\":\"Linux Server Administrator, Web Hosting engineer. I'm dealing with Linux servers since 2014. I started this blog to share the work i love with the world . let me know if you need any assistance. Thanks!!\",\"sameAs\":[\"https:\/\/cpanelplesk.com\/wp62\"],\"url\":\"https:\/\/cpanelplesk.com\/wp62\/author\/cmb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"5 Ways to Check MySQL version in cPanel or Linux - cPanel Plesk","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:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/","twitter_card":"summary_large_image","twitter_title":"5 Ways to Check MySQL version in cPanel or Linux - cPanel Plesk","twitter_description":"MySQL is one of the most popular Relational database management system options available. Knowing which version is running on your server might be important in some situations. It helps to determine if a specific feature is available or compatible with your system. This article helps you to check the version of the MySQL server installed [...]Continue Reading...","twitter_image":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2021\/02\/mysql-version-1.png","twitter_misc":{"Written by":"Seemab Saleem","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/#article","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/"},"author":{"name":"Seemab Saleem","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648"},"headline":"5 Ways to Check MySQL version in cPanel or Linux","datePublished":"2021-02-03T12:01:30+00:00","dateModified":"2021-02-04T07:03:49+00:00","mainEntityOfPage":{"@id":"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/"},"wordCount":230,"publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"image":{"@id":"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2021\/02\/mysql-version-1.png","articleSection":["Cpanel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/","url":"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/","name":"5 Ways to Check MySQL version in cPanel or Linux - cPanel Plesk","isPartOf":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/#primaryimage"},"image":{"@id":"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2021\/02\/mysql-version-1.png","datePublished":"2021-02-03T12:01:30+00:00","dateModified":"2021-02-04T07:03:49+00:00","breadcrumb":{"@id":"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/#primaryimage","url":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2021\/02\/mysql-version-1.png","contentUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2021\/02\/mysql-version-1.png","width":1100,"height":454},{"@type":"BreadcrumbList","@id":"https:\/\/cpanelplesk.com\/wp62\/5-ways-to-check-mysql-version-in-cpanel-or-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cpanelplesk.com\/wp62\/"},{"@type":"ListItem","position":2,"name":"5 Ways to Check MySQL version in cPanel or Linux"}]},{"@type":"WebSite","@id":"https:\/\/cpanelplesk.com\/wp62\/#website","url":"https:\/\/cpanelplesk.com\/wp62\/","name":"cPanel Plesk","description":"Blog on famous hosting control panels","publisher":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cpanelplesk.com\/wp62\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/c78ae1cf9451a09592fb9697d69c0c13","name":"Farooq Omer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/","url":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","contentUrl":"https:\/\/cpanelplesk.com\/wp62\/wp-content\/uploads\/2020\/11\/cpanelplesk.png","width":300,"height":44,"caption":"Farooq Omer"},"logo":{"@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/"}},{"@type":"Person","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/73d573cc7eaaf6625cf0dbd72191a648","name":"Seemab Saleem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cpanelplesk.com\/wp62\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6a87ff2e53b03e6839250e5278a6bd46?s=96&d=mm&r=g","caption":"Seemab Saleem"},"description":"Linux Server Administrator, Web Hosting engineer. I'm dealing with Linux servers since 2014. I started this blog to share the work i love with the world . let me know if you need any assistance. Thanks!!","sameAs":["https:\/\/cpanelplesk.com\/wp62"],"url":"https:\/\/cpanelplesk.com\/wp62\/author\/cmb\/"}]}},"_links":{"self":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/7484","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/comments?post=7484"}],"version-history":[{"count":0,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/posts\/7484\/revisions"}],"wp:attachment":[{"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/media?parent=7484"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/categories?post=7484"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cpanelplesk.com\/wp62\/wp-json\/wp\/v2\/tags?post=7484"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}