Use the following SQL commands:
UPDATE wp_posts SET post_status='STATUS';
Replace STATUS with private or public. This edits all posts by every user. If you have multiple authors and only want to edit one, you may use the following:
UPDATE wp_posts SET post_status='STATUS' WHERE post_author='NUMBER';
Remember to replace NUMBER with the correct ID number of the author.
