Title: making private posts public again…
Last modified: August 18, 2016

---

# making private posts public again…

 *  [daveo123](https://wordpress.org/support/users/daveo123/)
 * (@daveo123)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/making-private-posts-public-again/)
 * Tried a plug in I thought would shut down comments for older posts, turns out
   it shut down the older posts themselves by making them private. Any way to batch
   undo this? In other words batch “public” all of my posts? Even a mySQL command??
 * Thanks,
    Dave…

Viewing 5 replies - 1 through 5 (of 5 total)

 *  [theboywonder](https://wordpress.org/support/users/theboywonder/)
 * (@theboywonder)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/making-private-posts-public-again/#post-153836)
 * Hmmm, this should work (assuming WP 1.5):
 * UPDATE ‘wp_posts’ SET ‘post_password’ = ” WHERE ‘post_password’ = ‘XYZ’;
 * Replacing XYZ with the password you have used for your entries.
 * Tried and tested on mine 🙂
 *  Thread Starter [daveo123](https://wordpress.org/support/users/daveo123/)
 * (@daveo123)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/making-private-posts-public-again/#post-153914)
 * Thanks, but it’s not a password problem. It’s that 8 months of posts are marked
   as “private” and I need to change that to public. There was no password, I just
   need to undo what I did in a batch. I can see the posts no problem. They just
   aren’t public.
 *  [Kafkaesqui](https://wordpress.org/support/users/kafkaesqui/)
 * (@kafkaesqui)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/making-private-posts-public-again/#post-153917)
 * Then a slight mod to tbw’s query:
 * `UPDATE wp_posts SET post_status = 'publish' WHERE post_status = 'private';`
 *  [theboywonder](https://wordpress.org/support/users/theboywonder/)
 * (@theboywonder)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/making-private-posts-public-again/#post-153945)
 * Oops, misread, but as Kafkaesqui said, thanks 🙂
 *  Thread Starter [daveo123](https://wordpress.org/support/users/daveo123/)
 * (@daveo123)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/making-private-posts-public-again/#post-154103)
 * Worked like a charm! Thanks guys. Appreciate the help.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘making private posts public again…’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 5 replies
 * 3 participants
 * Last reply from: [daveo123](https://wordpress.org/support/users/daveo123/)
 * Last activity: [21 years, 2 months ago](https://wordpress.org/support/topic/making-private-posts-public-again/#post-154103)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics