{"id":2255,"date":"2024-06-24T13:28:12","date_gmt":"2024-06-24T12:28:12","guid":{"rendered":"https:\/\/hoganhost.com.ng\/blog\/?p=2255"},"modified":"2024-08-12T13:12:30","modified_gmt":"2024-08-12T12:12:30","slug":"how-to-change-the-table-prefix-for-wordpress","status":"publish","type":"post","link":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/","title":{"rendered":"How to Change the table prefix for WordPress"},"content":{"rendered":"<p><img fetchpriority=\"high\" decoding=\"async\" class=\"size-medium wp-image-2256 aligncenter\" src=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/Change-the-table-prefix-for-WordPress-300x300.jpg\" alt=\"\" width=\"300\" height=\"300\" srcset=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/Change-the-table-prefix-for-WordPress-300x300.jpg 300w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/Change-the-table-prefix-for-WordPress-1024x1024.jpg 1024w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/Change-the-table-prefix-for-WordPress-150x150.jpg 150w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/Change-the-table-prefix-for-WordPress-768x768.jpg 768w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/Change-the-table-prefix-for-WordPress.jpg 1080w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p data-i18n=\"00-NScX4XIL6v\">In this guide, we explain how to change the database table prefix of your WordPress installation.<\/p>\n<p data-i18n=\"01-Z2gFCfKlTZ\">The default database table prefix for WordPress is &#8216;wp_&#8217;; however, we recommend changing it. The reason for this is that all your login details are stored in your database, making your WordPress tables very popular targets for hackers. Changing the prefix makes it harder for them to break in.<\/p>\n<blockquote data-i18n=\"02-9magkVgGos\"><p><strong>Note:<\/strong>\u00a0If you have used the 1-click installer to install WordPress, then you already have a custom table prefix.<\/p><\/blockquote>\n<p data-i18n=\"03-NLhOy19z4h\">You need to change the table prefix in three places:<\/p>\n<hr \/>\n<h2 id=\"step-1\" data-i18n=\"07-1V9ccjnD1X\">Step 1 &#8211; Change the table prefix in wp-config.php<\/h2>\n<ol>\n<li data-i18n=\"08-QADw6PGZoM\">Log into the\u00a0<strong>hoganhost.com.ng control panel<\/strong>.<\/li>\n<li data-i18n=\"09-e9NYiLlFl4\">Open\u00a0<strong>File Manager<\/strong>\u00a0under\u00a0<strong>Files &amp; Security<\/strong>.<\/li>\n<li data-i18n=\"10-cceR75BCOm\">Locate the file\u00a0<em>wp-config.php<\/em>\u00a0and check the box to select it.<\/li>\n<li data-i18n=\"11-nDU21HJ7Mx\">Click\u00a0<strong>Edit<\/strong>\u00a0in the menu bar at the top of your screen.<\/li>\n<li data-i18n=\"12-1yCrLDOs9u\">Locate the following entry:<\/li>\n<\/ol>\n<pre data-i18n=\"13-3dON3tAMo1\">$table_prefix = 'wp_';<\/pre>\n<ol start=\"6\">\n<li data-i18n=\"14-vdDrb8R4Sh\">Replace\u00a0<em>&#8216;wp_&#8217;<\/em>\u00a0with something else; in this case, we replaced it with\u00a0<em>&#8216;david_&#8217;<\/em>:<\/li>\n<\/ol>\n<pre data-i18n=\"15-9NKYMmj7YS\">$table_prefix = 'david_';<\/pre>\n<ol start=\"7\">\n<li data-i18n=\"16-jF5Qxp2899\">Click\u00a0<strong>Save<\/strong> in the top-left corner. <img decoding=\"async\" class=\" wp-image-2257 aligncenter\" src=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/table-prefix-wp-config-300x203.png\" alt=\"\" width=\"740\" height=\"501\" srcset=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/table-prefix-wp-config-300x203.png 300w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/table-prefix-wp-config.png 716w\" sizes=\"(max-width: 740px) 100vw, 740px\" \/><\/li>\n<\/ol>\n<hr \/>\n<h2 id=\"step-2\" data-i18n=\"18-jPqSroGUjn\">Step 2 &#8211; Change the table prefix in the database<\/h2>\n<ol>\n<li data-i18n=\"19-a4rMPq4N1x\">Open your database in PhpMyAdmin.<\/li>\n<li data-i18n=\"20-j97uTAegNc\">Click on the database name in the menu to the left to unfold all tables.<\/li>\n<li data-i18n=\"21-Tx3jfBfrqO\">Select all tables that start with\u00a0<em>wp_<\/em>; you should have 12 in total.<\/li>\n<li data-i18n=\"22-8WbS3bX2Li\">Click\u00a0<strong>With selected<\/strong>\u00a0to open the drop-down menu and select\u00a0<strong>Replace table prefix<\/strong>.<\/li>\n<li data-i18n=\"23-Q40QhvgxZ3\">Type in\u00a0<em>wp_<\/em>\u00a0in the\u00a0<strong>From-field<\/strong>, and the new name in the\u00a0<strong>To-field<\/strong>, in this example,\u00a0<em>david_<\/em>.<\/li>\n<li data-i18n=\"24-j3mUj0bKSF\">Click\u00a0<strong>Continue<\/strong> to make the change. <img decoding=\"async\" class=\" wp-image-2258 aligncenter\" src=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/table-prefix-database-300x203.png\" alt=\"\" width=\"636\" height=\"430\" srcset=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/table-prefix-database-300x203.png 300w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/table-prefix-database.png 716w\" sizes=\"(max-width: 636px) 100vw, 636px\" \/><\/li>\n<\/ol>\n<hr \/>\n<h2 id=\"step-3\" data-i18n=\"26-Q1e9lxykVx\">Step 3 &#8211; Replace all references to the old prefix<\/h2>\n<p data-i18n=\"27-QSxSiaedS6\">In some settings that are stored in your database, WordPress still refers to the old table prefix. To complete changing the prefix, you need to replace these with your new prefix.<\/p>\n<ol>\n<li data-i18n=\"28-mIP3X4rWmE\">Click on the\u00a0<strong>SQL<\/strong>\u00a0tab in the menu at the top of the screen.<\/li>\n<li data-i18n=\"29-tMtjEe4brS\">Copy and paste in the following commands:<\/li>\n<\/ol>\n<pre data-i18n=\"30-4E08jL9MwX\">update NEWPREFIX_usermeta set meta_key = 'NEWPREFIX_capabilities' where meta_key = 'OLDPREFIX_capabilities';\r\nupdate NEWPREFIX_usermeta set meta_key = 'NEWPREFIX_user_level' where meta_key = 'OLDPREFIX_user_level';\r\nupdate NEWPREFIX_usermeta set meta_key = 'NEWPREFIX_autosave_draft_ids' where meta_key = 'OLDPREFIX_autosave_draft_ids';\r\nupdate NEWPREFIX_options set option_name = 'NEWPREFIX_user_roles' where option_name = 'OLDPREFIX_user_roles';\r\n<\/pre>\n<ol start=\"3\">\n<li data-i18n=\"31-jXjr5ASKX4\">Replace\u00a0<em>OLDPREFIX<\/em>\u00a0and\u00a0<em>NEWPREFIX<\/em>, with your own old and new prefix. Like in the example below, where we replace\u00a0<em>wp_<\/em>\u00a0with\u00a0<em>david_<\/em>:<\/li>\n<\/ol>\n<pre data-i18n=\"32-ESCJCSsRdh\">update david_usermeta set meta_key = 'david_capabilities' where meta_key = 'wp_capabilities';\r\nupdate david_usermeta set meta_key = 'david_user_level' where meta_key = 'wp_user_level';\r\nupdate david_usermeta set meta_key = 'david_autosave_draft_ids' where meta_key = 'wp_autosave_draft_ids';\r\nupdate david_options set option_name = 'david_user_roles' where option_name = 'wp_user_roles';\r\n<\/pre>\n<ol start=\"4\">\n<li data-i18n=\"33-hirS5fDdUe\">Click on\u00a0<strong>Go<\/strong>\u00a0to run the commands and complete the change.<\/li>\n<\/ol>\n<p data-i18n=\"34-2QizoU6bv2\">You are done. The prefix of the WordPress tables has now been changed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-2259 aligncenter\" src=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/replace-preferences-database-300x203.png\" alt=\"\" width=\"593\" height=\"401\" srcset=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/replace-preferences-database-300x203.png 300w, https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/replace-preferences-database.png 716w\" sizes=\"(max-width: 593px) 100vw, 593px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Check out our cheap and reliable <a href=\"https:\/\/hoganhost.com.ng\">web hosting<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this guide, we explain how to change the database table prefix of your WordPress installation. The default database table [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2256,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[4,9],"tags":[],"class_list":["post-2255","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cpanel","category-wordpress"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Change the table prefix for WordPress - HoganHost blog<\/title>\n<meta name=\"description\" content=\"The default database table prefix for WordPress is &#039;wp_&#039;; however, we recommend changing it. The reason for this is that all your login\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Change the table prefix for WordPress - HoganHost blog\" \/>\n<meta property=\"og:description\" content=\"The default database table prefix for WordPress is &#039;wp_&#039;; however, we recommend changing it. The reason for this is that all your login\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/\" \/>\n<meta property=\"og:site_name\" content=\"HoganHost blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/HoganHost\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-24T12:28:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-12T12:12:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/Change-the-table-prefix-for-WordPress.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Abigal okon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@hoganhostng\" \/>\n<meta name=\"twitter:site\" content=\"@hoganhostng\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Abigal okon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/\"},\"author\":{\"name\":\"Abigal okon\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/person\/af16a18c6cc966b92a6cb13b500f3f0a\"},\"headline\":\"How to Change the table prefix for WordPress\",\"datePublished\":\"2024-06-24T12:28:12+00:00\",\"dateModified\":\"2024-08-12T12:12:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/\"},\"wordCount\":369,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/Change-the-table-prefix-for-WordPress.jpg\",\"articleSection\":[\"Cpanel\",\"wordpress\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/\",\"url\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/\",\"name\":\"How to Change the table prefix for WordPress - HoganHost blog\",\"isPartOf\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/Change-the-table-prefix-for-WordPress.jpg\",\"datePublished\":\"2024-06-24T12:28:12+00:00\",\"dateModified\":\"2024-08-12T12:12:30+00:00\",\"description\":\"The default database table prefix for WordPress is 'wp_'; however, we recommend changing it. The reason for this is that all your login\",\"breadcrumb\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/#primaryimage\",\"url\":\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/Change-the-table-prefix-for-WordPress.jpg\",\"contentUrl\":\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/Change-the-table-prefix-for-WordPress.jpg\",\"width\":1080,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/hoganhost.com.ng\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Change the table prefix for WordPress\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#website\",\"url\":\"https:\/\/hoganhost.com.ng\/blog\/\",\"name\":\"HoganHost blog\",\"description\":\"Keeping you connected to everything from HoganHost\",\"publisher\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoganhost.com.ng\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#organization\",\"name\":\"HoganHost\",\"url\":\"https:\/\/hoganhost.com.ng\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2022\/09\/hogan-host.png\",\"contentUrl\":\"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2022\/09\/hogan-host.png\",\"width\":466,\"height\":387,\"caption\":\"HoganHost\"},\"image\":{\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/HoganHost\",\"https:\/\/x.com\/hoganhostng\",\"https:\/\/instagram.com\/officialhoganhost\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/person\/af16a18c6cc966b92a6cb13b500f3f0a\",\"name\":\"Abigal okon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ef2272070d016c06ee69b30adce7c4e4b4faaa5c899c4b9224a5b1a43b1fb8d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ef2272070d016c06ee69b30adce7c4e4b4faaa5c899c4b9224a5b1a43b1fb8d0?s=96&d=mm&r=g\",\"caption\":\"Abigal okon\"},\"sameAs\":[\"https:\/\/hoganhost.com.ng\/blog\"],\"url\":\"https:\/\/hoganhost.com.ng\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Change the table prefix for WordPress - HoganHost blog","description":"The default database table prefix for WordPress is 'wp_'; however, we recommend changing it. The reason for this is that all your login","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/","og_locale":"en_US","og_type":"article","og_title":"How to Change the table prefix for WordPress - HoganHost blog","og_description":"The default database table prefix for WordPress is 'wp_'; however, we recommend changing it. The reason for this is that all your login","og_url":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/","og_site_name":"HoganHost blog","article_publisher":"https:\/\/facebook.com\/HoganHost","article_published_time":"2024-06-24T12:28:12+00:00","article_modified_time":"2024-08-12T12:12:30+00:00","og_image":[{"width":1080,"height":1080,"url":"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/Change-the-table-prefix-for-WordPress.jpg","type":"image\/jpeg"}],"author":"Abigal okon","twitter_card":"summary_large_image","twitter_creator":"@hoganhostng","twitter_site":"@hoganhostng","twitter_misc":{"Written by":"Abigal okon","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/#article","isPartOf":{"@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/"},"author":{"name":"Abigal okon","@id":"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/person\/af16a18c6cc966b92a6cb13b500f3f0a"},"headline":"How to Change the table prefix for WordPress","datePublished":"2024-06-24T12:28:12+00:00","dateModified":"2024-08-12T12:12:30+00:00","mainEntityOfPage":{"@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/"},"wordCount":369,"commentCount":0,"publisher":{"@id":"https:\/\/hoganhost.com.ng\/blog\/#organization"},"image":{"@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/#primaryimage"},"thumbnailUrl":"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/Change-the-table-prefix-for-WordPress.jpg","articleSection":["Cpanel","wordpress"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/","url":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/","name":"How to Change the table prefix for WordPress - HoganHost blog","isPartOf":{"@id":"https:\/\/hoganhost.com.ng\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/#primaryimage"},"image":{"@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/#primaryimage"},"thumbnailUrl":"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/Change-the-table-prefix-for-WordPress.jpg","datePublished":"2024-06-24T12:28:12+00:00","dateModified":"2024-08-12T12:12:30+00:00","description":"The default database table prefix for WordPress is 'wp_'; however, we recommend changing it. The reason for this is that all your login","breadcrumb":{"@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/#primaryimage","url":"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/Change-the-table-prefix-for-WordPress.jpg","contentUrl":"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2024\/06\/Change-the-table-prefix-for-WordPress.jpg","width":1080,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/hoganhost.com.ng\/blog\/wordpress\/how-to-change-the-table-prefix-for-wordpress\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/hoganhost.com.ng\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Change the table prefix for WordPress"}]},{"@type":"WebSite","@id":"https:\/\/hoganhost.com.ng\/blog\/#website","url":"https:\/\/hoganhost.com.ng\/blog\/","name":"HoganHost blog","description":"Keeping you connected to everything from HoganHost","publisher":{"@id":"https:\/\/hoganhost.com.ng\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoganhost.com.ng\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/hoganhost.com.ng\/blog\/#organization","name":"HoganHost","url":"https:\/\/hoganhost.com.ng\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2022\/09\/hogan-host.png","contentUrl":"https:\/\/hoganhost.com.ng\/blog\/wp-content\/uploads\/2022\/09\/hogan-host.png","width":466,"height":387,"caption":"HoganHost"},"image":{"@id":"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/HoganHost","https:\/\/x.com\/hoganhostng","https:\/\/instagram.com\/officialhoganhost"]},{"@type":"Person","@id":"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/person\/af16a18c6cc966b92a6cb13b500f3f0a","name":"Abigal okon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hoganhost.com.ng\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ef2272070d016c06ee69b30adce7c4e4b4faaa5c899c4b9224a5b1a43b1fb8d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ef2272070d016c06ee69b30adce7c4e4b4faaa5c899c4b9224a5b1a43b1fb8d0?s=96&d=mm&r=g","caption":"Abigal okon"},"sameAs":["https:\/\/hoganhost.com.ng\/blog"],"url":"https:\/\/hoganhost.com.ng\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/posts\/2255","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/comments?post=2255"}],"version-history":[{"count":2,"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/posts\/2255\/revisions"}],"predecessor-version":[{"id":2381,"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/posts\/2255\/revisions\/2381"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/media\/2256"}],"wp:attachment":[{"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/media?parent=2255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/categories?post=2255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoganhost.com.ng\/blog\/wp-json\/wp\/v2\/tags?post=2255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}