Site Loader
Get a Quote
Avoli,Muvattupuzha, Kerala , India
  1. 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');

Please follow and like us:
Pin Share

Post Author: praveen

Leave a Reply

Your email address will not be published. Required fields are marked *

RSS
Follow by Email