{"id":79143,"date":"2017-02-17T10:33:52","date_gmt":"2017-02-17T15:33:52","guid":{"rendered":"https:\/\/www.templatemonster.com\/help\/?p=79143"},"modified":"2017-07-12T03:36:28","modified_gmt":"2017-07-12T07:36:28","slug":"wordpress-change-database-tables-prefix-via-admin-panel","status":"publish","type":"post","link":"https:\/\/www.templatemonster.com\/help\/wordpress-change-database-tables-prefix-via-admin-panel.html","title":{"rendered":"WordPress. How to change database tables prefix via admin panel"},"content":{"rendered":"<p>Our Support team is ready to present you a new tutorial that shows how to manage <strong>database tables prefix<\/strong> via admin panel.<\/p>\r\n\r\n <div class=\"video-container\">\r\n\t<iframe src=\"https:\/\/www.youtube.com\/embed\/ncC1jMcVU4I\"><\/iframe>\r\n<\/div>\r\n<p>WordPress Database is like a brain for your entire WordPress site because every single information is stored in there thus making it hacker&#8217;s favorite target. Spammers and hackers run automated codes for SQL injections.<\/p>\r\n<p>Well, unfortunately many people forget to change the database prefix while they install WordPress. This makes it easier for hackers to plan a mass attack by targeting the default prefix <strong>wp_<\/strong>. \r\n\t<p>The smartest way you can protect your database is by changing the database prefix which is really easy to do on a site that you are setting up. But it takes a few steps to change the WordPress database prefix properly for your established site without completely messing it up.<\/p>\r\n\t<p class=\"attention\">We recommend that you <a target=\"_blank\" href=\"\/help\/phpmyadmin-how-to-backup-a-database.html\">backup your WordPress Database<\/a> before you perform anything suggested in this tutorial.<\/p>\r\n<div class=\"inline-banner\">\r\n<a href=\"https:\/\/www.templatemonster.com\/service-center\/\">\r\n<img src=\"\/help\/files\/banners\/inline\/Banner-3-(835-x100).jpg\" \/>\r\n<\/a>\r\n<\/div>\r\n\t<p>You will be able to change  <strong>database tables prefix<\/strong> via <strong>WordPress admin panel.<\/strong><\/p>\r\n\t<ol>\r\n\t\t<li><p>Navigate to <strong>Plugins -> Add new<\/strong> section.<\/p><\/li>\r\n\t\t<li><p>Type in search <strong>change-table-prefix<\/strong> , you will see a list of recommended plugins .<\/p><\/li>\r\n\t\t<li><p>Click on <strong>Install Now &amp; Activate Change Table Prefix plugin .<\/strong> <\/p>\r\n\t\t\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2017\/02\/WordPress.How_to_change_database_tables_prefix_via_admin_panel_1.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2017\/02\/WordPress.How_to_change_database_tables_prefix_via_admin_panel_1.png\" alt=\"WordPress.How_to_change_database_tables_prefix_via_admin_panel_1\" width=\"981\" height=\"856\" class=\"alignnone size-full wp-image-79144\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/02\/WordPress.How_to_change_database_tables_prefix_via_admin_panel_1.png 981w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/02\/WordPress.How_to_change_database_tables_prefix_via_admin_panel_1-150x131.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/02\/WordPress.How_to_change_database_tables_prefix_via_admin_panel_1-300x262.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/02\/WordPress.How_to_change_database_tables_prefix_via_admin_panel_1-768x670.png 768w\" sizes=\"(max-width: 981px) 100vw, 981px\" \/><\/a>\t\t\t\r\n\t\t<\/li>\r\n\t\t<li><p>After that, navigate to <strong>Settings -> Change table prefix<\/strong>.<\/p><\/li>\r\n\t\t<li><p>Select the following option, <strong>Would you like to use your own custom prefix <\/strong> and  type a prefix you want to use in field, for example <strong> wpnew_ <\/strong>. <\/p><\/li>\r\n\t\t<li><p>You will get a message about successful prefix replacement. <\/p>\r\n\t\t\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2017\/02\/WordPress.How_to_change_database_tables_prefix_via_admin_panel_2.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2017\/02\/WordPress.How_to_change_database_tables_prefix_via_admin_panel_2.png\" alt=\"WordPress.How_to_change_database_tables_prefix_via_admin_panel_2\" width=\"979\" height=\"849\" class=\"alignnone size-full wp-image-79145\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/02\/WordPress.How_to_change_database_tables_prefix_via_admin_panel_2.png 979w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/02\/WordPress.How_to_change_database_tables_prefix_via_admin_panel_2-150x130.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/02\/WordPress.How_to_change_database_tables_prefix_via_admin_panel_2-300x260.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2017\/02\/WordPress.How_to_change_database_tables_prefix_via_admin_panel_2-768x666.png 768w\" sizes=\"(max-width: 979px) 100vw, 979px\" \/><\/a>\t\t\t\r\n\t\t<\/li>\r\n\t<\/ol>\r\n\t<p><strong>Description<\/strong><\/p>\r\n\t<p>This plugin is mainly useful if you have not changed the database prefix at the time of installation and want to change afterwards to make your website more secure and protect from SQL injections. With the use of this plugin, you can easily replace your database default prefix to other prefix by a single click.<\/p>\r\n\t<p>As in most of the cases adminer are not changing the WordPress default database table prefix, it is easy for any hackers to inject to your database as all the default tables name are know for all. But if you modify your database tables prefix then your tables name become unknown to outside world. Now the question is how to change table prefix.<\/p>\r\n\t<p><strong>Features:<\/strong><\/p>\r\n\t<ul class=\"list\">\r\n\t\t<li><p>Can change database tables prefix in post installation.<\/p><\/li>\r\n\t\t<li><p>Tables prefix will change by single click.<\/p><\/li>\r\n\t\t<li><p>Works well for multi site present in a single database.<\/p><\/li>\r\n\t\t<li><p>Both the custom and random generated prefix facility available.<\/p><\/li>\r\n\t\t<li><p>Minimize the SQL injection.<\/p><\/li>\r\n\t<\/ul>\r\n\t<p>Thank you for reading this tutorial. Now you know how to change <strong>database tables prefix<\/strong> via WordPress admin panel.<\/p>\r\n<p>Do you want the best <a href=\"https:\/\/www.templatemonster.com\/wordpress-themes.php\" target=\"_blank\" title=\"WordPress Themes\">WordPress template<\/a> of this year? Look through our selection of the <a href=\"https:\/\/www.templatemonster.com\/blog\/2017-best-wordpress-themes\/\" target=\"_blank\" title=\"Best WordPress Themes 2017\">best WordPress themes in 2017<\/a>.<\/p>\r\n<p>Feel free to check the detailed video tutorial below:<\/p>\r\n<a href=\"http:\/\/www.youtube.com\/watch?v=ncC1jMcVU4I?width=1280&amp;height=720\" rel=\"prettyPhoto\">WordPress. How to change database tables prefix via admin panel<\/a>","protected":false},"excerpt":{"rendered":"<p>Our Support team is ready to present you a new tutorial that shows how to manage <strong>database tables prefix<\/strong> via admin panel.<\/p>\n","protected":false},"author":77,"featured_media":79146,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[728],"tags":[545,1095,2405],"_links":{"self":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/79143"}],"collection":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/comments?post=79143"}],"version-history":[{"count":2,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/79143\/revisions"}],"predecessor-version":[{"id":81902,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/79143\/revisions\/81902"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media\/79146"}],"wp:attachment":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media?parent=79143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/categories?post=79143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/tags?post=79143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}