I originally begun my wordpress site using a psudonym. Over the past few years I have been attributing my own name to all articles and have had the author name options switched off.
Now I'm changing theme I want to get the benefit of having the correct author name show up automatically against each new post, and if possible changing all the old posts to this new author name.
I'm wondering if it's possible to just change the name directly inside the PHP database, or if doing so would cause countless complications? I run the site alone and didn't want to have to set up umltiple accounts against my own wordpress site as the old author name will still exist.