How to edit a database with PHPMyAdmin? - GoFuckYourself.com

Emil · 12-01-2007, 08:53 AM

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

If so, how?

FeedAM · 12-01-2007, 08:55 AM

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

Emil · 12-01-2007, 09:04 AM

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..

Emil · 12-01-2007, 10:18 AM

bump***

123

Boobs · 12-01-2007, 10:19 AM

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

hateman · 12-01-2007, 10:38 AM

select all tables and click "DROP"

then u can proceed to edit it.

wizzart · 12-01-2007, 10:43 AM

Just read help :idea:

Emil · 12-01-2007, 11:48 AM

Quote:

Originally Posted by Boobs

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

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/

polle54 · 12-01-2007, 12:52 PM

Quote:

Originally Posted by hateman

select all tables and click "DROP"

then u can proceed to edit it.

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

The Fist · 12-01-2007, 12:54 PM

Not quite sure why this would be funny.

Do not listen to this.

Quote:

Originally Posted by hateman

select all tables and click "DROP"

then u can proceed to edit it.

12-01-2007, 08:53 AM	#1
Emil Confirmed User Join Date: Feb 2007 Location: Sweden Posts: 5,650	How to edit a database with PHPMyAdmin? Is it possible to change the data stored in a database-table with PHPMyAdmin? If so, how? __________________ Free 🅑🅘🅣🅒🅞🅘🅝🅢 Every Hour (Yes, really. Free ₿itCoins.) (Signup with ONLY your Email and Password. You can also refer people and get even more.)

12-01-2007, 08:55 AM	#2
FeedAM Registered User Join Date: Apr 2007 Location: FeedAM.com Posts: 64	Yes. What are you trying to edit? Rename table fields? Change field properties? You can do just about anything in PHPMyAdmin. __________________ Swingers Lifestyle Personals

12-01-2007, 09:04 AM	#3
Emil Confirmed User Join Date: Feb 2007 Location: Sweden Posts: 5,650	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.. __________________ Free 🅑🅘🅣🅒🅞🅘🅝🅢 Every Hour (Yes, really. Free ₿itCoins.) (Signup with ONLY your Email and Password. You can also refer people and get even more.)

12-01-2007, 10:18 AM	#4
Emil Confirmed User Join Date: Feb 2007 Location: Sweden Posts: 5,650	bump* 123 __________________ Free 🅑🅘🅣🅒🅞🅘🅝🅢 Every Hour (Yes, really. Free ₿itCoins.) (Signup with ONLY** your Email and Password. You can also refer people and get even more.)

12-01-2007, 10:19 AM	#5
Boobs Confirmed User Join Date: Aug 2006 Posts: 7,875	what i do is download the whole database and open it with wordpad and edit it from there __________________ Join the fucking best in big tit sponsors!!!

12-01-2007, 10:38 AM	#6
hateman So Fucking Banned Join Date: Jul 2003 Posts: 1,623	select all tables and click "DROP" then u can proceed to edit it.

12-01-2007, 10:43 AM	#7
wizzart scriptmaster Industry Role: Join Date: May 2006 Location: Serbia Posts: 5,237	Just read help :idea: