How to change user profile page URL?

I am trying to change the url of some user profile pages.

For example:

https://www.mysite.com/author/pdyrus ———–> https://www.mysite.com/author/dyrus

I would just redo them all over but I spent over a day linking content to all these profile pages.

I managed to remove the p from the username using phpmyadmin but it made no difference to the actual URL.

Does anyone know how to customize the URL of user profile pages?

Thanks