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. WordPress Admin login problems- PLEASE HELP [closed]
  15. What is an ORM, how does it work, and how should I use one? [closed]
  16. What is the difference between an ORM and an ODM?
  17. What is this JavaScript “require”?
  18. Rename a table in MySQL
  19. How should I tackle –secure-file-priv in MySQL?
  20. What is this JavaScript “require”?
  21. What is “Advanced” SQL?
  22. What’s the difference between identifying and non-identifying relationships?
  23. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  24. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  25. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  26. What are the differences between B trees and B+ trees?
  27. MySQL SELECT increment counter
  28. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  29. Example of a strong and weak entity types
  30. Oracle SQL query for Date format
  31. phpMyAdmin – Error > Incorrect format parameter?
  32. Strange Characters in database text: Ã, Ã, ¢, â‚ €,
  33. Difference between partition key, composite key and clustering key in Cassandra?
  34. How SID is different from Service name in Oracle tnsnames.ora
  35. What is a relation in database terminology?
  36. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  37. Database vs File system storage
  38. Can I have multiple primary keys in a single table?
  39. Exclude Statement in SQL
  40. How do you query for “is not null” in Mongo?
  41. What is a file based database?
  42. Is it fine to have foreign key as primary key?
  43. Storing Images in DB – Yea or Nay?
  44. Using wpdb to connect to a separate database
  45. how to Optimize WordPress database for 10 million post? [duplicate]
  46. MySQL Database User: Which Privileges are needed?
  47. Why is my database import losing text widget data?
  48. Database synchronization between dev/staging and production
  49. Keeping WP database synced across multiple developers using git
  50. WPDB Insert or if exists Update
  51. Multiple developers / editors working on a site in progress
  52. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  53. get_results using wpdb
  54. Will it break my site if I delete all transient records in wp_options table?
  55. Checking if Database Table exists
  56. Why WordPress choose data serialization over json_encode?
  57. What’s the simplest way to backup my WordPress database?
  58. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  59. $wpdb won’t insert NULL into table column
  60. Relaunch 4.2 utf8mb4 database upgrade
  61. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  62. Safest way to bulk delete post revisions
  63. Please explain how WordPress works with MySQL character set and collation at a low level
  64. Solution for database version control and deployment?
  65. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  66. How many users can WordPress handle?
  67. Get error messages when $wpdb->insert() returns false?
  68. Detecting errors generated by $wpdb->get_results()
  69. Staging sites, how do you manage synchronising updates in the DB?
  70. Does dbDelta delete columns as well?
  71. How to get the post publish date outside the loop?
  72. MariaDB as a backend database
  73. wpdb update add current timestamp not working
  74. Site stuck in “Database Update Required” loop
  75. How to fetch Data in WordPress using MySQLi or $wpdb
  76. WordPress Database lost auto increment
  77. Count & Display Database Queries
  78. Connect to database using wordpress wp-config file
  79. How can I make a WordPress database portable and url independent?
  80. Are There Any Plans for WordPress to Support Databases Other Than MySQL?
  81. wpdb->insert multiple record at once
  82. How to migrate a HTTPS WordPress installation to localhost?
  83. Two WordPress sites sharing the same content
  84. How to integrate custom database table in WordPress and using WordPress functions
  85. Reset Post IDs to less than 64bit integer
  86. WP Multisite: load content from site X on site Y
  87. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  88. Custom form that store input in database
  89. Restoring WordPress posts from database only
  90. What is the purpose of the option name hack_file in the options table?
  91. Where can I find the database changes between WordPress versions?
  92. Automate WordPress Database Upgrade
  93. Database connection close
  94. WordPress database error with latest WP – “WP_termmeta doesn’t exist”
  95. WordPress database scalability from the code perspective
  96. WordPress Unit Testing – Cannot Create Tables
  97. Using transients in conjunction with memcached
  98. Displaying content from one WP site on separate WP site
  99. Lost the `wp_options` table: what’s the best way to restore the site?
  100. How to define composite keys with dbDelta()
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
  • Post Navigation Elementor
  • Custom Elementor controls not appearing in the widget Advanced tab using injection hooks
  • WPFacet multiple loop displaying duplicate content
  • Get the name of the template/*html file used
  • Fix: WordPress.DB.PreparedSQL.NotPrepared Plugin Check (PCP)
  • Removing unnecessary CSS and JS code from wp_head()
  • hexagonal image gallery. Am I on the right track? [closed]
  • Trying to Add Paging to Single Post Page
  • Sharing media files between live and staging servers
© 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