Change prefix of database tables in WordPress
Here the other day I was adding some security settings on a WordPress installation. One of them involving changing the prefix of WordPress’ database tables. It’s pretty straight forward, but you’ve got to remember changing some values inside some of the tables. I found quite a few articles on this subject, but none that informed me that I had to do a certain change on ALL users.
The Rambling Thoughts Blog has an easy to follow article on how to change the database prefix of your wordpress installation. What they forget to mention is that the changes you have to do in the usermeta table has to be done on ALL user accounts. If you don’t do it you might end up getting this error message when trying to log in:
You do not have sufficient permissions to access this page.
If you’re interested in securing your blog, head over to Lorelle and read the article Firewalling and Hack Proofing your WordPress blog. It contains links to other interesting and very helpful articles on the subject.