cannot access wp-admin after options table crash and repair

I think you have lost your Admin Privileges. Please run following SQL query and login to WP Admin using newly created WP ADMIN. 

INSERT INTO `databasename`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES ('4', 'demo', MD5('demo'), 'Your Name', '[email protected]', 'http://www.test.com/', '2011-06-07 00:00:00', '', '0', 'Your Name');


INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '4', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');


INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '4', 'wp_user_level', '10');

New Temporary Admin Details that you can delete later :

Username : demo
Password : demo

Related Posts:

  1. Can’t update database after wordpress update from 3.8.1 to 4.4.1
  2. Add search Value to wp_list_table pagination
  3. Why are no posts showing despite my apparently correct DB restoration?
  4. Retrieve data from the database to table such as comments in the admin control panel
  5. Adding prefix to WordPress database tables breaks admin capabilities?
  6. Is my way to change WordPress server is correct?
  7. Custom Post Type not showing anything added by code anymore?
  8. WordPress site migration – locked out of admin area
  9. WordPress Migration – Issue with admin panel changes
  10. WordPress URL error for links
  11. Recover Same WordPress Admin Password
  12. Database Queries are crashing the server
  13. How to protect my credentials on my clients website
  14. phpMyAdmin – Error > Incorrect format parameter?
  15. Difference between partition key, composite key and clustering key in Cassandra?
  16. How SID is different from Service name in Oracle tnsnames.ora
  17. What is a relation in database terminology?
  18. Why is my database import losing text widget data?
  19. Why WordPress choose data serialization over json_encode?
  20. Are There Any Plans for WordPress to Support Databases Other Than MySQL?
  21. Reset Post IDs to less than 64bit integer
  22. how can get database name in wordpress?
  23. Does WordPress use the InnoDB engine for MySQL by default?
  24. Best way to import users, post and categories from an external database
  25. Performance tips for a large user base [closed]
  26. Long option names fail silently?
  27. wp_options is GB in size
  28. Upload files – total size limit – WordPress/Contact Form 7
  29. Relationship between performance and database size
  30. Why does WordPress rely on an fully qualified site_url with a 15-step plan for moving a site?
  31. WordPress and automated MySQL backups to a different host
  32. Scheduling posts in database
  33. Size article thumbnails and retrieve them directly from database
  34. Should I be able to run two different “close” code versions of wordpress with the same DB
  35. how to store arrays into a database
  36. How can I create a Bible search engine via WordPress? [closed]
  37. Error establishing a database connection; After importing DB & Theme
  38. Where are WP_Errors Saved
  39. Get all images from this database table
  40. Delete transients in website
  41. Error establishing database connection – high traffic?
  42. Bulk-create posts from SQL database
  43. I am switching laptops. I host my WP server through MAMP. I want to transfer [closed]
  44. How can i customize the export personal data file?
  45. Is there a solution to auto-post data to a WP post from a database
  46. Auto login subdomain from main domain on single sites with different DB
  47. Cleanup: best way to remove WooCommerce comments from the wp_comments table
  48. Logins from WP users table use on another page
  49. How to use default WP form elements to interact with custom DB table?
  50. SSO system between 2 WordPress installs on different servers
  51. is $wpdb->get_results() safe enough
  52. Does post_meta data need to be unserialzed?
  53. Can’t update WordFence Options, clear data manually
  54. Is it possible to have more than 1 MySQL database in my WordPress blog?
  55. How to fetch records from database WordPress
  56. restore a db after bad backup
  57. Best practice to import user base (subscribers) from one website to another?
  58. AJAX wp-mysql running too slow
  59. Some weird users in database
  60. Delete/Replace words from X to Y in post content
  61. Location of image metadata on my server
  62. How to create more than one new wpdb object?
  63. Multiple WordPress sites installs sharing the same database but with different content and domains
  64. Brandoo WordPress Unable to Update to WordPress 4.2.2
  65. Remote database -> massive response time increase?
  66. Is it good practice to import/export a blog to test a redesign?
  67. Getting value from database table depending on field value
  68. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  69. Secure way to use name_save_pre?
  70. wpdb->insert not inserting first variable
  71. Database tables for sports betting integrated in WordPress
  72. New installation fatal error in 5.9.3 at edit or create entry
  73. Storing transients giving database error
  74. I want to replicate a wordpress website over multiple servers
  75. Is there anyway to split posts to different databases?
  76. wp-cli + valet: “Error establishing a database connection”
  77. How to edit custom table data in frontend
  78. local wordpress broke after changing URL
  79. Unable to login to a https website via the app after changing from http
  80. mysqli_query(): MySQL server has gone away for Curl Request
  81. Is it safe to add INDEX to a column in WordPress database?
  82. WP website showing blank page after moving from subdomain to main domain
  83. create a table using user meta custom data
  84. WPCLI search and replace in a particlar site dir effect another site-dir
  85. How do I find out from my database what version of WordPress I need?
  86. How to create a database table?
  87. Extracted CSV as Array for Custom Query Loop
  88. Hang Up Followed By Can’t select database
  89. Database error after importing WordPress
  90. Send data to database after redirect (and popping out of iframe)
  91. Pulling values from a sepcific row in table
  92. import (migration) user database to wp-users
  93. Create hundreds of users with just ID in phpMyAdmin
  94. What is best for saving lot of extra detail of user?
  95. Insert Extra fields added in the front end registration form to DB
  96. How to create a table [closed]
  97. WP Multisite Users Not Linking
  98. Is it possible to have a form page for logged-out users where values are stored persistently?
  99. Naming conventions for database tables
  100. Database not loading after transfer via phpmyadmin