How to Change WordPress Site URL and Home URL directly in the Database.

[Rahul Sambre]

Hello,

You can also diretly modify your WordPress URL settings in the WordPress database using the phpMyAdmin tool.

1) Backup your database in cPanel prior to making changes.
2) Login to cPanel And select phpMyAdmin.
3) Use phpMyAdmin to manage your WordPress database.
4) phpMyAdmin select WordPress databaseSelect your WordPress database from the left.
5) Then select your wp_options table. Your wp_ prefix may differ depending on your install settings.
6)  Click Edit beside either the site URL or home URL entries.
7) Enter in your new URL in the option_valuie field, then click Go.

That's it.