Both VPS and domain changed but Database URL stayed the same and PHPmyadmin inaccessible to change it

The site and home URLs aren’t serialized, if you access to the database export, you can change them directly in that file with a text editor.

You can also override the database values temporarily in wp-config.php with some defines:

define('WP_HOME','http://example.com');
define('WP_SITEURL','http://example.com');

Related Posts:

  1. What is this JavaScript “require”?
  2. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  3. get_results using wpdb
  4. How can I make a WordPress database portable and url independent?
  5. wpdb->insert multiple record at once
  6. How to migrate a HTTPS WordPress installation to localhost?
  7. How to stop WordPress using utf8mb4_unicode_520_ci collation?
  8. How to monitor server for error establishing a database connection
  9. WP_Options ID high
  10. Default WordPress settings API data sanitization
  11. Fatal error: Call to undefined function dbDelta()
  12. Connect to remote database using Localhost install
  13. remove missing image attachments
  14. Transient RSS feeds in wp_options not removed automatically?
  15. Best way to move live site local
  16. The revisions table in my database is at 70% capacity and growing. What should I do?
  17. WordPress for a very large website
  18. How to ensure data consistency in WordPress
  19. Database location in WordPress
  20. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  21. WP_list_table bulk_action get edit and delete
  22. How to display data from custom table in wordpress database?
  23. How to intercept update_option() before it saves data?
  24. Change SQL get_results to search for posts with custom term in custom taxonomy
  25. wpdb query on custom table not working [closed]
  26. How to diagnose and keep in check encoding issues?
  27. Add search Value to wp_list_table pagination
  28. stdObject stored in database. How does one convert it to usable format?
  29. I have a table I created, how do I make a form for a user to filter the data?
  30. Set Display Name to first and last name (phpmyadmin SQL Query)
  31. How to fix unchanged URLs in Database after running serialized search and replace script?
  32. wp_redirection_404 table has grown to 7GB
  33. Does WordPress ever need multiple databases?
  34. WordPress database error – Error in SQL syntax – I can’t identify any error?
  35. Multiple wp_options tables to share content across installs
  36. Merging two wp_posts tables while avoiding duplicates
  37. Merging two databases without borking it
  38. Is there a smart way to obtain a list of only some selected user meta data?
  39. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  40. Permit Login if table row exists
  41. Make an Items attribute searchable (taxonomy using existing attribute)
  42. How Yoast SEO plugin works with variable %%name%%?
  43. What would Repair and Optimize WordPress Database do?
  44. Move out of sync posts from one database to another
  45. MS Access to manage WordPress Database
  46. Saving zero as meta value
  47. Query multiple tables at once?
  48. Custom WordPress Table wpdb
  49. $wpdb->get_results($wpdb->prepare(… You have an error in your SQL syntax;
  50. Transferring/Uploading Data from DB to WordPress
  51. How to convert srcset links from https to http?
  52. Can local WordPress installs share /wp-content/ folder and database?
  53. how to encyrpt DB_PASSWORD in wp-config
  54. Choosing http or https during manual installation of WordPress and database
  55. Stringing together content from different databases
  56. Delete all posts that do NOT have a specific tag
  57. Changing order of db results when encoding to JSON
  58. How to transfer from localHost to live but use the already existing database on the server?
  59. Safely store code(html/js..) into database
  60. Why does wp_links still exist in the db schema?
  61. can’t upgrade wordpress or install plugins, it seems to “think” it’s still on a local installation
  62. How not to display ALL items of a database
  63. How to get the records from start with A to G in php and mysql
  64. Link multiple user databases together?
  65. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  66. Set a cron job to delete a specific database table table every midnight
  67. Two separate wordpress installations at one domain
  68. Is there a way to edit the WP content database in an admin panel or external page?
  69. Is there any defects for using same database prefix in WordPress for multiple sites?
  70. Can we store password in without being hashing?
  71. SQL database import #1046 error
  72. How to import products in host instead of database on wordpress?
  73. Get all top categories, then only 3 posts for each
  74. I would like some help wth an SQL query to link posts with categories
  75. Error establishing a database connection in wordpress
  76. Where is the HTML-handler part in the wpdb class?
  77. next comment id number wordpress
  78. Want to update value in database. But it says update() on null
  79. Counting user’s comments – efficient way?
  80. Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
  81. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  82. Should I Use only wpdb Class to Write Custom Queries?
  83. Auto populate form fields based on serial input or pull listings from other websites?
  84. How to extract some part of WordPress full source code
  85. Error establishing a database connection for some files
  86. Hash user emails in database?
  87. Database Name Change
  88. Weird characters in title if it contain “ ”
  89. Share WordPress Database
  90. Where To Find bb_profile_data(); In bbPress?
  91. DB access blocked when initializing WP externally
  92. Saving data to database and exporting to excel
  93. Site does not work right, pages not showing up, even for root admin
  94. One information repeated on multiple locations on one site [closed]
  95. WordPress: Interact with Database Query Data and Login
  96. Showing Error(TAble already exist)
  97. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  98. SQL query to rewrite all media URLs to end with .webp
  99. Many images in wp-content/uploads folder that are not in Media Library
  100. Order of search results based off of a backend custom field and also in alpha order
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)