- Admin user password reset
UPDATE wp_users SET user_pass = MD5( 'new_password') WHERE user_login = 'your_username';
2. Admin user name reset
UPDATE wp_users SET user_login = 'Your New Username' WHERE user_login = 'Current username';
3. Change Siteurl and Homeurl
UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldsiteurl.in', 'http://www.newsiteurl.in') WHERE option_name = 'home' OR option_name = 'siteurl';
4.Change URL in Content and GUID
UPDATE wp_posts SET post_content = REPLACE(post_content, 'http://www.oldsiteurl.in', 'http://www.newsiteurl.in');
UPDATE wp_posts SET guid = REPLACE(guid, 'http://www.oldsiteurl.in', 'http://www.newsiteurl.in');
5.Replace image urls
UPDATE
wp_posts SET
post_content = REPLACE
(post_content, 'src="https://www.oldsiteurl.in',
'src="https://yourcdn.newsiteurl.in');