{"id":1933,"date":"2022-09-08T13:59:14","date_gmt":"2022-09-08T06:59:14","guid":{"rendered":"https:\/\/www.jagoweb.com\/kb\/?post_type=ht_kb&p=1933"},"modified":"2022-10-31T15:03:53","modified_gmt":"2022-10-31T08:03:53","slug":"cara-hapus-spam-postingan-wordpress-di-phpmyadmin","status":"publish","type":"ht_kb","link":"https:\/\/www.jagoweb.com\/kb\/knowledge-base-jagoweb\/cara-hapus-spam-postingan-wordpress-di-phpmyadmin\/","title":{"rendered":"Cara Hapus Spam Postingan WordPress di phpMyAdmin"},"content":{"rendered":"

Cara Hapus Spam Postingan WordPress di phpMyAdmin<\/strong> – Setiap website pastinya selalu rawan dengan spam, hal ini bisa menurunkan kualitas website kita. Maka dari itu, tutorial berikut adalah menangani salah satu alasan kenapa disk hosting kita penuh, yaitu Spam Postingan<\/strong><\/em>. Terkadang, spam postingan ini bisa dilihat langsung di WP-ADMIN anda dibagian\u00a0Post<\/strong>, jika ada dibagian ini, maka mudah, bisa langsung anda delete permanent saja. Tetapi, jika anda cek tidak ada, maka Spam ini bisa dilihat di phpMyAdmin > klik nama database wordpressnya > klik namadatabase wordpress_post (contoh: wp32_post) . untuk menghapus spam ini, bisa mengikuti tutorial berikut:<\/p>\n

Note:<\/strong><\/em>\u00a0-Pastikan bahwa anda sudah backup data wordpress maupun database anda (rekomendasi fullbackup)<\/strong><\/em>\u00a0-Silahkan persiapkan Google Webmaster Tools anda terlebih dahulu<\/strong><\/em><\/p>\n

1.Masuk cPanel anda. Bisa melalui client area, atau melalui namadomainanda.com\/cpanel<\/p>\n

\"\"<\/p>\n

2. Silahkan masuk ke\u00a0phpMyAdmin\u00a0<\/strong><\/p>\n

3. Masuk ke database wordpress<\/a> anda dan klik (contoh: wp3_post<\/strong><\/em>). Baca Selengkapnya: Cara Login ke Admin<\/a><\/strong> WordPress<\/a><\/p>\n

\"\"<\/p>\n

4. Lalu masukkan kode berikut. Jika sudah selesai, klik\u00a0Go<\/strong>\u00a0DELETE FROM wp_posts where<\/strong>\u00a0post_status like ‘%test%’<\/strong>\u00a0*bagian wp_post silahkan diganti dengan nama asli database anda (contoh: wp3_post) *bagian post_status silahkan bisa diganti sesuai spamnya, misal spam ada di post_type:spam maka ganti ke post_type *bagian\u00a0‘%test%’\u00a0<\/strong>bisa diganti\u00a0‘%spam%’\u00a0<\/strong>sesuai dengan status atau tipe spamnya<\/p>\n

\"\" \"\"<\/p>\n

5. Selanjutnya, silahkan\u00a0Review\u00a0<\/strong>web anda dengan\u00a0Google Webmaster Tool<\/strong><\/p>\n

\"\"<\/p>\n","protected":false},"author":3,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":[],"ht_kb_category":[105,104],"ht_kb_tag":[316,315,317,85],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb\/1933"}],"collection":[{"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/comments?post=1933"}],"version-history":[{"count":4,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb\/1933\/revisions"}],"predecessor-version":[{"id":1991,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb\/1933\/revisions\/1991"}],"wp:attachment":[{"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/media?parent=1933"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb_category?post=1933"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.jagoweb.com\/kb\/wp-json\/wp\/v2\/ht_kb_tag?post=1933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}