Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I have the cPanel access to a website but no wordpress login info. So I wants to change a widget content in the website.

How can I change it through phpmyadmin. Where are that widgets sidebar data actually stored? Is it inside wp-options table?

share|improve this question

2 Answers 2

Widget options are stored in the options table under 'sidebars_widgets' as a serialized array. See this post for a longer explanation.

enter image description here

Changing the field per PHPMyAdmin is not recommended, use PHP, get_option() and update_option() instead, WordPress will take care for correct serialization then.

share|improve this answer
    
Impressive! I don't know how to update the values using that function. Anyway I solved my problem by creating another user through phpmyadmin. Thank You. –  Libin Jul 11 '12 at 6:51
up vote 0 down vote accepted

I came to know that WordPress is storing the widget contents as serialized array!

So instead of directly editing via phpmyadmin, I had created a new admin user through phpmyadmin using this awesome tutorial: How to Add an Admin User to the Wordpress Database

Then I logged in to the dashboard and made changes to the widgets! Hope this will help someone else.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.