changing WP table prefix

Hi, I want to change the standard wp_ prefix to harden WP, but when I do so in the database and change $table_prefix = ‘wp_’; in wp-config, my admin user looses admin rights and I can’t access wp-admin any more. What can I do?
Thanks
Tom

Thank you for reporting this important issue.

I’d strongly recommend not changing the prefix on a live site. You’ll need to change the prefix both in the wp-config.php file, but also for all of the tables that are created in your mySQL database, and all of the meta values that have been created based on the prefix you had set up. In my opinion, it would be easier to recreate the site over again with the new prefix than change the prefix after it’s all set up.

That being said, if that’s not an option, you’ll need to change the prefix for all of the tables in your mySQL database via PHPmyAdmin (your server provider should give you info on getting this access) for starters. You will need to redo (at least some) of your settings, and probably change the names in some of your options tables from wp_ to your new prefix. That’s probably what’s causing you your issue right now.