How To change WordPress site address in phpmyadmin using SQL

Spread the love

Go to PhpMyAdmin, go in you table name and in the sql box type:

# Change site name 
UPDATE wp_options SET option_value = 'http://yournewsite.com' WHERE option_id = 2;
UPDATE wp_options SET option_value = 'http://yournewsite.com' WHERE option_id = 2;

# Disable plugins
UPDATE wp_options SET option_value = '' WHERE option_id = 33Code language: PHP (php)