How To change Wordpress site address in phpmyadmin using SQL

👤 admin

🔴 Admin

✍️ The most important thing in the world is to not be alone.

⏳ Last active: 23 Sep 2025 at 14:41

📅 Created: 20 Mar 2021 at 17:18

👀 Viewed: 89 times

✉️ Send Email

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

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 = 33