Change author via SQL query

If it’s all of their articles, you could remove author 1, and attribute all their content to author 2. That’d be the quickest way without messing with the database directly.

Thank you for your reply, but I don’t want to delete that user… as it is the used I log in with. It’s the admin user. I have “Mysite User” and “Mysite”.. and I need all the articles to be posted under “Mysite”, if possible.

You’d need to do it with an SQL query.

As a (very rough and not at all tested) example…

UPDATE wp_posts -- Make sure to set your own table prefix here
SET post_author = 2  -- The new author ID
WHERE post_author = 4;  -- The old author ID

That will transfer every post created by the user ID 4 to the user ID 2.

Just remember that you should always take a backup of your database before doing any manual changes like this, just in case something bad does happen.

Thank you so much!
Then in the SQL query field in cPanel I would need to use this:

UPDATE wp_posts SET post_author = 2 WHERE post_author = 4;

right? Correct me if I’m wrong. Obviously changing the fields as you said (and making a db backup before).

Yes, that’s correct.

That worked, thank you!