Skip to content
Read For Learn
Read For Learn
  • Database
    • Oracle
    • SQL
  • C
  • C++
  • Java
  • Java Script
  • jQuery
  • PHP
Read For Learn
  • Database
    • Oracle
    • SQL
  • C
  • C++
  • Java
  • Java Script
  • jQuery
  • PHP

Finding the original login information in the database

Jacob Peatie is quite right (as always) – that said the following may help (your qn is unclear I’ve no idea what an”AD” plugin is and how it locks you out)

Check your wp_user table. Users have numeric IDs, passwords, email addresses etc. ID is incremented for each new user – on install first user (admin) will have an ID of “1”. You cannot recover clear password but you can edit (back-up table first) the email to one of yours (maybe enabling you to be emailed reset options by AD plugin?), and/or change password using reset instructions mentioned by Jacob.

If ID “1” does not exist: (Often the first action on a new install is to create a new admin usually ID “2” or other low number, and then delete the original admin with ID “1”.) Then one of the low number ID’s is likely to be your “primary” admin for “AD” and can be similarly edited.

I don’t know what the AD plugin does or your issues; there are probably simpler solutions such as just adding a new admin user and/or disabling the “AD plugin” by deactivating via WP dashboard, or by renaming the directory where plugin is installed.

Update following comment:

On Multisite you can identify super admins from “site_admins” in wp_sitemeta table – you will still need to refer back to wp_users table.

You could also try editing database to make your own WP user a super admin (I assume the plugin won’t reset you to non admin). Edit wp_meta to change you to an admin (see step 4 here); and then edit wp_sitemeta table to similarly add your user to site_admins serialized data.

An alternative approach would be to identify the “primary super admin” username which should match an account and email address on your servers, if active contact the user, if not, reset the password to gain access to MS and WP as admin (I assume plugin access is not affected by resets).

However; I suspect the bigger issue will be maintain user access to WP when migrating from old to no, or new, plugin.

I doubt if I’ll be able to suggest anything more I have little experience of MS Server and effectively none of AD.

Related Posts:

  1. Login in WordPress using external database data
  2. Finding the login page from database?
  3. How do I get WordPress login to ignore the password input if a particular username is used?
  4. Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
  5. Two websites one database, administrator not working on second website
  6. Database Table for customer user
  7. Permit Login if table row exists
  8. Auto login subdomain from main domain on single sites with different DB
  9. Logins from WP users table use on another page
  10. Is it possible to rebuild the website while not accesseing the original database?
  11. Recovering the table wp_usermeta from users
  12. Unable to login to a https website via the app after changing from http
  13. How to protect my credentials on my clients website
  14. How do you query for “is not null” in Mongo?
  15. Database synchronization between dev/staging and production
  16. Multiple developers / editors working on a site in progress
  17. WordPress Database lost auto increment
  18. Count & Display Database Queries
  19. How to integrate custom database table in WordPress and using WordPress functions
  20. How to use “TRUNCATE TABLE” MySQL statement?
  21. delete_option() and update_option() returning false
  22. How to change option recently_edited?
  23. Export wordpress table to excel
  24. When importing database, it shows error
  25. How to close wpdb connection? [duplicate]
  26. Meta query interfering with orderby relevance
  27. How can a Firebase user registration and login be integrated into a WordPress site?
  28. save new data to wp_options non-post form
  29. Strange Deadlock database error for the query “Delete From wp_options”
  30. Strange characters on wordpress site – Not UTF8 Issue
  31. WordPress showing install screen after max_questions error
  32. Connect to live db whilst working locally
  33. PHP variable in WordPress database query
  34. Differences between add_post_meta and update_post_meta
  35. Why do wordpress store pages/posts within the database instead of files? [closed]
  36. Insert custom data to custom table on wordpress database
  37. How does WordPress store data?
  38. Query WordPress database by registered date and role
  39. Merging WordPress posts from different databases
  40. Select Multiple meta_value from WP DB; Single Query
  41. Is it possible to split database tables using HyperDB?
  42. Show content from database
  43. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  44. “Error establishing a database” connection on some sites
  45. Is it necessary to sanitize wp_set_password user input?
  46. change wp user status from wp_users table
  47. WordPress is not creating table in database after activating plugin,
  48. Is MariaDB’s Aria storage engine suitable for WordPress?
  49. Difficulty importing my live site to local
  50. How do I delete these post types in my WordPress database?
  51. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  52. How Yoast SEO plugin works with variable %%name%%?
  53. What would Repair and Optimize WordPress Database do?
  54. Move out of sync posts from one database to another
  55. MS Access to manage WordPress Database
  56. How to fix database error duplicate entry
  57. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  58. WPDB SQL query with prepare() returning variable, not db value
  59. Get value form wordpress database
  60. Why user_pass column in wp_users table is varchar(64)
  61. Why this query is not showing any result on wordpresss home page?
  62. How to migrate a database from a server to another
  63. How to display content from external db with relevant urls
  64. Is there an easy way of exporting posts with their category already asigned and pictures from localhost?
  65. Connect to another WP install and grab post based on custom field
  66. how to count click tab menu and insert to database
  67. Adding prefix to WordPress database tables breaks admin capabilities?
  68. What is the best way to resurrect and update my old WordPress site?
  69. Using $wpdb | checking entered email against existing emails in db
  70. content disappearing minutes after it’s published
  71. Lost in trying to create user database system
  72. What is the most efficient way to reset a WordPress site?
  73. wp-cli: Error establishing a database connection: undefined constant DB_USER
  74. Add pdf to a website
  75. Optimizing function that automatically creates internal links based on post title string
  76. Outputting query results
  77. Help With a Large WordPress Based MySQL Database on Shared Hosting
  78. Can two domains use the same database?
  79. _wp_attachment_metadata is not being added to database when PDF files uploaded
  80. adding user_id and name to a separate table whenever a user register based on role
  81. How do I loop/iterate through posts to edit all img tags?
  82. User saved through WordPress backend does not show up in database table users
  83. How to edit posts/pages without making the change live?
  84. How to optimise this database query?
  85. How to retrieve user data based on role using SQL?
  86. using wordpress login details for other website / application / forum?
  87. Adding featured for post using database
  88. get_the_terms is not working
  89. Store id from database query in cookie
  90. Split database on large site?
  91. Store the wordpress “featured image” under »wp_posts« Database table
  92. Return image urls with specific base string?
  93. What WordPress file is saving new users to database
  94. wordpress database error
  95. Link to handle $_GET request
  96. WordPress sync with phpbb
  97. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  98. Database Errors since site updated to WordPress 6.4.3
  99. $wpdb->update is not working until next page refresh. Is there one more step?
  100. Combining two select posts from mysql – to get least viewed posts
Categories Database Tags database, login
how to make members list directory through wordpress post custom meta key.
Remove YoastSEO meta description from output/source [closed]

Recommended Hostings

Cloudways: Realize Your Website's Potential With Flexible & Affordable Hosting. 24/7/365 Support, Managed Security, Automated Backups, and 24/7 Real-time Monitoring.

FastComet: Fast SSD Hosting, Free Migration, Hack-Free Security, 24/7 Super Fast Support, 45 Day Money Back Guarantee.

Recent Added Topics

  • Bug in translation system: load_theme_textdomain() returns true, files are available and accessible but the language defaults to english
  • Custom Elementor controls not appearing in the widget Advanced tab using injection hooks
  • Get the name of the template/*html file used
  • Trying to Add Paging to Single Post Page
  • Sharing media files between live and staging servers
  • How to display the description of a custom post type in the dashboard?
  • Critical error on image display
  • Copying WP data and files into new install?
  • How to determine the DirectAdmin WordPress backup date?
  • How to get list of ALL tables in the database?
© 2026 Read For Learn
  • Database
    • Oracle
    • SQL
  • algorithm
  • asp.net
  • assembly
  • binary
  • c#
  • Git
  • hex
  • HTML
  • iOS
  • language angnostic
  • math
  • matlab
  • Tips & Trick
  • Tools
  • windows
  • C
  • C++
  • Java
  • javascript
  • Python
  • R
  • Java Script
  • jQuery
  • PHP
  • WordPress