Assign posts to another author in WordPress

First find the USER ID from wp_users table.

Execute the following SQL command from the Database:

UPDATE wp_posts SET post_author = '1' WHERE post_author = '10';[/code] 

switches the posts authored by user No 10, to ownership by user No 1

You are reading this post on Joel G Mathew’s tech blog. Joel's personal blog is the Eyrie, hosted here.