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.
Related Posts:
- Sending the reset password link programatically
- Enforcing password complexity
- Transaction when using WP functions rather than vanilla SQL?
- $wpdb->get_results(…) returns empty array despite correct query
- How to get the list of WooCommerce product image of a certain category from database?
- How to make WordPress plugin check for database changes and then do something?
- Alter query on edit.php
- Change Password Hint
- How to auto login user again after change user_login
- How to display multiple Post meta_key/meta_values by SQL query
- How to Join two tables from separate databases within WordPress
- count number of user comments with a specific comment meta value
- Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
- WPDB: how to get the value of a field in a custom database table
- Go to / Scroll to Password Field on WordPress Posts After Submit With Message(s)
- my function doesn’t return my post from today
- Enhanced WordPress Search
- Automatically generate Post/Page from searched Database item?
- register_activation_hook isn’t adding table to DB
- How to display posts of specific category using a custom Query in WordPress?
- Password protecting content in custom template
- Renaming post IDs – Okay to do?
- How to filter/hook-into retrieve_password() to filter $_POST[‘user_login’]?
- How to generate page content from database the right way?
- phpMyAdmin displays error when importing database
- Preferred Method of debugging a wordpress SQL calls?
- Get Current User Id Inside a Loop Returns 0 For a Shortcode
- Get stock by custom meta field on all Woocommerce variable products
- Transferring working local PHP site to wordpress – with database (MySQL)
- how to delete 30 day old data using PHP [closed]
- Display fields as values in array from external SQL DB
- Importing Geo data into wordpress database
- Detect session/cookie variable in wordpress to prevent access to documents
- How to limit the number of forgot password reset attempts in WordPress?
- Querying wpdb using PHP
- WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
- Archive post by meta value + 24hours
- Genesis framework comments broken?
- Databases – Submitting data from inputs to database [closed]
- How to know where this function definition is declared?
- Is it best to avoid using $wpdb for security issues?
- dynamic page using php from sql database
- Use $wpdb or other PHP script method to find/replace in WP database
- Correct PHP to output a single result of a Function with SQL Query
- How can I add a new row in a separate database when someone registers via WordPress?
- Redirecting to a custom forgot password page
- How do I create a function that modifies a message in the wp-login.php file?
- WordPress produces identical hash all the time
- Change page password every day (predictable password ;) )
- PHP -> SQL Query with Summing
- Pull MySQL data from multiple tables and merge into 1 PHP array
- wordpress site – using custom database and PHP
- Use variable in SQL statement
- Why my query does not run with prepare
- wpdb getting avatars and author url
- mySQL queries are executed twice on wordpress website
- Fetching review value using wpdb class
- wordpress sql posts query won’t display the latest post in a specific category
- Display latest post from WordPress Featured Category that is also in X,Y,or Z categories
- WP_Query: How to get results from both meta_key options?
- Database SQL query error
- WordPress SQL Prepare
- How to run complex query using PHP
- Storing huge number of users in wordpress
- add role on WordPress in PHP on a second database
- Trying to create a shortcode to display categories with a specific product tag
- Fetch Data from an external MSSQL Database in a Managed WP hosting
- Run a sql (update) after 12 hours after the user login. Woocommerce users
- Creating multiple tables with Plugin
- Custom User registration system
- How to use Multi SQL Database in WordPress?
- Woocommerce – get daily sales meta
- Running a PHP SQL script on a wordpress page
- Collect all events in one year
- WordPress search query, how to modify the sql
- Redirecting the lost password page request when using a custon login page
- Hook into all password resets in WordPress and get password before hashing?
- Inserting other fields to existing registration form in a WordPress theme
- Getting error in sql query
- user update profile for custom code
- Where to check in PHPmyAdmin / SQL database for subdomain
- Issue encountered while trying to keep website private
- Front end/Database connection in WP
- Plugin Modification Change Functionality For Logged User Only
- SQL Query Search page
- direct query to post_meta table
- can’t delete a row from post_meta table
- Conditional statement within WP SQL query
- Can not manually create a database ( db, user, pass ) for a plugin
- Sum of Custom Meta written by Authour
- How to merge 2 WordPress sites?
- See output of a sql query while plugin installation in wordpress
- Querying multiple meta_keys in WordPress SQL query
- How to export database correctly for local to online
- Search results always returns “No results” no matter what
- Retrieve data from external database and insert back in
- SQL query to retrieve the number of WordPress posts with all given categories
- How to sort search result by post_title, then by post_content
- Help writing out comments and replies
- How to send user password reset link to their phone number instead of email