{"id":14029,"date":"2024-06-19T10:00:00","date_gmt":"2024-06-19T01:00:00","guid":{"rendered":"https:\/\/hanami-web.tokyo.jp\/blog\/?p=14029"},"modified":"2024-06-20T11:42:18","modified_gmt":"2024-06-20T02:42:18","slug":"databese-security","status":"publish","type":"post","link":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/security-plugin\/all-in-one-wp-security\/databese-security\/","title":{"rendered":"WordPress security enhancement plugin All in one WP Security ~ Settings to enhance database security"},"content":{"rendered":"<p>A must-read for those who are concerned about the security of their WordPress site<br>We explain how to enhance security with the free All in one WP Security plugin.<\/p>\n\n\n\n<p>This time, we will explain Database Security &gt; Database Prefix Settings.<\/p>\n\n\n\n<p>For more information, please see the All in one WP Security explanation table of contents!<\/p>\n\n\n<div class=\"sc\"><a href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wpsecurity\/\" title=\"Strengthening the security of your WordPress site All in one WP Security plugin setup guide Table of contents\">\r\n\t<p class=\"sc-txt01\">Securing your WordPress site<\/p>\r\n\t<p class=\"sc-txt02\">All in one WP Security Setting Explanation Table of Contents \u2192<\/p>\r\n<\/a><\/div>\r\n\n\n\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">table of contents<\/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: #000000;color:#000000\" 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: #000000;color:#000000\" 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-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/security-plugin\/all-in-one-wp-security\/databese-security\/#all_in_one_secyrity%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e6%8e%a5%e9%a0%ad%e8%be%9e%e8%a8%ad%e5%ae%9a%e3%81%a8%e3%81%af\" >What is the database prefix setting for All in one Security?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/security-plugin\/all-in-one-wp-security\/databese-security\/#%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e3%83%90%e3%83%83%e3%82%af%e3%82%a2%e3%83%83%e3%83%97\" >Database Backup<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/hanami-web.tokyo.jp\/blog\/en\/security-plugin\/all-in-one-wp-security\/databese-security\/#%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e3%81%ae%e6%8e%a5%e9%a0%ad%e8%be%9e%e3%82%92%e5%a4%89%e6%8f%9b\" >Convert database prefix<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"all_in_one_secyrity%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e6%8e%a5%e9%a0%ad%e8%be%9e%e8%a8%ad%e5%ae%9a%e3%81%a8%e3%81%af\"><\/span>What is the database prefix setting for All in one Security?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Many people probably do a quick install of WordPress. The database name is automatically generated, but in many cases it is set to &quot;wp_&quot; by default, which is dangerous because it is easily deciphered, so this function converts it to a different prefix.<\/p>\n\n\n\n<p>Since the database name will change, please back up the database before proceeding.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>WP Security<\/li>\n\n\n\n<li>Database Security<\/li>\n\n\n\n<li>Database prefix<\/li>\n<\/ul>\n\n\n\n<p>and set it up.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"573\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-54-1024x573.png\" alt=\"\" class=\"wp-image-14031\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-54-1024x573.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-54-300x168.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-54-768x430.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-54-18x10.png 18w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-54.png 1281w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e3%83%90%e3%83%83%e3%82%af%e3%82%a2%e3%83%83%e3%83%97\"><\/span>Database Backup<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>First, switch tabs and back up your database.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"280\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-55-1024x280.png\" alt=\"\" class=\"wp-image-14032\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-55-1024x280.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-55-300x82.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-55-768x210.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-55-1536x420.png 1536w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-55-18x5.png 18w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-55.png 1572w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e3%81%ae%e6%8e%a5%e9%a0%ad%e8%be%9e%e3%82%92%e5%a4%89%e6%8f%9b\"><\/span>Convert database prefix<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Once you have the backup, switch to the Database Prefix Settings tab, turn on &quot;Generate new database table prefix&quot;, and click the &quot;Change database prefix&quot; button.<\/p>\n\n\n\n<p>You do not need to specify a new prefix.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"335\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-56-1024x335.png\" alt=\"\" class=\"wp-image-14033\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-56-1024x335.png 1024w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-56-300x98.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-56-768x251.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-56-1536x503.png 1536w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-56-18x6.png 18w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-56.png 1558w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Once the changes are complete, reload the page to see the changes.<br>Be sure to check the site and make sure there are no issues.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1021\" height=\"434\" src=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-57.png\" alt=\"\" class=\"wp-image-14034\" srcset=\"https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-57.png 1021w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-57-300x128.png 300w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-57-768x326.png 768w, https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/image-57-18x8.png 18w\" sizes=\"(max-width: 1021px) 100vw, 1021px\" \/><\/figure>","protected":false},"excerpt":{"rendered":"<p>WordPress\u30b5\u30a4\u30c8\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306b\u4e0d\u5b89\u304c\u3042\u308b\u65b9\u5fc5\u898b\u7121\u6599\u306eAll in one WP Secyruti\u30d7\u30e9\u30b0\u30a4\u30f3\u3067\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u5f37\u5316\u3092\u3059\u308b\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u3066\u3044\u307e\u3059\u3002 \u4eca\u56de\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u3000\uff1e\u3000\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u982d\u8f9e [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":14035,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","_uag_custom_page_level_css":"","footnotes":""},"categories":[1551],"tags":[1549],"class_list":["post-14029","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-all-in-one-wp-security","tag-all-in-one-security"],"blocksy_meta":[],"aioseo_notices":[],"uagb_featured_image_src":{"full":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/All-in-one-WP-Security-8.png",720,540,false],"thumbnail":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/All-in-one-WP-Security-8-150x150.png",150,150,true],"medium":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/All-in-one-WP-Security-8-300x225.png",300,225,true],"medium_large":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/All-in-one-WP-Security-8.png",720,540,false],"large":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/All-in-one-WP-Security-8.png",720,540,false],"1536x1536":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/All-in-one-WP-Security-8.png",720,540,false],"2048x2048":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/All-in-one-WP-Security-8.png",720,540,false],"trp-custom-language-flag":["https:\/\/hanami-web.tokyo.jp\/blog\/wp-content\/uploads\/2024\/05\/All-in-one-WP-Security-8-16x12.png",16,12,true]},"uagb_author_info":{"display_name":"\u682a\u5f0f\u4f1a\u793eHanamiWEB \u4ee3\u8868\u53d6\u7de0\u5f79 \u677e\u6d66\u307f\u3055","author_link":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/author\/hanami\/"},"uagb_comment_info":0,"uagb_excerpt":"WordPress\u30b5\u30a4\u30c8\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306b\u4e0d\u5b89\u304c\u3042\u308b\u65b9\u5fc5\u898b\u7121\u6599\u306eAll in one WP Secyruti\u30d7\u30e9&hellip;","brizy_media":[],"_links":{"self":[{"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/posts\/14029","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/comments?post=14029"}],"version-history":[{"count":0,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/posts\/14029\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/media\/14035"}],"wp:attachment":[{"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/media?parent=14029"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/categories?post=14029"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hanami-web.tokyo.jp\/blog\/en\/wp-json\/wp\/v2\/tags?post=14029"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}