[fusion_builder_container type=”flex” hundred_percent=”no” equal_height_columns=”no” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” background_position=”center center” background_repeat=”no-repeat” fade=”no” background_parallax=”none” parallax_speed=”0.3″ video_aspect_ratio=”16:9″ video_loop=”yes” video_mute=”yes” border_style=”solid” admin_toggled=”no”][fusion_builder_row][fusion_builder_column type=”1_1″ layout=”1_1″ background_position=”left top” border_style=”solid” border_position=”all” spacing=”yes” background_repeat=”no-repeat” margin_top=”0px” margin_bottom=”0px” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” center_content=”no” last=”true” hover_type=”none” background_blend_mode=”overlay” first=”true” min_height=”” link=””][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”” rule_size=”” rule_color=”” hue=”” saturation=”” lightness=”” alpha=”” user_select=”” awb-switch-editor-focus=”” content_alignment_medium=”” content_alignment_small=”” content_alignment=”” disable_idd=”no” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” html_attributes=”W10=” width_medium=”” width_small=”” width=”” min_width_medium=”” min_width_small=”” min_width=”” max_width_medium=”” max_width_small=”” max_width=”” margin_top_medium=”” margin_right_medium=”” margin_bottom_medium=”” margin_left_medium=”” margin_top_small=”” margin_right_small=”” margin_bottom_small=”” margin_left_small=”” margin_top=”” margin_right=”” margin_bottom=”90px” margin_left=”” fusion_font_family_text_font=”” fusion_font_variant_text_font=”” font_size=”” line_height=”” letter_spacing=”” text_transform=”” text_color=”” render_logics=”” logics=”” animation_type=”fade” animation_direction=”up” animation_color=”” animation_speed=”0.6″ animation_delay=”0.2″ animation_offset=””]
So, you know WordPress stores all its important stuff, like website addresses, in something called a MySQL database. And if you want to switch up your WordPress URL, you’ll need to tweak things a bit in MySQL. Don’t worry, I’ve got your back—I’ll walk you through the steps right here in this article. Just keep on reading to find out how it’s done!
[/fusion_text][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”” rule_size=”” rule_color=”” hue=”” saturation=”” lightness=”” alpha=”” user_select=”” awb-switch-editor-focus=”” content_alignment_medium=”” content_alignment_small=”” content_alignment=”” disable_idd=”no” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” html_attributes=”W10=” width_medium=”” width_small=”” width=”” min_width_medium=”” min_width_small=”” min_width=”” max_width_medium=”” max_width_small=”” max_width=”” margin_top_medium=”” margin_right_medium=”” margin_bottom_medium=”” margin_left_medium=”” margin_top_small=”” margin_right_small=”” margin_bottom_small=”” margin_left_small=”” margin_top=”” margin_right=”” margin_bottom=”40px” margin_left=”” fusion_font_family_text_font=”” fusion_font_variant_text_font=”” font_size=”” line_height=”” letter_spacing=”” text_transform=”” text_color=”” render_logics=”” logics=”” animation_type=”fade” animation_direction=”up” animation_color=”” animation_speed=”0.8″ animation_delay=”0.2″ animation_offset=””]
1. Finding the Name of WordPress MySQL Database.
If you’ve got just one MySQL database, you can totally skip this section. But, if you’ve got a bunch of them and you’re not quite sure which one is the WordPress champ, then here’s what you can do: So, here’s the scoop: WordPress keeps track of its favorite databases and their secret codes in a file called wp-config.php. You can locate this file in the main folder of your website
- Access your cPanel and open File Manager.
- Click on the domain name, then click Go to File Manage
[/fusion_text][fusion_imageframe image_id=”1662|fusion-800″ aspect_ratio=”” custom_aspect_ratio=”100″ aspect_ratio_position=”” fetch_priority=”” skip_lazy_load=”” lightbox=”yes” gallery_id=”” lightbox_image=”” lightbox_image_id=”” alt=”” link=”” linktarget=”_self” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” html_attributes=”W10=” max_width=”” sticky_max_width=”” align_medium=”none” align_small=”none” align=”center” mask=”” custom_mask=”” mask_size=”” mask_custom_size=”” mask_position=”” mask_custom_position=”” mask_repeat=”” style_type=”” blur=”” stylecolor=”” hue=”” saturation=”” lightness=”” alpha=”” hover_type=”none” magnify_full_img=”” magnify_duration=”120″ scroll_height=”100″ scroll_speed=”1″ margin_top_medium=”” margin_right_medium=”” margin_bottom_medium=”” margin_left_medium=”” margin_top_small=”” margin_right_small=”” margin_bottom_small=”” margin_left_small=”” margin_top=”” margin_right=”” margin_bottom=”70px” margin_left=”” bordersize=”” bordercolor=”” borderradius=”5px” z_index=”” caption_style=”off” caption_align_medium=”none” caption_align_small=”none” caption_align=”center” caption_title=”Our amazing team is always hard at work” caption_text=”” caption_title_tag=”4″ fusion_font_family_caption_title_font=”var(–awb-typography5-font-family)” fusion_font_variant_caption_title_font=”var(–awb-typography5)” caption_title_size=”var(–awb-typography5-font-size)” caption_title_line_height=”var(–awb-typography5-line-height)” caption_title_letter_spacing=”var(–awb-typography5-letter-spacing)” caption_title_transform=”var(–awb-typography5-text-transform)” caption_title_color=”” caption_background_color=”var(–awb-color8)” fusion_font_family_caption_text_font=”” fusion_font_variant_caption_text_font=”” caption_text_size=”” caption_text_line_height=”” caption_text_letter_spacing=”” caption_text_transform=”” caption_text_color=”” caption_border_color=”” caption_overlay_color=”var(–awb-color8)” caption_margin_top=”20px” caption_margin_right=”” caption_margin_bottom=”” caption_margin_left=”” render_logics=”” animation_type=”fade” animation_direction=”up” animation_color=”” animation_speed=”0.6″ animation_delay=”0.2″ animation_offset=”” filter_hue=”0″ filter_saturation=”100″ filter_brightness=”100″ filter_contrast=”100″ filter_invert=”0″ filter_sepia=”0″ filter_opacity=”100″ filter_blur=”0″ filter_hue_hover=”0″ filter_saturation_hover=”100″ filter_brightness_hover=”100″ filter_contrast_hover=”100″ filter_invert_hover=”0″ filter_sepia_hover=”0″ filter_opacity_hover=”100″ filter_blur_hover=”0″]http://10.183.136.170/abhinavdcs/wp-content/uploads/2026/01/blog-1-800×490.png[/fusion_imageframe][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”” rule_size=”” rule_color=”” hue=”” saturation=”” lightness=”” alpha=”” user_select=”” awb-switch-editor-focus=”” content_alignment_medium=”” content_alignment_small=”” content_alignment=”” disable_idd=”no” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” html_attributes=”W10=” width_medium=”” width_small=”” width=”” min_width_medium=”” min_width_small=”” min_width=”” max_width_medium=”” max_width_small=”” max_width=”” margin_top_medium=”” margin_right_medium=”” margin_bottom_medium=”” margin_left_medium=”” margin_top_small=”” margin_right_small=”” margin_bottom_small=”” margin_left_small=”” margin_top=”” margin_right=”” margin_bottom=”40px” margin_left=”” fusion_font_family_text_font=”” fusion_font_variant_text_font=”” font_size=”” line_height=”” letter_spacing=”” text_transform=”” text_color=”” render_logics=”” logics=”” animation_type=”fade” animation_direction=”up” animation_color=”” animation_speed=”0.8″ animation_delay=”0.2″ animation_offset=””]
- Open wp-config.php and search for DB_NAME. The value of this parameter is your database name. For instance, the name of our MySQL database is u123456789_gagap.
- Changing WordPress URLs in MySQL Database
To substitute your current URL, follow these steps:
- select phpMyAdmin via your website’s control panel.
The left panel lists all of your databases. Select the one connected to your WordPress site and head to the SQL tab.
[/fusion_text][fusion_imageframe image_id=”1661|fusion-800″ aspect_ratio=”” custom_aspect_ratio=”100″ aspect_ratio_position=”” fetch_priority=”” skip_lazy_load=”” lightbox=”yes” gallery_id=”” lightbox_image=”” lightbox_image_id=”” alt=”” link=”” linktarget=”_self” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” html_attributes=”W10=” max_width=”” sticky_max_width=”” align_medium=”none” align_small=”none” align=”center” mask=”” custom_mask=”” mask_size=”” mask_custom_size=”” mask_position=”” mask_custom_position=”” mask_repeat=”” style_type=”” blur=”” stylecolor=”” hue=”” saturation=”” lightness=”” alpha=”” hover_type=”none” magnify_full_img=”” magnify_duration=”120″ scroll_height=”100″ scroll_speed=”1″ margin_top_medium=”” margin_right_medium=”” margin_bottom_medium=”” margin_left_medium=”” margin_top_small=”” margin_right_small=”” margin_bottom_small=”” margin_left_small=”” margin_top=”” margin_right=”” margin_bottom=”70px” margin_left=”” bordersize=”” bordercolor=”” borderradius=”5px” z_index=”” caption_style=”off” caption_align_medium=”none” caption_align_small=”none” caption_align=”center” caption_title=”Our amazing team is always hard at work” caption_text=”” caption_title_tag=”4″ fusion_font_family_caption_title_font=”var(–awb-typography5-font-family)” fusion_font_variant_caption_title_font=”var(–awb-typography5)” caption_title_size=”var(–awb-typography5-font-size)” caption_title_line_height=”var(–awb-typography5-line-height)” caption_title_letter_spacing=”var(–awb-typography5-letter-spacing)” caption_title_transform=”var(–awb-typography5-text-transform)” caption_title_color=”” caption_background_color=”var(–awb-color8)” fusion_font_family_caption_text_font=”” fusion_font_variant_caption_text_font=”” caption_text_size=”” caption_text_line_height=”” caption_text_letter_spacing=”” caption_text_transform=”” caption_text_color=”” caption_border_color=”” caption_overlay_color=”var(–awb-color8)” caption_margin_top=”20px” caption_margin_right=”” caption_margin_bottom=”” caption_margin_left=”” render_logics=”” animation_type=”fade” animation_direction=”up” animation_color=”” animation_speed=”0.6″ animation_delay=”0.2″ animation_offset=”” filter_hue=”0″ filter_saturation=”100″ filter_brightness=”100″ filter_contrast=”100″ filter_invert=”0″ filter_sepia=”0″ filter_opacity=”100″ filter_blur=”0″ filter_hue_hover=”0″ filter_saturation_hover=”100″ filter_brightness_hover=”100″ filter_contrast_hover=”100″ filter_invert_hover=”0″ filter_sepia_hover=”0″ filter_opacity_hover=”100″ filter_blur_hover=”0″]http://10.183.136.170/abhinavdcs/wp-content/uploads/2026/01/blog-2-800×530.png[/fusion_imageframe][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”” rule_size=”” rule_color=”” hue=”” saturation=”” lightness=”” alpha=”” user_select=”” awb-switch-editor-focus=”” content_alignment_medium=”” content_alignment_small=”” content_alignment=”” disable_idd=”no” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” html_attributes=”W10=” width_medium=”” width_small=”” width=”” min_width_medium=”” min_width_small=”” min_width=”” max_width_medium=”” max_width_small=”” max_width=”” margin_top_medium=”” margin_right_medium=”” margin_bottom_medium=”” margin_left_medium=”” margin_top_small=”” margin_right_small=”” margin_bottom_small=”” margin_left_small=”” margin_top=”” margin_right=”” margin_bottom=”40px” margin_left=”” fusion_font_family_text_font=”” fusion_font_variant_text_font=”” font_size=”” line_height=”” letter_spacing=”” text_transform=”” text_color=”” render_logics=”” logics=”” animation_type=”fade” animation_direction=”up” animation_color=”” animation_speed=”0.8″ animation_delay=”0.2″ animation_offset=””]
1. Changing WordPress URLs in MySQL Database
To replace your current URL, follow these steps:
- Go to phpMyAdminvia your website’s control panel.
- The left panel lists all of your databases. Select the one connected to your WordPress site and head to the SQL
[/fusion_text][fusion_imageframe image_id=”1660|fusion-800″ aspect_ratio=”” custom_aspect_ratio=”100″ aspect_ratio_position=”” fetch_priority=”” skip_lazy_load=”” lightbox=”yes” gallery_id=”” lightbox_image=”” lightbox_image_id=”” alt=”” link=”” linktarget=”_self” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” html_attributes=”W10=” max_width=”” sticky_max_width=”” align_medium=”none” align_small=”none” align=”center” mask=”” custom_mask=”” mask_size=”” mask_custom_size=”” mask_position=”” mask_custom_position=”” mask_repeat=”” style_type=”” blur=”” stylecolor=”” hue=”” saturation=”” lightness=”” alpha=”” hover_type=”none” magnify_full_img=”” magnify_duration=”120″ scroll_height=”100″ scroll_speed=”1″ margin_top_medium=”” margin_right_medium=”” margin_bottom_medium=”” margin_left_medium=”” margin_top_small=”” margin_right_small=”” margin_bottom_small=”” margin_left_small=”” margin_top=”” margin_right=”” margin_bottom=”70px” margin_left=”” bordersize=”” bordercolor=”” borderradius=”5px” z_index=”” caption_style=”off” caption_align_medium=”none” caption_align_small=”none” caption_align=”center” caption_title=”Our amazing team is always hard at work” caption_text=”” caption_title_tag=”4″ fusion_font_family_caption_title_font=”var(–awb-typography5-font-family)” fusion_font_variant_caption_title_font=”var(–awb-typography5)” caption_title_size=”var(–awb-typography5-font-size)” caption_title_line_height=”var(–awb-typography5-line-height)” caption_title_letter_spacing=”var(–awb-typography5-letter-spacing)” caption_title_transform=”var(–awb-typography5-text-transform)” caption_title_color=”” caption_background_color=”var(–awb-color8)” fusion_font_family_caption_text_font=”” fusion_font_variant_caption_text_font=”” caption_text_size=”” caption_text_line_height=”” caption_text_letter_spacing=”” caption_text_transform=”” caption_text_color=”” caption_border_color=”” caption_overlay_color=”var(–awb-color8)” caption_margin_top=”20px” caption_margin_right=”” caption_margin_bottom=”” caption_margin_left=”” render_logics=”” animation_type=”fade” animation_direction=”up” animation_color=”” animation_speed=”0.6″ animation_delay=”0.2″ animation_offset=”” filter_hue=”0″ filter_saturation=”100″ filter_brightness=”100″ filter_contrast=”100″ filter_invert=”0″ filter_sepia=”0″ filter_opacity=”100″ filter_blur=”0″ filter_hue_hover=”0″ filter_saturation_hover=”100″ filter_brightness_hover=”100″ filter_contrast_hover=”100″ filter_invert_hover=”0″ filter_sepia_hover=”0″ filter_opacity_hover=”100″ filter_blur_hover=”0″]http://10.183.136.170/abhinavdcs/wp-content/uploads/2026/01/blog-3-800×254.png[/fusion_imageframe][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”” rule_size=”” rule_color=”” hue=”” saturation=”” lightness=”” alpha=”” user_select=”” awb-switch-editor-focus=”” content_alignment_medium=”” content_alignment_small=”” content_alignment=”” disable_idd=”no” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” html_attributes=”W10=” width_medium=”” width_small=”” width=”” min_width_medium=”” min_width_small=”” min_width=”” max_width_medium=”” max_width_small=”” max_width=”” margin_top_medium=”” margin_right_medium=”” margin_bottom_medium=”” margin_left_medium=”” margin_top_small=”” margin_right_small=”” margin_bottom_small=”” margin_left_small=”” margin_top=”” margin_right=”” margin_bottom=”30px” margin_left=”” fusion_font_family_text_font=”” fusion_font_variant_text_font=”” font_size=”” line_height=”” letter_spacing=”” text_transform=”” text_color=”” render_logics=”” logics=”” animation_type=”fade” animation_direction=”up” animation_color=”” animation_speed=”0.8″ animation_delay=”0.2″ animation_offset=””]
- Enter the following SQL query:
[/fusion_text][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”” rule_size=”” rule_color=”” hue=”” saturation=”” lightness=”” alpha=”” user_select=”” awb-switch-editor-focus=”” content_alignment_medium=”” content_alignment_small=”” content_alignment=”” disable_idd=”no” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” html_attributes=”W10=” width_medium=”” width_small=”” width=”” min_width_medium=”” min_width_small=”” min_width=”” max_width_medium=”” max_width_small=”” max_width=”” margin_top_medium=”” margin_right_medium=”” margin_bottom_medium=”” margin_left_medium=”” margin_top_small=”” margin_right_small=”” margin_bottom_small=”” margin_left_small=”” margin_top=”” margin_right=”” margin_bottom=”40px” margin_left=”” fusion_font_family_text_font=”” fusion_font_variant_text_font=”” font_size=”” line_height=”” letter_spacing=”” text_transform=”” text_color=”” render_logics=”” logics=”” animation_type=”fade” animation_direction=”up” animation_color=”” animation_speed=”0.8″ animation_delay=”0.2″ animation_offset=””]
[fusion_syntax_highlighter theme=”” language=”sql” line_numbers=”no” line_wrapping=”” copy_to_clipboard=”yes” copy_to_clipboard_text=”copy” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” font_size=”” border_size=”” border_color=”” hue=”” saturation=”” lightness=”” alpha=”” border_style=”” background_color=”” line_number_background_color=”” line_number_text_color=”” margin_top=”” margin_right=”” margin_bottom=”20px” margin_left=”” render_logics=””]VVBEQVRFIHdwX29wdGlvbnMgU0VUIG9wdGlvbl92YWx1ZSA9IHJlcGxhY2Uob3B0aW9uX3ZhbHVlLCDigJhvbGR1cmwuY29t4oCZLCDigJhuZXd1cmwuY29t4oCZKSBXSEVSRSBvcHRpb25fbmFtZSA9IOKAmGhvbWXigJkgT1IgCm9wdGlvbl9uYW1lID0g4oCYc2l0ZXVybOKAmTtVUERBVEUgd3BfcG9zdHMgU0VUIGd1aWQgPSByZXBsYWNlKGd1aWQsIOKAmG9sZHVybC5jb23igJks4oCZbmV3dXJsLmNvbeKAmSk7VVBEQVRFIHdwX3Bvc3RzIFNFVCBwb3N0X2NvbnRlbnQgPSAKcmVwbGFjZShwb3N0X2NvbnRlbnQsIOKAmG9sZHVybC5jb23igJksIOKAmG5ld3VybC5jb23igJkpOyBVUERBVEUgd3BfcG9zdG1ldGEgU0VUIG1ldGFfdmFsdWUgPSByZXBsYWNlKG1ldGFfdmFsdWUs4oCZb2xkdXJsLmNvbeKAmSzigJluZXd1cmwuY29t4oCZKTs=[/fusion_syntax_highlighter]
[/fusion_text][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”” rule_size=”” rule_color=”” hue=”” saturation=”” lightness=”” alpha=”” user_select=”” awb-switch-editor-focus=”” content_alignment_medium=”” content_alignment_small=”” content_alignment=”” disable_idd=”no” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” html_attributes=”W10=” width_medium=”” width_small=”” width=”” min_width_medium=”” min_width_small=”” min_width=”” max_width_medium=”” max_width_small=”” max_width=”” margin_top_medium=”” margin_right_medium=”” margin_bottom_medium=”” margin_left_medium=”” margin_top_small=”” margin_right_small=”” margin_bottom_small=”” margin_left_small=”” margin_top=”” margin_right=”” margin_bottom=”40px” margin_left=”” fusion_font_family_text_font=”” fusion_font_variant_text_font=”” font_size=”” line_height=”” letter_spacing=”” text_transform=”” text_color=”” render_logics=”” logics=”” animation_type=”fade” animation_direction=”up” animation_color=”” animation_speed=”0.8″ animation_delay=”0.2″ animation_offset=””]
Replace oldurl.com with your current WordPress address and newurl.com with your new WordPress address.
Important! Your table prefix might not be wp_. See the correct table prefix on the left panel of phpMyAdmin, and update the SQL query.
Click on the “Go” button. You’ll then be greeted with success messages and a count of the altered rows. Just remember, this row count might vary for each WordPress website
[/fusion_text][fusion_imageframe image_id=”1664|fusion-800″ aspect_ratio=”” custom_aspect_ratio=”100″ aspect_ratio_position=”” fetch_priority=”” skip_lazy_load=”” lightbox=”yes” gallery_id=”” lightbox_image=”” lightbox_image_id=”” alt=”” link=”” linktarget=”_self” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” html_attributes=”W10=” max_width=”” sticky_max_width=”” align_medium=”none” align_small=”none” align=”center” mask=”” custom_mask=”” mask_size=”” mask_custom_size=”” mask_position=”” mask_custom_position=”” mask_repeat=”” style_type=”” blur=”” stylecolor=”” hue=”” saturation=”” lightness=”” alpha=”” hover_type=”none” magnify_full_img=”” magnify_duration=”120″ scroll_height=”100″ scroll_speed=”1″ margin_top_medium=”” margin_right_medium=”” margin_bottom_medium=”” margin_left_medium=”” margin_top_small=”” margin_right_small=”” margin_bottom_small=”” margin_left_small=”” margin_top=”” margin_right=”” margin_bottom=”70px” margin_left=”” bordersize=”” bordercolor=”” borderradius=”5px” z_index=”” caption_style=”off” caption_align_medium=”none” caption_align_small=”none” caption_align=”center” caption_title=”Our amazing team is always hard at work” caption_text=”” caption_title_tag=”4″ fusion_font_family_caption_title_font=”var(–awb-typography5-font-family)” fusion_font_variant_caption_title_font=”var(–awb-typography5)” caption_title_size=”var(–awb-typography5-font-size)” caption_title_line_height=”var(–awb-typography5-line-height)” caption_title_letter_spacing=”var(–awb-typography5-letter-spacing)” caption_title_transform=”var(–awb-typography5-text-transform)” caption_title_color=”” caption_background_color=”var(–awb-color8)” fusion_font_family_caption_text_font=”” fusion_font_variant_caption_text_font=”” caption_text_size=”” caption_text_line_height=”” caption_text_letter_spacing=”” caption_text_transform=”” caption_text_color=”” caption_border_color=”” caption_overlay_color=”var(–awb-color8)” caption_margin_top=”20px” caption_margin_right=”” caption_margin_bottom=”” caption_margin_left=”” render_logics=”” animation_type=”fade” animation_direction=”up” animation_color=”” animation_speed=”0.6″ animation_delay=”0.2″ animation_offset=”” filter_hue=”0″ filter_saturation=”100″ filter_brightness=”100″ filter_contrast=”100″ filter_invert=”0″ filter_sepia=”0″ filter_opacity=”100″ filter_blur=”0″ filter_hue_hover=”0″ filter_saturation_hover=”100″ filter_brightness_hover=”100″ filter_contrast_hover=”100″ filter_invert_hover=”0″ filter_sepia_hover=”0″ filter_opacity_hover=”100″ filter_blur_hover=”0″]http://10.183.136.170/abhinavdcs/wp-content/uploads/2026/01/blog-4-800×304.png[/fusion_imageframe][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”” rule_size=”” rule_color=”” hue=”” saturation=”” lightness=”” alpha=”” user_select=”” awb-switch-editor-focus=”” content_alignment_medium=”” content_alignment_small=”” content_alignment=”” disable_idd=”no” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” html_attributes=”W10=” width_medium=”” width_small=”” width=”” min_width_medium=”” min_width_small=”” min_width=”” max_width_medium=”” max_width_small=”” max_width=”” margin_top_medium=”” margin_right_medium=”” margin_bottom_medium=”” margin_left_medium=”” margin_top_small=”” margin_right_small=”” margin_bottom_small=”” margin_left_small=”” margin_top=”” margin_right=”” margin_bottom=”40px” margin_left=”” fusion_font_family_text_font=”” fusion_font_variant_text_font=”” font_size=”” line_height=”” letter_spacing=”” text_transform=”” text_color=”” render_logics=”” logics=”” animation_type=”fade” animation_direction=”up” animation_color=”” animation_speed=”0.8″ animation_delay=”0.2″ animation_offset=””]
One final task remains: confirming the modifications. Access the wp_options table and examine the option_value for both ‘siteurl’ and ‘home’. Your brand new URL should be right there in plain sight.
[/fusion_text][fusion_imageframe image_id=”1665|fusion-800″ aspect_ratio=”” custom_aspect_ratio=”100″ aspect_ratio_position=”” fetch_priority=”” skip_lazy_load=”” lightbox=”yes” gallery_id=”” lightbox_image=”” lightbox_image_id=”” alt=”” link=”” linktarget=”_self” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” html_attributes=”W10=” max_width=”” sticky_max_width=”” align_medium=”none” align_small=”none” align=”center” mask=”” custom_mask=”” mask_size=”” mask_custom_size=”” mask_position=”” mask_custom_position=”” mask_repeat=”” style_type=”” blur=”” stylecolor=”” hue=”” saturation=”” lightness=”” alpha=”” hover_type=”none” magnify_full_img=”” magnify_duration=”120″ scroll_height=”100″ scroll_speed=”1″ margin_top_medium=”” margin_right_medium=”” margin_bottom_medium=”” margin_left_medium=”” margin_top_small=”” margin_right_small=”” margin_bottom_small=”” margin_left_small=”” margin_top=”” margin_right=”” margin_bottom=”70px” margin_left=”” bordersize=”” bordercolor=”” borderradius=”5px” z_index=”” caption_style=”off” caption_align_medium=”none” caption_align_small=”none” caption_align=”center” caption_title=”Our amazing team is always hard at work” caption_text=”” caption_title_tag=”4″ fusion_font_family_caption_title_font=”var(–awb-typography5-font-family)” fusion_font_variant_caption_title_font=”var(–awb-typography5)” caption_title_size=”var(–awb-typography5-font-size)” caption_title_line_height=”var(–awb-typography5-line-height)” caption_title_letter_spacing=”var(–awb-typography5-letter-spacing)” caption_title_transform=”var(–awb-typography5-text-transform)” caption_title_color=”” caption_background_color=”var(–awb-color8)” fusion_font_family_caption_text_font=”” fusion_font_variant_caption_text_font=”” caption_text_size=”” caption_text_line_height=”” caption_text_letter_spacing=”” caption_text_transform=”” caption_text_color=”” caption_border_color=”” caption_overlay_color=”var(–awb-color8)” caption_margin_top=”20px” caption_margin_right=”” caption_margin_bottom=”” caption_margin_left=”” render_logics=”” animation_type=”fade” animation_direction=”up” animation_color=”” animation_speed=”0.6″ animation_delay=”0.2″ animation_offset=”” filter_hue=”0″ filter_saturation=”100″ filter_brightness=”100″ filter_contrast=”100″ filter_invert=”0″ filter_sepia=”0″ filter_opacity=”100″ filter_blur=”0″ filter_hue_hover=”0″ filter_saturation_hover=”100″ filter_brightness_hover=”100″ filter_contrast_hover=”100″ filter_invert_hover=”0″ filter_sepia_hover=”0″ filter_opacity_hover=”100″ filter_blur_hover=”0″]http://10.183.136.170/abhinavdcs/wp-content/uploads/2026/01/blog-5-800×380.png[/fusion_imageframe][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”” rule_size=”” rule_color=”” hue=”” saturation=”” lightness=”” alpha=”” user_select=”” awb-switch-editor-focus=”” content_alignment_medium=”” content_alignment_small=”” content_alignment=”” disable_idd=”no” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” html_attributes=”W10=” width_medium=”” width_small=”” width=”” min_width_medium=”” min_width_small=”” min_width=”” max_width_medium=”” max_width_small=”” max_width=”” margin_top_medium=”” margin_right_medium=”” margin_bottom_medium=”” margin_left_medium=”” margin_top_small=”” margin_right_small=”” margin_bottom_small=”” margin_left_small=”” margin_top=”” margin_right=”” margin_bottom=”40px” margin_left=”” fusion_font_family_text_font=”” fusion_font_variant_text_font=”” font_size=”” line_height=”” letter_spacing=”” text_transform=”” text_color=”” render_logics=”” logics=”” animation_type=”fade” animation_direction=”up” animation_color=”” animation_speed=”0.8″ animation_delay=”0.2″ animation_offset=””]
In case you encounter error messages and the queries aren’t going as planned, it’s a good idea to double-check your code for any syntax blunders and ensure you’re using the right table prefix. If the error sticks around, don’t hesitate to reach out to your hosting support for additional help.
[/fusion_text][fusion_title title_type=”text” scroll_reveal_effect=”color_change” scroll_reveal_basis=”chars” scroll_reveal_behavior=”always” scroll_reveal_duration=”500″ scroll_reveal_stagger=”200″ scroll_reveal_delay=”0″ scroll_reveal_above_fold=”yes” marquee_direction=”left” marquee_mask_edges=”no” marquee_speed=”15000″ rotation_effect=”bounceIn” display_time=”1200″ highlight_effect=”circle” loop_animation=”once” highlight_animation_duration=”1500″ highlight_width=”9″ highlight_smudge_effect=”no” highlight_top_margin=”0″ before_text=”” rotation_text=”” highlight_text=”” after_text=”” awb-switch-editor-focus=”” title_link=”off” link_url=”” link_target=”_self” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” html_attributes=”W10=” content_align_medium=”” content_align_small=”” content_align=”left” size=”4″ animated_font_size=”” fusion_font_family_title_font=”” fusion_font_variant_title_font=”” font_size=”” line_height=”” letter_spacing=”” text_transform=”” text_color=”” hue=”” saturation=”” lightness=”” alpha=”” animated_text_color=”” highlight_color=”” text_shadow=”no” text_shadow_vertical=”” text_shadow_horizontal=”” text_shadow_blur=”0″ text_shadow_color=”” text_stroke=”no” text_stroke_size=”1″ text_stroke_color=”” text_overflow=”none” margin_top_medium=”” margin_right_medium=”” margin_bottom_medium=”” margin_left_medium=”” margin_top_small=”” margin_right_small=”” margin_bottom_small=”” margin_left_small=”” margin_top=”” margin_right=”” margin_bottom=”” margin_left=”” margin_top_mobile=”” margin_bottom_mobile=”” gradient_font=”no” gradient_start_color=”” gradient_end_color=”” gradient_start_position=”0″ gradient_end_position=”100″ gradient_type=”linear” radial_direction=”center center” linear_angle=”180″ style_type=”default” sep_color=”” link_color=”” link_hover_color=”” render_logics=”” animation_type=”fade” animation_direction=”up” animation_color=”” animation_speed=”0.6″ animation_delay=”0.2″ animation_offset=”” logics=””]
Conclusion
[/fusion_title][fusion_text columns=”” column_min_width=”” column_spacing=”” rule_style=”” rule_size=”” rule_color=”” hue=”” saturation=”” lightness=”” alpha=”” user_select=”” awb-switch-editor-focus=”” content_alignment_medium=”” content_alignment_small=”” content_alignment=”” disable_idd=”no” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” sticky_display=”normal,sticky” class=”” id=”” html_attributes=”W10=” width_medium=”” width_small=”” width=”” min_width_medium=”” min_width_small=”” min_width=”” max_width_medium=”” max_width_small=”” max_width=”” margin_top_medium=”” margin_right_medium=”” margin_bottom_medium=”” margin_left_medium=”” margin_top_small=”” margin_right_small=”” margin_bottom_small=”” margin_left_small=”” margin_top=”” margin_right=”” margin_bottom=”40px” margin_left=”” fusion_font_family_text_font=”” fusion_font_variant_text_font=”” font_size=”” line_height=”” letter_spacing=”” text_transform=”” text_color=”” render_logics=”” logics=”” animation_type=”fade” animation_direction=”up” animation_color=”” animation_speed=”0.8″ animation_delay=”0.2″ animation_offset=””]
Congratulations! You’ve now mastered the art of switching up WordPress URLs right in the MySQL database using phpMyAdmin.
As you’ve seen, each step we covered is pretty simple. Just pinpoint the right database and throw in a few lines of code – voila!
Our aim with this tutorial was to offer you a crystal-clear roadmap for altering WordPress URLs in the MySQL database. If you’ve got any questions, feel free to drop them below. Happy website tweaking!
[/fusion_text][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]
Leave A Comment