Login to the WordPress admin panel on the new server and change the WordPress Address (URL) and Site Address (URL).
If you don’t have admin credentials, use the alternate way by changing the value in MySQL DB.
mysql -u root -p
show databases;
Use <DB Name>;
update wp_options set option_value = 'http://<sitename>' where option_name = 'siteurl';
update wp_options set option_value = 'http://<sitename>' where option_name = 'home';
Additionally, you can use the below steps to reset the admin password.
mysql -u root -p
show databases;
+--------------------+
| Database |
+--------------------+
| i8623263_wp18 |
| information_schema |
| mysql |
| performance_schema |
| sys |
| wordpress |
Use <DB Name>;
show tables;
+-----------------------------------+
| Tables_in_i8623263_wp18 |
+-----------------------------------+
| wp_addonlibrary_addons |
| wp_addonlibrary_categories |
| wp_commentmeta |
| wp_comments |
| wp_e_events |
| wp_e_submissions |
| wp_e_submissions_actions_log |
| wp_e_submissions_values |
| wp_links |
| wp_options |
| wp_postmeta |
| wp_posts |
| wp_revslider_css |
| wp_revslider_css_bkp |
| wp_revslider_layer_animations |
| wp_revslider_layer_animations_bkp |
| wp_revslider_navigations |
| wp_revslider_navigations_bkp |
| wp_revslider_sliders |
| wp_revslider_sliders_bkp |
| wp_revslider_slides |
| wp_revslider_slides_bkp |
| wp_revslider_static_slides |
| wp_revslider_static_slides_bkp |
| wp_term_relationships |
| wp_term_taxonomy |
| wp_termmeta |
| wp_terms |
| wp_usermeta |
| wp_users |
| wp_vxcf_leads |
| wp_vxcf_leads_detail |
| wp_vxcf_leads_notes |
+-----------------------------------+
33 rows in set (0.00 sec)
select * from wp_users;
+----+------------+------------------------------------+---------------+--------------------+--------------------------------------+---------------------+---------------------+-------------+--------------+
| ID | user_login | user_pass | user_nicename | user_email | user_url | user_registered | user_activation_key | user_status | display_name |
+----+------------+------------------------------------+---------------+--------------------+--------------------------------------+---------------------+---------------------+-------------+--------------+
| 1 | testadmin | $P$BVoLwyzug9qSMfAgvda5jv4mBNtd1p. | admin | one@gmail.com | https://www.demo.one.net| 2023-11-27 00:05:34 | | 0 | admin |
+----+------------+------------------------------------+---------------+--------------------+--------------------------------------+---------------------+---------------------+-------------+--------------+
UPDATE wp_users Set User_pass = MD5('password') Where id = 1;Use this if you wanna change the login name.
UPDATE wp_users Set User_Login = 'admin' Where id = 1;cd var/www/html
sudo nano wp-config.php
sudo nano wp-settings.php