{"id":1516,"date":"2025-04-18T16:08:12","date_gmt":"2025-04-18T09:08:12","guid":{"rendered":"https:\/\/www.linuxid.net\/post\/?p=1516"},"modified":"2025-04-18T16:08:12","modified_gmt":"2025-04-18T09:08:12","slug":"cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux","status":"publish","type":"post","link":"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/","title":{"rendered":"Cara Memeriksa Versi MySQL atau MariaDB di Server Linux"},"content":{"rendered":"

MySQL (dan MariaDB) adalah sistem manajemen basis data relasional open-source yang paling populer. Ada beberapa perbedaan penting antara versi MySQL, jadi mengetahui versi mana yang berjalan di server Anda mungkin cukup penting dalam beberapa situasi.<\/p>\n

Misalnya, jika Anda menginstal aplikasi yang memerlukan versi MySQL tertentu, sebelum memulai dengan instalasi, Anda perlu mengetahui versi server MySQL Anda.<\/p>\n

Dalam artikel ini, kami akan menunjukkan kepada Anda cara memeriksa versi MySQL atau MariaDB\u00a0server yang diinstal pada sistem Anda.<\/p>\n

Memeriksa Versi MySQL Dari Command Line<\/h2>\n

Jika Anda memiliki akses SSH ke server, ada beberapa perintah berbeda yang dapat membantu Anda melihat versi MySQL.<\/p>\n

Biner MySQL server dinamai mysqld<\/code>. Untuk mendapatkan versi server, jalankan mysqld<\/code> dan di imbuhi opsi --version<\/code> atau -V<\/code>:<\/p>\n

mysqld --version<\/pre>\n
Perintah akan menampilkan informasi tentang versi MySQL dan keluar. Dalam contoh ini, versi server MySQL adalah 5.7.27<\/code>:<\/p>\n
mysqld  Ver 5.7.27-0ubuntu0.18.04.1 for Linux on x86_64 ((Ubuntu))<\/pre>\n
Jika server MySQL memerlukan otentikasi, Anda harus menggunakan sudo mysql<\/code> atau mysql -u username -p<\/code>.<\/p>\n
mysqladmin<\/code> adalah utilitas klien yang digunakan untuk melakukan operasi administratif di server MySQL. Perintah\u00a0mysqladmin<\/code> dapat juga digunakan untuk menanyakan versi MySQL:<\/p>\n
mysqladmin -V<\/pre>\n
Output akan sedikit berbeda dari perintah sebelumnya:<\/p>\n
mysqladmin  Ver 8.42 Distrib 5.7.27, for Linux on x86_64<\/pre>\n
Melihat Versi MySQL Dari Shell Internal MySQL<\/h2>\n
Utilitas klien perintah seperti mysql, juga dapat digunakan untuk menentukan versi server MySQL.<\/p>\n
Untuk terhubung ke server MySQL cukup ketik mysql<\/code>:<\/p>\n
mysql<\/pre>\n
Setelah terhubung ke shell MySQL, versi akan dicetak di layar:<\/p>\n
Welcome to the MySQL monitor.  Commands end with ; or \\g.
\nYour MySQL connection id is 3
\nServer version: 5.7.27-0ubuntu0.18.04.1 (Ubuntu)<\/pre>\n
Untuk mendapatkan informasi tentang versi MySQL dan komponen lainnya, gunakan kueri variabel version<\/code>\u00a0:<\/p>\n
SHOW VARIABLES LIKE \"%version%\";<\/pre>\n
+-------------------------+-------------------------+
\n| Variable_name| Value        |
\n+-------------------------+-------------------------+
\n| innodb_version          | 5.7.27       |
\n| protocol_version        | 10|
\n| slave_type_conversions  |   |
\n| tls_version  | TLSv1,TLSv1.1|
\n| version      | 5.7.27-0ubuntu0.18.04.1 |
\n| version_comment         | (Ubuntu)     |
\n| version_compile_machine | x86_64       |
\n| version_compile_os      | Linux        |
\n+-------------------------+-------------------------+
\n8 rows in set (0.02 sec)<\/pre>\n
Ada juga beberapa pernyataan dan perintah lain yang dapat menunjukkan kepada Anda versi MySQL. Pernyataan SELECT VERSION()<\/code> hanya akan menampilkan versi MySQL.<\/p>\n
SELECT VERSION();<\/pre>\n
Perintah STATUS<\/code> menunjukkan versi MySQL serta informasi tentang status server:<\/p>\n
STATUS;<\/pre>\n
Melihat Versi MySQL Menggunakan PHP<\/h2>\n
Jika Anda menggunakan shared hosting dan tidak memiliki akses ke baris perintah atau ke klien MySQL seperti PhpMyAdmin, Anda dapat menentukan versi server MySQL menggunakan PHP.<\/p>\n
Dalam direktori root dokumen situs web Anda, unggah file PHP berikut menggunakan klien FTP<\/a> atau SFTP<\/a>. Pastikan Anda mengubah mysql_user<\/code> dan mysql_password<\/code> dengan akun user MySQL<\/a> yang Anda miliki :<\/p>\n
mysql-version.php<\/span><\/pre>\n
<?php
\n
\n\/\/ Koneksi ke database dengan user dan password.
\n$link = mysqli_connect(\"localhost\", \"mysql_user\", \"mysql_password\");
\n
\n\/\/ Print versi MySQL di Layar.
\necho mysqli_get_server_info($link);
\n
\n\/\/ Tutup koneksi yang ada
\nmysqli_close($link);<\/pre>\n
Buka file di browser dan versi server MySQL akan ditampilkan di layar : (contoh versi pada sistem kami)<\/p>\n
5.7.27-0ubuntu0.18.04.1<\/pre>\n
Kesimpulan<\/h2>\n
Menentukan versi server MySQL adalah tugas yang relatif mudah. Dalam panduan ini, kami telah menunjukkan beberapa opsi berbeda tentang cara menemukan versi MySQL yang berjalan di sistem Anda.<\/p>\n","protected":false},"excerpt":{"rendered":"
MySQL (dan MariaDB) adalah sistem manajemen basis data relasional open-source yang paling populer. Ada beberapa…<\/p>\n","protected":false},"author":2,"featured_media":1517,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55],"tags":[99,41,166],"class_list":["post-1516","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mariadb","tag-mysql","tag-sql"],"yoast_head":"\nCara Memeriksa Versi MySQL atau MariaDB di Server Linux - Linuxid<\/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:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Memeriksa Versi MySQL atau MariaDB di Server Linux - Linuxid\" \/>\n<meta property=\"og:description\" content=\"MySQL (dan MariaDB) adalah sistem manajemen basis data relasional open-source yang paling populer. Ada beberapa…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/\" \/>\n<meta property=\"og:site_name\" content=\"Linuxid\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-18T09:08:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Memeriksa-Versi-MySQL-atau-MariaDB-di-Server-Linux.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"530\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"xsand\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"xsand\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/\",\"url\":\"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/\",\"name\":\"Cara Memeriksa Versi MySQL atau MariaDB di Server Linux - Linuxid\",\"isPartOf\":{\"@id\":\"https:\/\/linuxid.net\/post\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Memeriksa-Versi-MySQL-atau-MariaDB-di-Server-Linux.jpg\",\"datePublished\":\"2025-04-18T09:08:12+00:00\",\"author\":{\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/#primaryimage\",\"url\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Memeriksa-Versi-MySQL-atau-MariaDB-di-Server-Linux.jpg\",\"contentUrl\":\"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Memeriksa-Versi-MySQL-atau-MariaDB-di-Server-Linux.jpg\",\"width\":1000,\"height\":530},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\/\/linuxid.net\/post\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara Memeriksa Versi MySQL atau MariaDB di Server Linux\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/linuxid.net\/post\/#website\",\"url\":\"https:\/\/linuxid.net\/post\/\",\"name\":\"Linuxid\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/linuxid.net\/post\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79\",\"name\":\"xsand\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g\",\"caption\":\"xsand\"},\"url\":\"https:\/\/www.linuxid.net\/post\/author\/xsand\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Memeriksa Versi MySQL atau MariaDB di Server Linux - Linuxid","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.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Memeriksa Versi MySQL atau MariaDB di Server Linux - Linuxid","og_description":"MySQL (dan MariaDB) adalah sistem manajemen basis data relasional open-source yang paling populer. Ada beberapa…","og_url":"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/","og_site_name":"Linuxid","article_published_time":"2025-04-18T09:08:12+00:00","og_image":[{"width":1000,"height":530,"url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Memeriksa-Versi-MySQL-atau-MariaDB-di-Server-Linux.jpg","type":"image\/jpeg"}],"author":"xsand","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"xsand","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/","url":"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/","name":"Cara Memeriksa Versi MySQL atau MariaDB di Server Linux - Linuxid","isPartOf":{"@id":"https:\/\/linuxid.net\/post\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/#primaryimage"},"image":{"@id":"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Memeriksa-Versi-MySQL-atau-MariaDB-di-Server-Linux.jpg","datePublished":"2025-04-18T09:08:12+00:00","author":{"@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79"},"breadcrumb":{"@id":"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/#primaryimage","url":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Memeriksa-Versi-MySQL-atau-MariaDB-di-Server-Linux.jpg","contentUrl":"https:\/\/www.linuxid.net\/post\/wp-content\/uploads\/2025\/03\/Cara-Memeriksa-Versi-MySQL-atau-MariaDB-di-Server-Linux.jpg","width":1000,"height":530},{"@type":"BreadcrumbList","@id":"https:\/\/www.linuxid.net\/post\/cara-memeriksa-versi-mysql-atau-mariadb-di-server-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/linuxid.net\/post\/"},{"@type":"ListItem","position":2,"name":"Cara Memeriksa Versi MySQL atau MariaDB di Server Linux"}]},{"@type":"WebSite","@id":"https:\/\/linuxid.net\/post\/#website","url":"https:\/\/linuxid.net\/post\/","name":"Linuxid","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/linuxid.net\/post\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/e6642d26041eab9fef2677e204e89d79","name":"xsand","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/linuxid.net\/post\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cc8513768e15fa0758099a0ba5b898f3?s=96&d=mm&r=g","caption":"xsand"},"url":"https:\/\/www.linuxid.net\/post\/author\/xsand\/"}]}},"_links":{"self":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1516","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/comments?post=1516"}],"version-history":[{"count":1,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1516\/revisions"}],"predecessor-version":[{"id":3067,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/posts\/1516\/revisions\/3067"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media\/1517"}],"wp:attachment":[{"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/media?parent=1516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/categories?post=1516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxid.net\/post\/wp-json\/wp\/v2\/tags?post=1516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}