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

Cannot login to ADMIN even after changing password in phpmyadmin

From the WP Codex:

  1. Begin by logging into phpMyAdmin and clicking databases.
  2. A list of databases will appear. Click your WordPress database.
  3. All the tables in your database will appear. If not, click Structure.
  4. Look for wp_users in the Table column.
  5. Click on the icon for browse.
  6. Locate your Username under user_login
  7. Click edit (may look like a pencil icon in some versions of phpMyAdmin)
  8. Your user_id will be shown, click on Edit
  9. Next to the user_pass is a long list of numbers and letters.
  10. Select and delete these and type in your new password.
  11. Type in the password you want to use. Just type it in normally, but remember, it is case-sensitive.
  12. In this example, the new password will be ‘rabbitseatcarrots’
  13. Once you have done that, click the dropdown menu indicated, and select MD5 from the menu.
  14. Check that your password is actually correct, and that MD5 is in the box.
  15. Click the ‘Go’ button to the bottom right.
  16. Test the new password on the login screen. If it doesn’t work, check that you’ve followed these instructions exactly.

Related Posts:

  1. How can a Firebase user registration and login be integrated into a WordPress site?
  2. using wordpress login details for other website / application / forum?
  3. User content database [closed]
  4. How do I show data from gravity forms in my template? [closed]
  5. Delete tables from database when deleting plugin
  6. Is it bad practice to create own table for a plugin?
  7. How to Add an Index to Plugin Database table
  8. How can I delete orphan keys in WordPress database tables?
  9. Is there a plugin that will override the “Error establishing a database connection” message? [closed]
  10. How to delete all records from or empty a custom database table?
  11. What are these entries in the database? Looks similar to JSON
  12. WordPress sharding: which multi-DB plugin to use?
  13. Creating two database tables via plugin
  14. How to properly insert data into custom table via plugin
  15. Login with OpenID, similar to Stack Exchange sites?
  16. How can I make an Ajax login form work with FORCE_SSL_ADMIN enabled?
  17. How does WordPress handle MySQL row lock errors?
  18. How to make sense of the active_plugins option_value to enable and disable certain plugins from the database?
  19. How to empty wordpress custom post Database table
  20. insert data in database table from plugin with WP3.1
  21. Simple form that saves to database
  22. Change success message in plugin Theme my login
  23. How to run Two WordPress blogs with different themes and with single database and same content
  24. $wpdb->get_results leaking memory
  25. How to get Login Error messages on a custom template
  26. Plugins or Tutorials for displaying data from SQL-db on WP-page? [closed]
  27. Insert query inserts 2 entries, should insert 1
  28. Using Vagrant for customizable WordPress Multi-sites [closed]
  29. Is it a bad practice to go directly to the mysql database while developing a plugin?
  30. Updating WordPress – the best approach (updating wp core, plugins and db)
  31. How do I check what plugins are enabled via the database?
  32. How to store ACF custom fields data in a custom table
  33. Can I explicitly specify ENGINE=InnoDB in WordPress?
  34. Bad Request (Invalid Hostname) on working server, database problem
  35. How to get user-meta from Social Login registered users?
  36. Plugin Not Working, But Only On GoDaddy Hosted site
  37. Auto login using Active Directory and Windows Authentication
  38. Create custom column in post table in wordpress
  39. Custom database or Custom Post Types?
  40. Which hook should be used to validate custom form fields on the login form?
  41. How can I make content disappear when a user logs in?
  42. How to create custom LOGIN and REGISTRATION forms?
  43. Tracking last login and last visit
  44. login to wordpress with Get variables instead of Post
  45. Custom database table for plugin not creating on activation
  46. WordPress plugin DB upgrade
  47. How to update widget_text in the wp_options table
  48. Get the last post ID
  49. Prevent Brute Force Attack
  50. Add agenda items and notifications
  51. How to count number of records found in a database table?
  52. Should I global $wpdb outside of any of my plugin’s functions scope?
  53. prefix table and plugins
  54. Login with email (WP Modal Login)
  55. Taking WordPress table prefixes into account
  56. Changing BIGINT to INT
  57. Check if the front end user is log in or not
  58. wordpress custom login successful redirect hook
  59. WordPress register_activation_hook table creation not working
  60. How to add Edit | Delete button on rows?
  61. How to create a word press user with hashedpassword
  62. The plugin generated x characters of unexpected output, $wpdb not defined
  63. WordPress with CAS+LDAP and standard WP accounts
  64. how to show database content in wordpress post
  65. What is the easiest way to implement cascading database upgrade for my plugin?
  66. Is there any good tutorial to write custom login, registration and password recovery forms? [closed]
  67. clean wp_options table unused rows
  68. Ajax with jQuery UI dialog not working
  69. How to edit/delete single row items in a table on my own menu page
  70. Storing Email Account Passwords for SMTP Mailing for a WordPress Plugin
  71. Remove obsolete plugins artifacts from database tables
  72. Use WordPress with a custom OAuth2 provider
  73. WordPress login with Phone Number [closed]
  74. If I delete plugins via FTP are settings kept in DB?
  75. greatest() function returns undefined property
  76. Get total number of comment of the posts written by an author
  77. Cannot access wp-admin after disabling all plugin
  78. wp_authenticate but not logged in
  79. How to write one comment and publish on every post using database or plugin?
  80. Force [wordpress_social_login] shortcode to display where it is embedded [closed]
  81. Is the wordpress user-model changed in wpmu?
  82. Default Plugin Settings Not Writing to Database
  83. Creating Tables on Network Activation
  84. Make id column as AUTO INCREMENT on plugin activation
  85. What kind of data is that?
  86. Unable to create new database table upon plugin activation using dbDelta
  87. Where to hook my plugin’s action
  88. Embed a Google Sheet as you view it in a separate tab?
  89. How to determine what is generating large amount of database queries?
  90. Building an email signup form. Where should the information be saved in the DB?
  91. Saving Custom Post types and fields to a custom table
  92. Retrieving a Value from a wp-database
  93. How do i login when i cant access wp-login.php?
  94. Need help restoring my WordPress blog
  95. WP plugins for building a database?
  96. Where does WordPress store plugin (enabled/disabled) status for multisite?
  97. Why is my staging subdomain not sending wordpress_logged_in cookies?
  98. When to use action hooks and plugins
  99. Single central login for front end users from any site
  100. Plugin Options Not Saving to Database in WP 4.5
Categories plugins Tags database, login, plugins
WooCommerce restore stock on order cancel
Moving wordpress site to subpage of another site

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