One of the way to increase your wordpress blog security is by changing your wordpress database prefix from the default prefix “wp_” to “something_”. Here I’d like to share how I do it for all my wordpress blog everytime I start a new blog using selfhosted wordpress:
1. Backup your WordPress database to an *.sql file.
- From your hosting cpanel, use the phpMyAdmin facility, and select your database.
- Go to Export Tab. Choose SQL Option. At the Structure part, tick boxes: Structure, Add DROP TABLE/VIEW/PROCEDURE/FUNCTION, Add IF NOT EXISTS, Add AUTO_INCREMENT value, Enclose table and field names with backquotes. At the Data part, tick boxes: Data, Complete Inserts, Use hexadecimal for BLOB. Set Export Type: INSERT.
- Tick option Save as File. Click Go. And save the *.sql file to your hardisk.
2. Copy the backup file as your backup before changing anything. Then open the *.sql file using text editor (Notepad). Find and Replace the “wp_” text to “something_” (eg. “xz_”).
3. Now DROP all tables in your wordpress database. Please do NOT drop the Database though
- Go to the Structure Tab. Check All Table, and select option DROP.
4. Import backup file *.sql that have been edited to your WordPress Database.
- Go to Import Tab, then enter the location of the *.sql file on your hardisk. Click Go.
5. Now all table prefix in your wordpress database have been replaced to the “something_”. The last step is making it recognized by changing your config.php file.
- From your hosting cPanel, go to File Manager and edit the wp-config.php file that is located on the root directory of your domain.
- Change the $table_prefix = ‘wp_’ text to $table_prefix = ‘something_’
6. When you do the above process, all your plugin is automatically deactivated. You should manually activate it from your wordpress panel.
That’s it! The process to change your prefix wordpress table of your blog is done. Now your wordpress security is increased.
No related posts.















25 Comments
Thats Too nice, when it comes in india hope it can make a Rocking place for youngster.. hope that come true.
hey id like to talk with you about your blog. please email me – thanks.
I’m just getting started with blogging and have learned some nice techniques from your site. Thanks!
I’ve been lurking for a while and wanted you to know I enjoy reading your articles.
As a Newbie, I am always searching online for articles that can help me. Thank you
As a Newbie, I am always searching online for articles that can help me. Thank you!
Blogroll links aint that great
but i am not the admin
Just Telling
Hello, i guess this is as good of a place as any to post and let you know. I went to subscribe to your RSS feed, and when i clicked it i got an error that said “Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING” followed by other gibberish that scrolled off the screen. I had to force the page to stop loading because it locked up my browser. Cheers.
Весёлые посты у вас выходят, но они выходят очень не часто
Hello just figured i would let you know i had a problem with your blog coming up blank also. Must be chimpanzees in the page.
amateur scientist canadian young woman free
Nothing fails like success.
Hello, Very nice article thanks.
wzyHyz asian models pictures
CnIXwz girl models free
wzIzum asian models pictures
byURwz girl models free
wlEYXB asian models pictures
iufRwl girl models free
wkHZYk asian models pictures
eEnAwk girl models free
wyxfIk watch filipina babes
SDEwwy ladies mother fucking
wyGSYz watch filipina babes
fVubwy ladies mother fucking
wyCzyC watch filipina babes
EiOrwy ladies mother fucking
RWil интересные новости
LcoB мировая економика
OgTY интересные новости
Zzef мировая економика
wrRWeC watch filipina babes
GXyCwr ladies mother fucking
get free dofollow backlinks: mysiteevaluate.com/backlinks-blog/
internet marketing is a fast and efficient way of promoting your products and services online:;”
One Trackback
[...] How to Change your WordPress Database Prefix Internet Marketing Posted by root 50 minutes ago (http://e-marketingjournal.com) Now all table prefix in your wordpress database have been replaced to the something i 39 ve been lurking for a while and wanted you to know i enjoy reading your articles post a comment your email is never shared required fields are marked internet marketi Discuss | Bury | News | How to Change your WordPress Database Prefix Internet Marketing [...]