Changing url of author page

Yes, if you really want to just change it directly in the database, you are looking for the user_nicename field (column) in the users table.

This is the value that WP uses for author archive URLs.

Related Posts:

  1. Allow UTF-8 characters in the user slug part of URL
  2. How to create a page for authors? like www.myblog.com/author/
  3. Extracting a variable from a permalink
  4. How to create custom authors links
  5. Custom plugin route in WordPress
  6. Why is ?doing_wp_cron being appended to my URLs
  7. use query string in URL to display content on the page
  8. Change default URL path (/blog/) of blog posts
  9. How to deal with WordPress on localhost
  10. Change the author slug from nickname to ID
  11. How to convert the file path to a URL of the same file?
  12. Why is WordPress saving full-urls to the database?
  13. Display posts with author in the url with custom post types
  14. Get taxonomy slug from url
  15. Load images with http urls inside https post
  16. Force the Website URL to Include “www” and to be Upper Case?
  17. WordPress and $_GET Params
  18. List of default WordPress URLs
  19. Why WP encodes UNICODE (UTF8) containing urls? Any drawbacks of UNICODE url?
  20. Unable to load static front page on home url
  21. Force home page to be https?
  22. add_query_arg() One Key with multiple values
  23. Change homepage url
  24. How to link current user to their author page through shortcodes
  25. How to update media links in WordPress after migration?
  26. Check what is at URI (post, archive, etc…)
  27. How can I change all links on pages to point to a different domain from where the site is hosted?
  28. Why ids in urls don’t work but slugs do?
  29. Changing my site url from azure.net to custom domain
  30. Remove / from www.example.com/ [closed]
  31. Check request URL for pattern
  32. Rewrite WordPress Standard Feed URL – /feed/ to feed.xml
  33. Set a custom URL for image in the Media Library?
  34. wp_insert_post – How do I prevent incremental numbers on child pages?
  35. Dynamic URL based on user_metadata
  36. How to edit URL Slug?
  37. Check if user is logged in to site A when visiting site B
  38. Publish Post when URL is available else reschedule the post in wordpress [duplicate]
  39. wp-comment author- url +, email filter hook
  40. Change url links on members loops in buddypress
  41. Find file url in post content and add it to media library
  42. Localhost port is missing on some links after downgrading MAMP [closed]
  43. rewrite taxonomy-{taxonomy}-{term}.php terms
  44. Why am I seeing all these weird ‘loginid’ requests?
  45. Confusion about Site url and directory
  46. Multiple URLs with Numbers
  47. hijacking home_url for root relative paths
  48. How to properly print a 404 error without redirecton? (i.e. keeping the current URL)
  49. Will get_bloginfo(‘url’) return URL with backslash?
  50. Can anybody provide me with a function to generate slugs?
  51. Is there RELATIVE_PATH, like ABSPATH
  52. Accessing WordPress using “localhost” and local ip at the same time
  53. Porting site URLs to new host but with same domain name [closed]
  54. My #id is not showing in the url when the user clicks on the anchor tag
  55. Is there a way to test if a URL is part of the current blog?
  56. Showing my server ip in source code for several links not for all links
  57. Could not find the wordpress page
  58. An anchor name (id name) in the address bar
  59. Moving Website-URL
  60. How to prevent unknown addresses which are accessed from my wordpress website [closed]
  61. get_template_directory() returns wrong address on VPS
  62. Is there an URL listing latest posts
  63. Image not showing up in media loader success area – followup
  64. Redirecting URL with Twitter Button API Not Working
  65. Need help changing back the correct wordpress url
  66. Adding Parent Categories and keep current URLs
  67. How to display translated content with custom slug?
  68. How to get a page url segment on wordpress?
  69. Different url to same page (with dynamic content)
  70. WordPress option com_jce should not work
  71. Too many redirects (ERR_TOO_MANY_REDIRECTS) only on one page
  72. Adding Author URL to Nav Menu via Shortcode
  73. WordPress Still Requesting Old Url
  74. Broken Images and Style
  75. Add more than one query parameter onto wordpress url
  76. WordPress Website change directory
  77. Allow duplicate slugs for pages and posts
  78. i1.wp.com url problem (Jetpack not installed)
  79. Change dynamically URL to SEO friendly via .htaccess?
  80. incorrect url in Snippet editor
  81. Get userdata from url
  82. How to make url variable?
  83. WordPress dynamic subpage for ACF
  84. WordPress Address (URL) Reverts back
  85. Modify the WordPress URL
  86. Duplicate pages with ?s parameter
  87. How to pass REQUEST_URI to function
  88. Populate Website URL at registration time
  89. WordPress Update Links
  90. wordpress url with format .com/category/sub-category
  91. URL Forwarding – wordpress links reverting back
  92. Get gallery url (Nextgen) [closed]
  93. How to use query string in URL to display content on the wordpress page
  94. help me remove this additional parameter in url
  95. Function to get custom post image URL
  96. How to echo a dynamic url
  97. How to run Wiki on the same host as WordPress and not get 404 errors when browsing to Wiki?
  98. Where can I add list of external URL for WP ADD link tool?
  99. WordPress page URL: Get rid of /wp-content/… part from URL
  100. How to create multiple urls for a same page contents in wordpress