Moving wp from a server to another, with different administrator

The easiest way around this is probably to reset the Admin password on the old Database. If you have PHPMyAdmin or a very similar DB admin interface, do the following:

  1. Import the old database.
  2. Open the user’s table, usually called ‘wp_users’.
  3. Find the user you wish to change the password for, and replace the contents of the ‘user_pass’ field with a plain text password. i.e “mypassword”.
  4. IMPORTANT: WordPress expects the password to be hashed as MD5. So before saving the record, set the ‘Function’ dropdown to ‘MD5’. See screenshot:

enter image description here

  1. Save the record and try to login.

If you don’t have PHPMyAdmin or similar and want to set the password manually in a SQL dump file, you can generate an MD5 hash of a plain text password in several ways:

  1. If you’re on Mac/Linux, do the following in terminal:
    openssl md5 <<< mypassword

  2. You can use an online generator

Related Posts:

  1. How do I migrate blog post images from one domain to a new one?
  2. Most Flawless Way To Transfer from Dev to Prod [duplicate]
  3. Suggestions for WPMU Migration (advanced)
  4. WordPress does not detect all images in uploads folder?
  5. Redirect to another page using contact form 7? [closed]
  6. bulk deleting empty items in the media library
  7. Broken image links in media library after restore
  8. Convert entire media library to WebP, delete original images and update references
  9. Change the default-view of Media Library in 3.5?
  10. Get All Images in Media Gallery?
  11. How do I select an image from Media Library in my plugin?
  12. Media Library plugins for better file management? [closed]
  13. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  14. How to add subfolders in media library for better organisation?
  15. How to display .ico files in the media library
  16. List of available events for wp.media
  17. print_media_templates not applied in media manager plugin
  18. Uploading Images to Media Library via wp_handle_sideload() fails
  19. WordPress 3.5 attachment_fields_to_edit and media_send_to_editor
  20. Bind event on Media gallery elements WordPress
  21. display image size in media library screen
  22. How to upload an image in the plugin’s options page
  23. image_size_names_choose filter doesn’t show
  24. Add class=”media_type” when media is inserted into editor
  25. Limit Media Library to Given Folder
  26. How do I ‘rebuild’ the WordPress Media library after transfer to new host?
  27. Proper way to hook wp_get_attachment_url or any other way to change that url in media library
  28. Best way to import users, post and categories from an external database
  29. How can I list URLs of all audio files within my media gallery?
  30. Migrating to HTTPS only, most media library links need updating?
  31. Failing to open advanced-cache.php which is breaking Media Library
  32. Add more rows on media picker
  33. How to transfer changes from test environment to live site?
  34. Filter pictures in the media library [closed]
  35. WP 3.5 media uploader API set selected item
  36. Is there a way to delete images from the Media Library programatically?
  37. Add file name column to media library
  38. Migrating WP site to another URL
  39. Uploads folder only showing files up to the letter “P”
  40. Media import failed in the WordPress importer
  41. Multi-site error wordpress after migration
  42. query that alternates text posts with images from media gallery
  43. Altered Media Library URLs
  44. Import all media referenced in posts
  45. Can multiple sites under one folder structure share media directories?
  46. Unable to delete images in Media Library
  47. Site migration and how to write internal links with migration in mind
  48. WordPress Media Delete Logs
  49. Organizing the Media Library for Cleanup
  50. WordPress not using edited image
  51. WooCommerce – Adding Product Attributes to CSV Export
  52. How to display the date a directory folder on ftp was modified
  53. Media library images “missing” after migrating them using SQL
  54. When I’m in post editor and click on ‘Add media’, why won’t it load the media library with this code?
  55. Export to WXR for pages containing script and iframe tags
  56. Is it possible to get an exported WP site in a zipped folder up and running? [closed]
  57. How to access media library?
  58. Migrate bbpress content to posts
  59. how to setup user access media library?
  60. How can I add a Description column to the media library browser screen?
  61. Get filenames of available image sizes
  62. How can I create more “create attachment” custom field – any idea?
  63. Create gallery doesn’t show uploaded images
  64. Media Library not showing images when adding to Posts (but retrieving image info via ajax)
  65. WordPress 3.5 Media Manager – Change loaded image Size [duplicate]
  66. Change the default-view of Media Library in 3.5?
  67. How use Videos from another directory?
  68. Media Manager 3.5 custom options
  69. Remove (Unattached) Attach from “Uploaded to” in Media Library
  70. Host Images from Link
  71. Uploading pictures to the Media Library: “Specified file failed upload test.”
  72. Use the “Media Library” in Frontend
  73. The issue of redirecting my site to a new domain
  74. Why is my upload / Select media library button empty?
  75. How do I set up a test environment in a sub-folder?
  76. WordPress Media Library
  77. All the Images in Media Library is showing broken links
  78. Create media library feed
  79. Store images and videos category wise and fetch them in json format
  80. Add Filename Colum to Media Library
  81. How to continuously developing a WP site that is already deployed in production without damaging it during development
  82. create a user’s owned folder on user registration
  83. 2 or more WordPress instances (Live vs Staging Test site) –> access 1 uploads.domain.com — images holder – see images in Media Library
  84. media library contains corrupt doubles
  85. cannot export data from CPT UI (books)
  86. How to bulk edit taxonomies for attachments
  87. How can I change the page title of PDFs opened from a WordPress link which use the browser’s viewer?
  88. wp cli media commands not working
  89. Files showing in link but cannot be found in the upload directory
  90. Does WordPress import export tool keeps the file hosted on the old website?
  91. Block non logged in users from accessing the media library
  92. Remove Edit Attachment Button in WordPress Mediathek -> see Screenshot
  93. in classic editor, is there a way to add media lib files to the content search when creating a link?
  94. Editing alt text in media library
  95. Unable to upload media files: Maximum upload file size: 0 B [closed]
  96. “Media Library” shows as empty, despite images being present
  97. How to search all the photos on my site for possible copyright violations
  98. I’m planning to offload my WordPress Media Library to a CDN? Would you recommend it, and why (or why not)?
  99. Adding a folder to word press Media Library
  100. Will WP-CLI “wp media regenerate” delete the changed thumbnail sizes by default?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)