How to edit a database with PHPMyAdmin?
 

Is it possible to change the data stored in a database-table with PHPMyAdmin?

If so, how?

Yes. What are you trying to edit? Rename table fields? Change field properties? You can do just about anything in PHPMyAdmin.

i moved my db into another and changed the db-prefix, and i changed db prefix in wp-config.php, and now i'm getting:

"You do not have sufficient permissions to access this page."


Some guy said: "Be sure to also check in the options table. There should be cell that says table_prefix_user_roles underneath the column option_name which uses the table prefix."

So I want to change it, but I don't know how to do it..

bump***

123

what i do is download the whole database and open it with wordpad and edit it from there

select all tables and click "DROP"

then u can proceed to edit it.

Just read help :idea:

Didn't know I could do that, thanks! I got it working now.


Will post the solution here so I can find it next time I got problems with the same thing. ;-)

You do not have sufficient permissions to access this page.

Even when attempting to login as admin. The cause? Simple, some of the Wordpress options are actually saved using the Wordpress prefix. You will now need to open up your favourite MySQL admin tool and modify the following:

In table ${NEW_WP_PREFIX}_options:

* Option ${OLD_WP_PREFIX}_user_roles

In table ${NEW_WP_PREFIX}_usermeta:

* Option ${OLD_WP_PREFIX}_capabilities
* Option ${OLD_WP_PREFIX}_user_level
* Option ${OLD_WP_PREFIX}_autosave_draft_ids


Source:
http://www.lildude.co.uk/2007/05/how...-table-prefix/

spot on, it's very important to drop all before you start editing

Not quite sure why this would be funny.

Do not listen to this.