Changing blog domain name

Rather than manually making changes to the WP tables, I use the “WP Clone” plugin. It saves the entire blog to a zip file, then you Restore that on the new site (using WP Clone). The restore process makes any needed changes to the domain names/links/whatever, so the new site just works.

You will log in to the new site with your old site’s credentials, but all users, media, posts, themes, plugins, etc will work just fine on the new site.

You’ll find the plugin here https://wordpress.org/plugins/wp-clone-by-wp-academy/ . I’ve used it several times, and it Just Works.

(Note, no affiliation with the WP Clone guys other than a satisfied user.)