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
- Database “Migration” for Plugins?
- 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?
- List of posts by day of the week
- register_activation_hook isn’t adding table to DB
- How to display posts of specific category using a custom Query in WordPress?
- What SQL / WordPress queries would need a nonce?
- 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
- Styling my own password protected page, how to deal with wrong password?
- Genesis framework comments broken?
- $wpdb->insert() does not Insert record in a table
- Databases – Submitting data from inputs to database [closed]
- How to know where this function definition is declared?
- Password minimum length in personal subscription [closed]
- 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
- How to Update post_modified of all wordpress post
- 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
- Lost in trying to create user database system
- Pull MySQL data from multiple tables and merge into 1 PHP array
- Filter results from a serialized string to use on statistics
- wordpress site – using custom database and PHP
- Searching Posts Programmatically in a WordPress Plugin
- 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
- making php value numeric
- Using color schemes with Color Picker
- WordPress SQL JOIN query
- Fetching review value using wpdb class
- quotes problem in very simple sql
- 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?
- Password protect URLs
- get_terms with specific id order
- Database SQL query error
- get different meta-data of a complicated query at the same time
- WordPress SQL Prepare
- Build A Custom SQL Query for WordPress Search
- How to run complex query using PHP
- Storing huge number of users in wordpress
- 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
- How can I order metaboxes in my posts in WordPress?
- Password form redirection to belonging post
- Search results always returns “No results” no matter what
- Can’t send form data to wpdb when URL has query string
- 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
- Where is WooCommerce order shipping methods stored
- How to send user password reset link to their phone number instead of email
- How to properly prepare a column name if passed to a stored procedure?