{"id":10097,"date":"2026-07-18T13:20:14","date_gmt":"2026-07-18T06:20:14","guid":{"rendered":"https:\/\/www.jetorbit.com\/panduan\/?p=10097"},"modified":"2026-07-18T13:20:14","modified_gmt":"2026-07-18T06:20:14","slug":"cara-mengecek-status-mysql-apakah-sedang-jalan","status":"publish","type":"post","link":"https:\/\/www.jetorbit.com\/panduan\/cara-mengecek-status-mysql-apakah-sedang-jalan\/","title":{"rendered":"Cara Mengecek Status MySQL Apakah Sedang Jalan"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Daftar Isi Artikel<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.jetorbit.com\/panduan\/cara-mengecek-status-mysql-apakah-sedang-jalan\/#Cara_Cepat_Pakai_systemctl\" >Cara Cepat Pakai systemctl<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.jetorbit.com\/panduan\/cara-mengecek-status-mysql-apakah-sedang-jalan\/#Cek_Proses_yang_Berjalan_ps\" >Cek Proses yang Berjalan ps<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.jetorbit.com\/panduan\/cara-mengecek-status-mysql-apakah-sedang-jalan\/#Cek_portsocket_yang_didengarkan_networking\" >Cek port\/socket yang didengarkan (networking).<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.jetorbit.com\/panduan\/cara-mengecek-status-mysql-apakah-sedang-jalan\/#Cek_koneksi_via_client_uji_fungsional\" >Cek koneksi via client (uji fungsional).<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>MySQL \/ MariaDB adalah program yang menyimpan data untuk aplikasi (mis. website, webmail, Roundcube). Mengetahui apakah MySQL sedang berjalan penting sebelum mencoba koneksi, backup, atau debug aplikasi: kalau server database mati, aplikasi tidak bisa baca\/tulis data dan akan muncul error. Mengecek status juga membantu kita menemukan apakah masalahnya \u201cservice mati\u201d (harus dinyalakan ulang), \u201cservice jalan tapi tidak bisa diakses\u201d (masalah socket\/port\/firewall), atau \u201cservice jalan tapi error internal\u201d (cek log).<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cara_Cepat_Pakai_systemctl\"><\/span><strong>Cara Cepat Pakai <\/strong><strong>systemctl<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"743\" height=\"304\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-25.png\" alt=\"\" class=\"wp-image-10101\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-25.png 743w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-25-300x123.png 300w\" sizes=\"(max-width: 743px) 100vw, 743px\" \/><\/figure>\n\n\n\n<p>Perintah ini menampilkan apakah service <em>active (running)<\/em>, <em>inactive (dead)<\/em>, atau <em>failed<\/em>, serta beberapa baris log terakhir. Contoh output positif: Active: active (running) since Tue &#8230; artinya server database berjalan. Jika tertulis failed atau inactive artinya perlu di-restart; jika active (exited) biasanya service hanya \u201cdummy\u201d dan tidak menjalankan mysqld. Untuk melihat hanya status singkat bisa pakai systemctl is-active mysql (mengembalikan active\/inactive).<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cek_Proses_yang_Berjalan_ps\"><\/span><strong>Cek Proses yang Berjalan <\/strong><strong>ps<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"738\" height=\"63\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-23.png\" alt=\"\" class=\"wp-image-10100\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-23.png 738w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-23-300x26.png 300w\" sizes=\"(max-width: 738px) 100vw, 738px\" \/><\/figure>\n\n\n\n<p>Kalau MySQL jalan akan muncul proses mysqld atau mariadbd beserta PID dan penggunaan CPU\/RAM. Tidak ada proses berarti server database tidak berjalan sama sekali.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cek_portsocket_yang_didengarkan_networking\"><\/span><strong>Cek port\/socket yang didengarkan (networking).<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"738\" height=\"136\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-22.png\" alt=\"\" class=\"wp-image-10098\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-22.png 738w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-22-300x55.png 300w\" sizes=\"(max-width: 738px) 100vw, 738px\" \/><\/figure>\n\n\n\n<p>Output harus menunjukkan LISTEN pada 0.0.0.0:3306 (mengizinkan koneksi remote) atau 127.0.0.1:3306 (hanya lokal). Jika tidak muncul, berarti daemon tidak buka port \u2014 kemungkinan service tidak berjalan atau konfigurasi bind-address membatasi.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cek_koneksi_via_client_uji_fungsional\"><\/span><strong>Cek koneksi via client (uji fungsional).<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"723\" height=\"266\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-26.png\" alt=\"\" class=\"wp-image-10102\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-26.png 723w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-26-300x110.png 300w\" sizes=\"(max-width: 723px) 100vw, 723px\" \/><\/figure>\n\n\n\n<p>Jika server berjalan, prompt MySQL akan muncul. Jika tidak, biasanya muncul error: ERROR 2002 (HY000): Can&#8217;t connect to local MySQL server through socket &#8216;\/var\/run\/mysqld\/mysqld.sock&#8217; \u2014 itu indikasi mysqld tidak jalan atau socket file hilang. Alternatif singkat untuk tes:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"443\" height=\"46\" src=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-24.png\" alt=\"\" class=\"wp-image-10099\" srcset=\"https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-24.png 443w, https:\/\/www.jetorbit.com\/panduan\/wp-content\/uploads\/2025\/09\/image-24-300x31.png 300w\" sizes=\"(max-width: 443px) 100vw, 443px\" \/><\/figure>\n\n\n\n<p>Mengecek status MySQL penting untuk memastikan layanan database berjalan normal. Cara paling umum adalah menggunakan perintah systemctl status mysql untuk melihat apakah service aktif. Selain itu, bisa juga dicek dengan ps aux | grep mysql untuk memastikan prosesnya, netstat -tulnp | grep 3306 untuk melihat port, atau mencoba login langsung memakai mysql -u root -p. Jika MySQL tidak berjalan, periksa log error di \/var\/log\/mysql\/ untuk menemukan penyebabnya. Dengan memahami cara ini, kita bisa cepat mendeteksi masalah dan menjaga database tetap stabil.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL \/ MariaDB adalah program yang menyimpan data untuk aplikasi (mis. website, webmail, Roundcube). Mengetahui apakah MySQL sedang berjalan penting sebelum mencoba koneksi, backup, atau debug aplikasi: kalau server database mati, aplikasi tidak bisa baca\/tulis data dan akan muncul error. Mengecek status juga membantu kita menemukan apakah masalahnya \u201cservice mati\u201d (harus dinyalakan ulang), \u201cservice jalan [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":2809,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-10097","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dasar"],"_links":{"self":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/10097","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/comments?post=10097"}],"version-history":[{"count":1,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/10097\/revisions"}],"predecessor-version":[{"id":10103,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/posts\/10097\/revisions\/10103"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/media\/2809"}],"wp:attachment":[{"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/media?parent=10097"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/categories?post=10097"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jetorbit.com\/panduan\/wp-json\/wp\/v2\/tags?post=10097"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}