Interesting issue here:
I have my admin account and I have made a few other accounts. Once I logged in as one of these other accounts and now, everytime I make a post with my admin account, WordPress has the author as 'Alex' which is the account that I logged in as once.
I have checked my wp_users table and it all seems in order for the users in question.
I have tried deleting the real Alex account and I was able to assign all of it's posts to the admin account at which point they showed up correctly with the admin as the author. But when I remade the real Alex account, the posts showed up again as Alex
Thanks in advance