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?
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It only takes a minute to sign up.
Sign up to join this communityWidget 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, get_option()
and 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.