{"id":26263,"date":"2022-01-26T17:47:51","date_gmt":"2022-01-26T10:47:51","guid":{"rendered":"https:\/\/www.rumahweb.com\/journal\/?p=26263"},"modified":"2022-09-29T19:11:25","modified_gmt":"2022-09-29T12:11:25","slug":"cara-upgrade-mysql-version-melalui-whm-cpanel","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/cara-upgrade-mysql-version-melalui-whm-cpanel\/","title":{"rendered":"Cara Upgrade MySQL Version Melalui WHM cPanel"},"content":{"rendered":"\n<p>Seperti yang telah kita ketahui bersama, WHM merupakan control panel yang digunakan untuk pengguna VPS yang dipesan sepaket dengan lisensi cPanel. Dengan WHM, kita bisa melakukan konfigurasi di sisi server VPS kita. Pada panduan kali ini, kami akan berbagi cara upgrade MySQL Version melalui <a href=\"https:\/\/blog.rumahweb.com\/perbedaan-cpanel-dan-whm\/#Apa_itu_WHM\" title=\"whm adalah\">WHM<\/a> dengan sangat mudah.<\/p>\n\n\n\n\n\n<p>MySQL adalah database management system yang banyak digunakan developer web aplikasi untuk mengembangkan layanannya. Pengguna database MySQL sendiri sudah banyak dan memiliki beberapa forum komunitas yang siap membantu Anda dalam troubleshooting kendala yang dialami.<\/p>\n\n\n\n<p>Cara upgrade MySQL version melalui WHM terbilang mudah, karena dilakukan melalui control panel WHM yang telah GUI. Berikut langkah-langkah upgrade MySQL version melalui WHM\/cPanel:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"cara-upgrade-mysql-version-melalui-whm\">Cara upgrade MySQL version melalui WHM<\/h2>\n\n\n\n<p>Ada beberapa tahapan yang perlu anda lakukan untuk upgrade MySQL Version, seperti melakukan backup terlebih dahulu, lalu melakukan upgrade versi yang tersedia. Berikut langkah-langkahnya.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-1-backup-database\">Step 1. Backup Database<\/h3>\n\n\n\n<p>Pada langkah awal, Anda perlu login <strong>https:\/\/ip_vps:2087<\/strong> sebagai root dan selanjutnya lakukan backup di VPS. Proses backup dilakukan melalui menu Backup-&gt;Backup Configuration.<\/p>\n\n\n\n<p>Setelah proses backup selesai, silahkan masuk ke menu <em><strong>MySQL\/MariaDB Upgrade<\/strong><\/em> sesuai gambar dibawah:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/MySQL-Upgrade-WHM.png\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"390\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/MySQL-Upgrade-WHM.png\" alt=\"Upgrade MySQL version \" class=\"wp-image-26755\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/MySQL-Upgrade-WHM.png 700w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/MySQL-Upgrade-WHM-300x167.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/MySQL-Upgrade-WHM-370x206.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/MySQL-Upgrade-WHM-270x150.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/MySQL-Upgrade-WHM-570x318.png 570w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/a><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-2-mysql-mariadb-upgrade\">Step 2. <strong>MySQL\/MariaDB Upgrade<\/strong><\/h3>\n\n\n\n<p>Langkah kedua, Anda bisa melihat versi database yang digunakan saat ini. Dalam list versi database juga terdapat beberapa varian yang bisa Anda pilih, baik sesuai rekomendasi atau diluar rekomendasi.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/menu-mysql-whmcpanel.png\"><img loading=\"lazy\" decoding=\"async\" width=\"952\" height=\"612\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/menu-mysql-whmcpanel.png\" alt=\"Cara upgrade versi MySQL, MySQL\/MariaDB Upgrade\" class=\"wp-image-26760\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/menu-mysql-whmcpanel.png 952w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/menu-mysql-whmcpanel-300x193.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/menu-mysql-whmcpanel-768x494.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/menu-mysql-whmcpanel-370x238.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/menu-mysql-whmcpanel-270x174.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/menu-mysql-whmcpanel-570x366.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/menu-mysql-whmcpanel-740x476.png 740w\" sizes=\"auto, (max-width: 952px) 100vw, 952px\" \/><\/a><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-3-testing-kesiapan-server\">Step 3. <strong>Testing Kesiapan Server<\/strong><\/h3>\n\n\n\n<p>Setelah memilih versi database, Anda akan diarahkan ke menu testing yang bertujuan melakukan debug server, apakah telah siap atau belum menerima versi DB terbaru.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/run-checker-whm.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/run-checker-whm.png\" alt=\"\" class=\"wp-image-26763\" width=\"455\" height=\"292\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/run-checker-whm.png 507w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/run-checker-whm-300x192.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/run-checker-whm-370x237.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/run-checker-whm-270x173.png 270w\" sizes=\"auto, (max-width: 455px) 100vw, 455px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>Pada gambar diatas, Anda bisa klik tombol <strong>Run Checker<\/strong> dan menunggu hingga hasilnya muncul. Untuk perkiraan hasil seperti gambar dibawah, pastikan tidak ada error agar proses upgradenya nanti tidak terkendala.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/Screenshot_4-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"649\" height=\"470\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/Screenshot_4-1.png\" alt=\"run checker MySQL WHM\/cPanel\" class=\"wp-image-26592\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/Screenshot_4-1.png 649w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/Screenshot_4-1-300x217.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/Screenshot_4-1-370x268.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/Screenshot_4-1-270x196.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/Screenshot_4-1-570x413.png 570w\" sizes=\"auto, (max-width: 649px) 100vw, 649px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-4-upgrade-mysql-type\">Step 4. <strong>Upgrade MySQL Type<\/strong><\/h3>\n\n\n\n<p>Langkah upgrade selanjutnya yaitu pemilihan tipe upgrade yang akan digunakan. Anda dapat memilih salah satu seperti gambar dibawah. <\/p>\n\n\n\n<p>Dalam hal ini, tidak ada rekomendasi dari kami karena pemilihan ini tergatung kondisi server yang digunakan dari hasil checker database sebelumnya.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/tipe-upgrade-versi-mysql-whmcpanel.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"446\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/tipe-upgrade-versi-mysql-whmcpanel-1024x446.png\" alt=\"Upgrade type MySQL WHM\/cPanel\" class=\"wp-image-26757\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/tipe-upgrade-versi-mysql-whmcpanel-1024x446.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/tipe-upgrade-versi-mysql-whmcpanel-300x131.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/tipe-upgrade-versi-mysql-whmcpanel-768x335.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/tipe-upgrade-versi-mysql-whmcpanel-370x161.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/tipe-upgrade-versi-mysql-whmcpanel-270x118.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/tipe-upgrade-versi-mysql-whmcpanel-570x248.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/tipe-upgrade-versi-mysql-whmcpanel-740x323.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/tipe-upgrade-versi-mysql-whmcpanel.png 1085w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Jika telah ditentukan, silahkan Anda klik &#8216;<strong>Continue<\/strong>&#8216; untuk melanjutkan proses upgrade versi MySQL dari WHM\/cPanel. Untuk detail progressnya akan terlihat seperti gambar dibawah.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/upgrade-versi-mysq-dari-whmcpanel.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"262\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/upgrade-versi-mysq-dari-whmcpanel.png\" alt=\"Upgrade MySQL WHM\/cPanel\" class=\"wp-image-26766\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/upgrade-versi-mysq-dari-whmcpanel.png 624w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/upgrade-versi-mysq-dari-whmcpanel-300x126.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/upgrade-versi-mysq-dari-whmcpanel-370x155.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/upgrade-versi-mysq-dari-whmcpanel-270x113.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2022\/01\/upgrade-versi-mysq-dari-whmcpanel-570x239.png 570w\" sizes=\"auto, (max-width: 624px) 100vw, 624px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>Proses upgrade MySQL version dari WHM membutuhkan waktu, sehingga Anda hanya perlu menunggu hingga upgrade selesai. Setelah proses upgrade selesai, silahkan restart servernya.<\/p>\n\n\n\n<p>Demikian cara upgrade MySQL version dari WHM. semoga bermanfaat. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seperti yang telah kita ketahui bersama, WHM merupakan control panel yang digunakan untuk pengguna VPS yang dipesan sepaket dengan lisensi cPanel. Dengan WHM, kita bisa melakukan konfigurasi di sisi server VPS kita. Pada panduan kali ini, kami akan berbagi cara upgrade MySQL Version melalui WHM dengan sangat mudah. MySQL adalah database management system yang banyak [&hellip;]<\/p>\n","protected":false},"author":338,"featured_media":26585,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[695,177],"tags":[18,134,1308,431],"class_list":{"0":"post-26263","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-cpanel","8":"category-vps","9":"tag-cpanel","10":"tag-mysql","11":"tag-tutorial-whm","12":"tag-whm"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/26263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/users\/338"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/comments?post=26263"}],"version-history":[{"count":0,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/26263\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/26585"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=26263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=26263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=26263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}