{"id":3960,"date":"2020-02-10T15:00:41","date_gmt":"2020-02-10T14:00:41","guid":{"rendered":"https:\/\/qodeinteractive.com\/magazine\/?p=3960"},"modified":"2020-08-24T23:45:49","modified_gmt":"2020-08-24T21:45:49","slug":"how-to-change-wordpress-database-prefix","status":"publish","type":"post","link":"https:\/\/qodeinteractive.com\/magazine\/how-to-change-wordpress-database-prefix\/","title":{"rendered":"How to Change the WordPress Database Prefix to Improve Security"},"content":{"rendered":"

[vc_row][vc_column][vc_column_text]WordPress is a system of files that functions around a centralized database. This database is used to store all of the pertinent information, options, and settings needed for a WordPress website to function. For this very reason, it is a common target for malicious attacks and its security should be one of the priorities for every WordPress developer. Among a long list of security features that can be utilized within WordPress itself, many of them can be added to the wp-config.php file. One of those settings is the table_prefix option that we will be covering in this article.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]Namely, WordPress databases have a default prefix of \u201cwp_<\/strong>\u201d which exposes them to attacks that can exploit the use of such default settings and use them to gather valuable user information. To protect against this form of attack, you simply need to change the table prefix to something other than \u201cwp_\u201d that others will not be able to predict.[\/vc_column_text][vc_empty_space height=”68px”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n

Changing the WordPress Database Prefix<\/h2>\n

[\/vc_column_text][vc_column_text]This process involves three main steps, however, before attempting these it is always a good idea to back-up the database<\/a> so that you can simply restore it if necessary.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]For the first part of changing the prefix, you will utilize the wp-config.php file and change the default prefix for all tables. In order to do so, you will have to access your website via FTP and edit the wp-config.php file<\/a> in the root directory. Right-click<\/strong> this file and select View\/Edit<\/strong> from the dropdown list.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]Once the file opens in a new window, within it you will need to modify the following line:[\/vc_column_text][vc_empty_space height=”30px”][vc_column_text]$table_prefix = 'wp_';<\/code>[\/vc_column_text][vc_empty_space height=”34px”][vc_column_text]into[\/vc_column_text][vc_empty_space height=”30px”][vc_column_text]$table_prefix = \u2018wp_new_';<\/code>[\/vc_column_text][vc_empty_space height=”54px”]

\n
\n \"Modify <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]We have set the default database prefix to \u201cwp_new_ \u201c. You are free to change this to whatever you\u2019d like. However, keep in mind that you can only use numbers, letters, and underscores to construct the prefix. The beginning must still consist of \u201cwp_\u201d and you can input your part of the prefix after it. Also, it is good practice that you end the new prefix with an underscore \u201c_\u201c so the table names will be easily discernible.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]After changing the line you need to save your changes. The following pop-up will appear:[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Save <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]Simply click Yes<\/strong> and the editing of the file is done.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]Now if you try to access your website once again you will be prompted to start the database set up once again, since the new setting for the prefixes has to be applied. If you do this, your entire database will be overridden and you will lose everything stored within it<\/strong>. This means that if you have already started work on your website, everything you\u2019ve done up to now will be erased.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Start <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]In order to avoid this, you will need to change the names of all the existing tables (and some occurrences of the prefix inside the tables) from within phpMyAdmin. [\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]If you\u2019re working on a live server, to log in to your installation\u2019s phpMyAdmin you will either have to contact your hosting provider or access your cPanel<\/strong> and navigate to phpMyAdmin<\/strong>.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"phpMyAdmin\" <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]If you’re working on a local server, you can go to the designated dashboard for it. For example, if you\u2019re using XAMPP, go to the control panel and press the admin button for MySQL.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Press <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]Once you have done either of these you will be redirected to the phpMyAdmin dashboard page on your default browser.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"phpMyAdmin <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]On the left-hand side of the page, you will see a list of your databases. Choose the one you would like to edit by simply clicking on it<\/strong>. If you have been working on a premium WordPress theme<\/a>, chances are the next screen will have quite a lot of tables shown:[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"List <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]It would be tedious work to change them all one by one. Luckily, when you scroll down to the bottom of this page you will see a check all option<\/strong>. Click on it and from the dropdown<\/strong> next to it choose the option Replace table prefix<\/strong>.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Replace <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]A small window will pop up with two text boxes. One is for inputting the old table prefix, which in our case is \u201cwp_\u201d, and the second one is to input the new prefix we previously defined in the wp-config.php file, which in our case is \u201cwp_new_\u201d.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Execute <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]By pressing the Continue button<\/strong> you will execute the change and you will be able to move on to the last step.[\/vc_column_text][vc_empty_space height=”81px”][vc_separator color=”custom” accent_color=”#f0f0f0″][vc_empty_space height=”50px”][vc_widget_sidebar sidebar_id=”top-picks-banner”][vc_empty_space height=”28px”][vc_separator color=”custom” accent_color=”#f0f0f0″][vc_empty_space height=”70px”][vc_column_text]Since the database tables themselves are connected, there are certain entries within some of them that point to one of the other tables. Within these, the old prefix is still used. If you leave it like that, errors will occur and you once again may end up having to restore your backed-up database to keep from losing all the progress you made with building your website.[\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]In order to avoid this you should navigate to the SQL tab<\/strong> near the top of the browser window and add the following code<\/strong> into the text field that appears:[\/vc_column_text][vc_empty_space height=”30px”][vc_column_text]SELECT * FROM 'wp_new_options' WHERE 'option_name' LIKE 'wp\\\\_%'<\/code>[\/vc_column_text][vc_empty_space height=”34px”][vc_column_text]Once you have input this code you should modify the \u201cwp_new_options\u201d part<\/strong> to reflect your new prefix (so it should contain your new prefix followed by the word \u201coptions\u201d). This will access the options table and retrieve from it any option_name attribute which starts with \u201cwp_\u201d. In essence, it will retrieve all of this attribute\u2019s values that start with the old prefix.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"SQL\" <\/div>\n<\/div>[vc_empty_space height=”60px”]
\n
\n \"Modify <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]Once you press the Go button<\/strong> a list of all of the entries to this table will be shown along with a notice of how many have been found.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"List <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]Now that we have located all the instances of the old prefix within the options table you will need to change them one by one. To do so, you can simply double click the option_name field<\/strong> and add your new prefix instead of the old one<\/strong>. Once you click outside of the text box again the information will be saved and a notification will pop up.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Notification\" <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]You will also need to do this for the \u201cusermeta\u201d table. [\/vc_column_text][vc_empty_space height=”28px”][vc_column_text]As in the step above, navigate to the SQL tab once again and paste the following code into the large text box.[\/vc_column_text][vc_empty_space height=”30px”][vc_column_text]SELECT * FROM \u2018wp_new_usermeta\u2019 WHERE \u2018meta_key\u2019 LIKE \u2018wp\\\\_%\u2019<\/code>[\/vc_column_text][vc_empty_space height=”34px”][vc_column_text]Changing the \u201cwp_new_\u201d prefix into the one you chose. After pressing the Go button<\/strong>, you should see a list of instances of the old prefix within the \u201cusermeta\u201d table.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"List <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]This time you will need to manually amend the \u201cmeta_key\u201d column values to include the new prefix instead of the old one.[\/vc_column_text][vc_empty_space height=”50px”]
\n
\n \"Manually <\/div>\n<\/div>[vc_empty_space height=”38px”][vc_column_text]Once you have done this, the process of changing the table prefix is complete and you will be able to navigate back to your website without any issue.[\/vc_column_text][vc_empty_space height=”68px”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n

Final Thoughts<\/h2>\n

[\/vc_column_text][vc_column_text]This concludes our tutorial on changing the default WordPress database prefix. By following these steps, you can create some peace of mind for yourself and ensure that your database and website are that much safer from any potential cyber attacks.[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

Learn how to change the WordPress database prefix to improve security and protect your WordPress site from cyberattacks.<\/p>\n","protected":false},"author":278,"featured_media":8056,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[49,34,50,13],"class_list":["post-3960","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-database","tag-security","tag-sql","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/posts\/3960","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/users\/278"}],"replies":[{"embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/comments?post=3960"}],"version-history":[{"count":0,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/posts\/3960\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/media\/8056"}],"wp:attachment":[{"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/media?parent=3960"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/categories?post=3960"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qodeinteractive.com\/magazine\/wp-json\/wp\/v2\/tags?post=3960"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}