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
Widget options are stored in the
options table under
'sidebars_widgets' as a serialized array. See this post for a longer explanation.
Changing the field per PHPMyAdmin is not recommended, use PHP,
update_option() instead, WordPress will take care for correct serialization then.
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.