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.
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.