WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

So I messed up my blog (QBobble). I had an SQL backup, fortunately, so I reinstalled Wordpress, and imported my SQL database.

Unfortunately, it password protected all of my posts. I know that I can manually unpassword protect them by going to Posts < Edit and edit the visibility to "public", but I don't want to do that to all of my posts, I want to do it to all of them at once. How can I do that? Someone said that you can do it in Bulk Actions > Edit, BUT changing the status to "public" in bulk actions doesn't work. Any ideas?

It also got rid of the excerpts for each post. They now just read NULL. Is there a way that I can get it to add those back automatically?

I'm running 3.3.1, by the way.

Thanks all!

share|improve this question

migrated from stackoverflow.com Apr 9 '12 at 6:31

This question came from our site for professional and enthusiast programmers.

This site is for programming help, not "how to fix my blog". Sorry, try WP's own forums. – Marc B Apr 7 '12 at 21:14
Hmm. Okay. Will do, thanks! – Timothy Apr 7 '12 at 21:16

You can do that by running this SQL query:

UPDATE `wp_posts` SET `post_password` = '' WHERE `post_type` = 'post';

Change wp_posts to match your own posts table name.

share|improve this answer

Your Answer


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