Changing Database Prefix For More Secure Mode

Where Is This Blog Yesterday?

This blog has gone to take a little vacation a while ago in Manila. :p

Well, actually I was updating my database. Changing the database structure so that it will be more secure and hardly to attack using SQL injection.

I’m editing the .sql file using my Dreamweaver CS3.  Yeah, Dreamweaver can edit .sql files too.  Try it if you don’t believe me.  I just use the find function. ( ctrl + f ) and choose to replace all the match case.  Very convenient.

Still do not know what I’m talking about?
Well, this website is hacked once.  You can see/read my disappointment here at What a Good Luck!
So, as a future precaution, I change the table name wp_ to something_

 

More Secure Database Tables Prefix

This is practically can protect your blog from SQL injection attack which can delete your database, if it execute the sql queries of drop tables wp_ kind like that.  So, the precaution, is change it to something else…  Maybe your favorite celebrity name.  Like shaina_ :lol:

But Seriously, it will make you got a heart attack if you tend to get things easy.

I’ll make a tutorials on this later on.  How to make sure you won’t miss it?  Stay subscribe to my feed, via email is the most convenient way.  Do not know what is feed?  You can get to know with her at What is Feed and RSS?

 

 

 

What a Good Host

I export the database and edit it, but when I try to import it back into the dropped tables, I can’t.  It said it have reach its maximum execution period.
But, fortunately the Namsahaz support team help me to import it and here it is my blog gone live again.

And then, I received an email from them again telling me to insert some code into the .htacces because my permalinks is broken.  Then I visits my the homepage and try to click any post link.  Well, it returns an error 404, not found.  Nice support! ;-)

Help me spread this article if you like them.
  • Digg
  • StumbleUpon
  • del.icio.us
  • TwitThis
  • Technorati
  • Yahoo! Buzz
  • Google Bookmarks
  • Live
  • Facebook
  • E-mail this story to a friend!
  • Print this article!
Peoples who read the post above also read the posts below.
Weird. There's no post related to this post.

8 Responses to “Changing Database Prefix For More Secure Mode”

  1. syuxx says:

    owh, never knew about this before.
    yeah, i think i should do same thing too.
    change the prefix table.

    is there any software that can do this task automatically?
    humm..

    • @syuxx, there’s a wordpress plugins called WP Security Scan. But I have problems when using it. That’s why I do it manually. Unless you know the sql queries to alter the wp_ and change it to syuxx_ instead. But I can’t find it. Tell me if you do find the easier way. Many of my blog still use wp_. :?

  2. cencurut says:

    Well, from my colleague I found out that Namsahaz service is quite extraordinaire. I’m sure if I host my website there, they could give me the same support.

  3. tunepal says:

    hoho..i wonder about that. i think your blog just gone.its weid. :|

  4. reddebt says:

    something like this can happen? ehm, looks we need to take care about our database i guess.

Leave a Reply

:o) :-D :-( ;-) :-P =-O 8-) :-/ O:-) :-! >:o C:-) :-(|) O-) :@ :-[ (B) (^) (P) (@) (O) (D) :-S ;-( (C) (&) :-$ (E) (~) :-* (I) (L) (8) (T) (G) (F) (*) (N) (Y) (U) (W)
(^.-)
NAMSAHAZ Webhosting - Affordable webhosting for everyone!