https://www.wpbeginner.com/wp-tutorials/how-to-move-wordpress-from-local-server-to-live-site/
This article covers most of it but this piece of SQL is so useful it’s worth reproducing it here.
Once you have imported your local database to the live site through phpMyAdmin, run this query;
UPDATE wp_options SET option_value = replace(option_value, ‘https://olddomain.com’, ‘https://newdomain.com’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;
UPDATE wp_posts SET guid = replace(guid, ‘https://olddomain.com’,’https://newdomain.com’);
UPDATE wp_posts SET post_content = replace(post_content, ‘https://olddomain.com’, ‘https://newdomain.com’);
UPDATE wp_postmeta SET meta_value = replace(meta_value, ‘https://olddomain.com’, ‘https://newdomain.com’);