{"id":52603,"date":"2025-01-13T15:45:38","date_gmt":"2025-01-13T08:45:38","guid":{"rendered":"https:\/\/www.rumahweb.com\/journal\/?p=52603"},"modified":"2025-01-13T15:47:33","modified_gmt":"2025-01-13T08:47:33","slug":"cara-menghapus-spam-post-di-wordpress","status":"publish","type":"post","link":"https:\/\/www.rumahweb.com\/journal\/cara-menghapus-spam-post-di-wordpress\/","title":{"rendered":"Cara Menghapus SPAM Post di WordPress"},"content":{"rendered":"\n<p>SPAM <em>post <\/em>di WordPress adalah konten yang dibuat secara otomatis dan dipublikasikan massal, biasanya oleh <em>malware<\/em>, dengan tujuan tertentu, seperti promosi judi online yang saat ini marak. Dalam artikel ini, kami akan membahas bagaimana cara menghapus SPAM <em>post <\/em>di WordPress secara mudah melalui <em>query <\/em>database.<\/p>\n\n\n\n\n\n<p>Namun, sebelum memulai langkah-langkah untuk menghapus SPAM <em>post <\/em>di WordPress, penting untuk Anda pahami penyebab munculnya SPAM tersebut. Simak informasi berikut ini.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Penyebab Munculnya SPAM <em>Post\u00a0<\/em><\/strong><\/h2>\n\n\n\n<p>Berikut ini adalah beberapa kemungkinan penyebab munculnya SPAM postingan di website WordPress Anda:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Kombinasi Password WordPress<\/strong> <strong>yang lemah:<\/strong> Password yang mudah ditebak membuat akun Anda rentan dibobol oleh <em>hacker <\/em>dan digunakan untuk menyebarkan spam <em>post<\/em>.<\/li>\n\n\n\n<li><strong>Celah Keamanan WordPress:<\/strong> Eksploitasi celah keamanan pada file core WordPress, plugin, atau tema dapat memungkinkan <em>spammer <\/em>untuk membuat postingan baru tanpa izin. Pastikan untuk selalu melakukan update versi WordPress, theme dan plugin yang digunakan untuk menghindari celah keamanan.<\/li>\n\n\n\n<li><strong>Serangan <em>Brute Force<\/em>:<\/strong> Serangan <em><a href=\"https:\/\/www.rumahweb.com\/journal\/apa-itu-brute-force-adalah\/\" target=\"_blank\" rel=\"noopener\" title=\"apa itu brute  force  adalah\">brute force<\/a><\/em> bertujuan untuk menebak password dan mendapatkan akses ke dashboard WordPress.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Menghapus SPAM Post<\/strong> di WordPress<\/h2>\n\n\n\n<p>Menghapus SPAM postingan di WordPress bisa dilakukan dengan dua\u00a0cara, yaitu melalui <em>dashboard <\/em>WordPress secara langsung atau melalui database di halaman phpMyAdmin. <\/p>\n\n\n\n<p>Jika postingan tidak terlalu banyak, Anda bisa menghapus secara langsung melalui dashboard WordPress. Namun, jika jumlahnya banyak, penghapusan akan lebih efisien apabila dilakukan melalui phpMyAdmin.<\/p>\n\n\n\n<p>Pada artikel kali ini, kami akan menjelaskan cara menghapus SPAM postingan melalui phpMyAdmin. Silahkan Anda simak langkah-langkahnya di bawah ini:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Login ke <a href=\"https:\/\/www.rumahweb.com\/journal\/cara-login-cpanel\/\" title=\"\">cPanel hosting<\/a> Anda.<\/li>\n\n\n\n<li>Guna mencegah kemungkinan kehilangan data jika terjadi kesalahan pada proses yang akan dilakukan, silahkan Anda melakukan<a href=\"https:\/\/www.rumahweb.com\/journal\/cara-membuat-backup-data-di-cpanel\/\"> backup data <\/a>terlebih dahulu.<\/li>\n\n\n\n<li>Setelah selesai membackup data, selanjutnya Akses phpMyAdmin.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/menu-phpmyadmin-di-cpanel.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"347\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/menu-phpmyadmin-di-cpanel-1024x347.png\" alt=\"Menu phpmyadmin di cpanel\" class=\"wp-image-52604\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/menu-phpmyadmin-di-cpanel-1024x347.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/menu-phpmyadmin-di-cpanel-300x102.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/menu-phpmyadmin-di-cpanel-768x260.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/menu-phpmyadmin-di-cpanel-370x125.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/menu-phpmyadmin-di-cpanel-270x92.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/menu-phpmyadmin-di-cpanel-570x193.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/menu-phpmyadmin-di-cpanel-740x251.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/menu-phpmyadmin-di-cpanel.png 1150w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>Pilih database yang digunakan oleh instalasi WordPress Anda.&nbsp;<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/database-di-phpmyadmin.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"339\" height=\"466\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/database-di-phpmyadmin.jpg\" alt=\"database di phpmyadmin\" class=\"wp-image-52605\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/database-di-phpmyadmin.jpg 339w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/database-di-phpmyadmin-218x300.jpg 218w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/database-di-phpmyadmin-270x371.jpg 270w\" sizes=\"auto, (max-width: 339px) 100vw, 339px\" \/><\/a><\/figure>\n<\/div>\n\n\n<p>Jika Anda tidak yakin dengan database yang akan Anda Edit, periksa file wp-config.php di folder instalasi WordPress Anda. Cari baris yang mendefinisikan DB_NAME.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/cek-nama-database-di-wp-config.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"739\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/cek-nama-database-di-wp-config-1024x739.jpg\" alt=\"memeriksa nama database di  file wp-config\" class=\"wp-image-52606\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/cek-nama-database-di-wp-config-1024x739.jpg 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/cek-nama-database-di-wp-config-300x217.jpg 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/cek-nama-database-di-wp-config-768x554.jpg 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/cek-nama-database-di-wp-config-370x267.jpg 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/cek-nama-database-di-wp-config-270x195.jpg 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/cek-nama-database-di-wp-config-570x411.jpg 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/cek-nama-database-di-wp-config-740x534.jpg 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/cek-nama-database-di-wp-config.jpg 1175w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<ol start=\"5\" class=\"wp-block-list\">\n<li>Setelah memilih database, cari tabel bernama wp_posts dan klik untuk membukanya. Anda bisa memperhatikan kolom post_content (isi postingan) dan post_title (judul postingan).\u00a0Cari kata-kata SPAM dan ingin Anda hapus.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/tampilan-tabel-wp_post.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"441\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/tampilan-tabel-wp_post-1024x441.jpg\" alt=\"tampilan isi tabel wp_posts wordpress\" class=\"wp-image-52607\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/tampilan-tabel-wp_post-1024x441.jpg 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/tampilan-tabel-wp_post-300x129.jpg 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/tampilan-tabel-wp_post-768x331.jpg 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/tampilan-tabel-wp_post-370x159.jpg 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/tampilan-tabel-wp_post-270x116.jpg 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/tampilan-tabel-wp_post-570x245.jpg 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/tampilan-tabel-wp_post-740x319.jpg 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/tampilan-tabel-wp_post.jpg 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<ol start=\"6\" class=\"wp-block-list\">\n<li>Selanjutnya, untuk menghapus SPAM <em>post<\/em>, silahkan kik tab SQL di bagian atas halaman phpMyAdmin, lalu masukkan query SQL berikut:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Menghapus postingan konten SPAM berdasarkan isi postingan<br \/><\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE FROM wp_posts WHERE post_content LIKE '%kata_spam%';\n<\/code><\/pre>\n\n\n\n<ul start=\"2\" class=\"wp-block-list\">\n<li>Anda juga bisa menghapus postingan konten SPAM berdasarkan isi postingan dan judul postingan<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE FROM wp_posts WHERE post_content LIKE '%kata_spam%' OR post_title LIKE '%kata_spam%';<\/code><\/pre>\n\n\n\n<p>Ganti <strong>wp_posts<\/strong> dengan nama tabel database Anda dan ganti <strong>kata_spam<\/strong> dengan kata atau frasa di postingan SPAM yang ingin anda hapus. Lalu, <strong>Klik &#8220;Kirim&#8221; atau &#8220;Go&#8221;<\/strong> untuk menjalankan <em>query<\/em>.\u00a0<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/query-database.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"529\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/query-database-1024x529.png\" alt=\"Menjalankan query database di phpmyadmin\" class=\"wp-image-52608\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/query-database-1024x529.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/query-database-300x155.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/query-database-768x397.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/query-database-370x191.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/query-database-270x140.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/query-database-570x295.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/query-database-740x382.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/query-database.png 1275w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Setelah menjalankan <em>query<\/em>, phpMyAdmin akan menampilkan jumlah baris yang di hapus.\u00a0Hal ini memastikan bahwa <em>query <\/em>berjalan sesuai yang diharapkan.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/hasil-hapus-spam.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"242\" src=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/hasil-hapus-spam-1024x242.png\" alt=\"Hasil menghapus SPAM Post di WordPress melalui query\" class=\"wp-image-52609\" srcset=\"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/hasil-hapus-spam-1024x242.png 1024w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/hasil-hapus-spam-300x71.png 300w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/hasil-hapus-spam-768x182.png 768w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/hasil-hapus-spam-370x87.png 370w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/hasil-hapus-spam-270x64.png 270w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/hasil-hapus-spam-570x135.png 570w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/hasil-hapus-spam-740x175.png 740w, https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/hasil-hapus-spam.png 1201w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Selanjutnya, Anda dapat melakukan pengecekan kembali di website guna memastikan postingan SPAM telah terhapus<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Tips <strong>Mencegah SPAM Post di WordPress<\/strong><\/h2>\n\n\n\n<p>Berikut adalah beberapa tips untuk mencegah spam postingan di WordPress yang dapat Anda lakukan:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Gunakan kata sandi yang kuat dan unik untuk login ke dashboard\u00a0WordPress Anda. Hindari menggunakan kata sandi yang mudah ditebak, seperti\u00a0&#8216;admin, admin123, <em>password<\/em>, dll&#8217;<\/li>\n\n\n\n<li>Aktifkan 2FA login ke dashboard WordPress, aktifkan fitur recaptcha dan batasi jumlah percobaan login yang gagal dalam waktu tertentu. Ini dapat membantu mencegah serangan <em>brute force<\/em> <em>attack<\/em>.<\/li>\n\n\n\n<li>Batasi hak akses pengguna\/role akses user. Berikan izin hanya kepada user yang dipercaya.<\/li>\n\n\n\n<li>Selalu lakukan update versi WordPress, theme, dan Plugin ke versi yang lebih baru, untuk menghindari celah keamanan di versi sebelumnya.<\/li>\n<\/ol>\n\n\n\n<p>Selengkapnya tentang cara meningkatkan keamanan pada WordPress bisa Anda pelajari pada artikel berikut: <a href=\"https:\/\/www.rumahweb.com\/journal\/cara-mengamankan-website-wordpress\/\" target=\"_blank\" rel=\"noopener\" title=\"\">Cara mengamankan website WordPress<\/a><\/p>\n\n\n\n<p>Demikian artikel panduan menghapus SPAM <em>post <\/em>di WordPress, silahkan mencoba dan semoga bermanfaat.<br \/><br \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SPAM post di WordPress adalah konten yang dibuat secara otomatis dan dipublikasikan massal, biasanya oleh malware, dengan tujuan tertentu, seperti promosi judi online yang saat ini marak. Dalam artikel ini, kami akan membahas bagaimana cara menghapus SPAM post di WordPress secara mudah melalui query database. Namun, sebelum memulai langkah-langkah untuk menghapus SPAM post di WordPress, [&hellip;]<\/p>\n","protected":false},"author":339,"featured_media":52649,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[463],"tags":[35,2431,14],"class_list":{"0":"post-52603","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-wordpress","8":"tag-spam","9":"tag-spam-post","10":"tag-wordpress"},"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.rumahweb.com\/journal\/wp-content\/uploads\/2025\/01\/Banner-Cara-Menghapus-SPAM-Post-di-WordPress.png","jetpack_shortlink":"https:\/\/wp.me\/p8n3G7-dGr","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/52603","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\/339"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/comments?post=52603"}],"version-history":[{"count":0,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/posts\/52603\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media\/52649"}],"wp:attachment":[{"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/media?parent=52603"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/categories?post=52603"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rumahweb.com\/journal\/wp-json\/wp\/v2\/tags?post=52603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}