List of WP 2.3-2.3.x Tables to be Renamed
Before to much talk, i wish to inform that i’ve ever written about this something similiar matter, you can read it at www.aufklarun..refix.mspx, and as for this article is continuation of that. Note that this’s NOT a new tech or method, but this is something like a summary of a bunch articles out there.
Well, like we’ve known before, Blogsecurity.net team has mentioned on their security paper about a list of default wordpress prefix table which must be changed, also some easy steps to change it. But that case only for wordpress version 2.2 to 2.2.something. Ask why? ’cause wordpress 2.3 and up doesn’t using some tables that has mentioned over there, like wp_categories, wp_link2cat, and wp_post2cat table. This thing will make someone else is as slow as newbie becoming confused, and possibly does mistake 
.
So, my goal in writing this is to mentioning a list of wordpress 2.3 and up tables to be be renamed by wp folks is currently using wordpress 2.3 and up 
, and what’s more to discuss about something alternative solution for wp folks which is possible have ever experienced errors after changing their wp prefix tables.
Okay, below the list of the wordpress version 2.2 to 2.2.something primary tables which has mentioned by Blogsecurity.net team on their wordpress security whitepaper:
- wp_categories
- wp_comments
- wp_link2cat
- wp_links
- wp_options
- wp_post2cat
- wp_postmeta
- wp_posts
- wp_usermeta
- wp_users
…and the following lists of WP 2.3/2.3.1 tables to be renamed:
- wp_comments
- wp_links
- wp_options
- wp_postmeta
- wp_posts
- wp_term_relationships
- wp_term_taxonomy
- wp_terms
- wp_usermeta
- wp_users
Blogsecurity.net team also has mentioned on their paper that to rename all these tables to match the new prefix, we need to run a SQL Command through phpMyAdmin, or something similiar. A wordpress folks, Sherif Elsisi, has explained steps is done it, you can check on his blog here: www.tdot-blog..-wordpress. But Sheriff totally like Blogsecurity.net team, just described the wordpress primary tables that isn’t in version 2.3 and up 
.
So now, open your phpMyAdmin, then on your wordpress db, click the SQL menu item. Now, paste the following SQL queries on the SQL window:
Take a backup of your wp database before doing this !
- RENAME TABLE wp_comments TO new_comments
- RENAME TABLE wp_links TO new_links
- RENAME TABLE wp_options TO new_options
- RENAME TABLE wp_postmeta TO new_postmeta
- RENAME TABLE wp_posts TO new_posts
- RENAME TABLE wp_term_relationships TO new_term_relationships
- RENAME TABLE wp_term_taxonomy TO new_term_taxonomy
- RENAME TABLE wp_terms TO new_terms
- RENAME TABLE wp_usermeta TO new_usermeta
- RENAME TABLE wp_users TO new_users
Don’t forget to change the “new” word above to something like “2×9p02yMQJy”. Afterwards, follow all Sherif Elsisi’s instructions on his blog to rename some tables on new_options (formaly wp_options), and on new_usermeta (formally wp_usermeta).
Now, this’s the time to test your wordpress blog, usually everything will be oke. But, in my experience, i got an error something look like: WordPress database error: [Table ‘xxxx.blah_mt_tags’ doesn’t exist] SELECT mt_tag, mt_description FROM blah_mt_tags. So, it caused by some plugins i’m currently using, like My Tags.
But wait… if you get an error even when attempting to login as admin, like: You do not have sufficient permissions to access this page, it because you has not renamed the wp__user_roles to new__user_roles on your new “new_options” prefix.
I wish this simple writing can be be useful and assists wp folks which still confusing to change their prefix tables 
.
CREDIT:
01. Blogsecurity.net paper » www.blogsecur..hitepaper/
02. Sherif Elsisi for written » www.tdot-blog..-wordpress
From Jena
Using
Thanks for your work, with the next whitepaper we’re going to mention as well the latest changes within WordPress. As well as a new Version of the Prefix Changer is on it’s way. Anyway I’m currently quite busy so I don’t find too much time for it, which is sad.
From Jakarta
Using
Philipp Heinze, thanks a bunch for commenting, also visiting this blog
. And, yeah… i wish you have time to immediately completing the newest version of the Prefix Changer Table, ’cause not a little bit of WP folks have difficulty changing their WP prefix manually 
!
From Jakarta
Using
wew si pembuat plugin sama papernya ikut komen jg, cool boss
The latest Hendry’s blog issue is Perintah Dasar di GNU/Linux
From Bandung
Using
bang, abis gwa paste list tabel WP 2.3.1 di atas ke kolom sql query, trus klik tombol "GO", kok gw malah dapet error access denied sama unknown command? knp bisa bgt? tolongin dong
From Jakarta
Using
mac,
copy kemudian paste itu koman satu satu, lalu klik GO, ulangi ampe selesai
From Chicago
Using
excellent job, thanks so much for the assist.
The latest guice’s blog issue is Vista “kill switch†killed — No surprise…WGA’s real problem
From Curitiba
Using
Thanks a million for your instructions, once I was prepared i changed my WP table prefix in 3 minutes start to finish.
From Bandung
Using
makacih bang, sekarang udah sukses and selamat sampe ditujuan
From Steinsel
Using
Nice work mate, i’ve tested it on my community blog, and work fine, thanks to you !
From Alkmaar
Using
I discovered this place when I was searching for prefix table how to on Google, and your guidance worked like a charm, thanks for writing such a useful article.
From Buenos Aires
Using
Thanks to the author for listing the wp 2.3.*’s tables, also explaining the working steps.
The latest Feve’s blog issue is Juegos Flash De “Escapeâ€
From Madrid
Using
what the hell?, it worked! you are awesome man
cheers!
Periko’s last blog post..Esto es tocar las narices a un perro
From Bangkok
Using
Some days ago, i started getting the error after logging in to my admin page:
"You do not have sufficient permissions to access this page"
After searching a couple of hours i get this site, and now, my Wordpress blog keng.com would not be up and running right now without you. Thank you so much this is an awesome!
From Dallas
Using
good work, i’m not use it yet, but just in case i need it in near future
webringet’s last blog post..21st Century… advantages or disadvantages
From Melbourne
Using
Hi folks, just to inform i’ve written a similar post on my site long time ago
, see at http://www.bh..le-prefix/
Bhatt’s last blog post..Australian TV Network News & Upcoming TV Show Highlights
From Medan
Using
oiiii bang, ini nih yang aku cari-cari buat ngedetek nama kota. aku baca di forum id-wp katanya mau ngerilis plugin buat deteksi nama kota pemberi komentar, kapan pluginnya dirilis, sudah nggak sabar nih, aku tunggu
From Medan
Using
bah, aku ketahuan dari kota medan, good good, sudah nggak sabar nih