Posted 5 years ago #
I would like to change the table prefix on my wordpress database, but I'm having problems. Here's what I did:
1. Change the prefix of the tables in the mysql database
2. Update the config file.
When viewing the site, all looks fine and seems well. However, when logging in as admin to the control panel, I get the following error:
You do not have sufficient permissions to access this page.
Switching the table prefix back fixes this error. How can I correct this problem?
Posted 5 years ago #
To do this change right you have to follow the instructions for moving WP, for 2.1 that's generally:
1. Make a backup from whitin WP (not wint phpMyAdmin).
2. Install new WP with the exact same version using the new tables.
3. Get it up and running.
4. Add your theme and plugins.
5. Import your backup.
Maybe try this (after backing up)?
Posted 5 years ago #
I wanted to do the same, I was going to give up when I found the solution. Read my post about how to properly change the table prefix for WordPress.
This topic has been closed to new replies.
