Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Duplicate Website Question Question
How did my database got hacked ? Question Question

Question

How To Fix database error datasbase.wp_user doesn't exist for query

Posted October 18, 2020 976 views
WordPressDatabasesOpenLiteSpeed WordPress 1-ClickDigitalOcean Managed MySQL Database

I have tried to login in WordPress through WP-CLI but as I run wp-login, It shows “database error database.wp_user doesn’t exist for query” and a bunch of other lines and I become unable to login.
What can I do to fix it, I appreciate any help from you.

Add a comment
newwayelegant
By:
newwayelegant

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Duplicate Website Question Question
How did my database got hacked ? Question Question

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
2 answers
bobbyiliev October 18, 2020

Hi there @newwayelegant,

To me it looks like that either your database details are not correct in your wp-config.php file, you need to make sure that you use the correct database name, database username and password.

If this is not the case, then it’s possible that the database is not complete. If this is a new installation what you could do is create a new blank database and let the WordPress install script create the tables from scratch.

Hope that this helps!
Regards,
Bobby

Reply Report
  • newwayelegant October 18, 2020

    I did that but I found from one of the digital ocean that my 7 database tables are corrupt and I need to fix them and The only way left to fix is restoring from the backup database so I did it and I an error #1067 - Invalid default value for ‘userregistered’ it is in “wpuser” table, How can I fix it

    Reply Report
    • bobbyiliev October 19, 2020

      Hi there @newwayelegant,

      In this case, I believe that the way to go would be to get a fresh new export of your database from your old server, then drop the database on your DigitalOcean server and import the fresh export.

      In most cases a database would get corrupt if the server runs out of disk space or RAM, I could suggest making sure that you have enough of disk space before proceeding with the import.

      Hope that this helps!
      Regards,
      Bobby

      Reply Report
newwayelegant October 18, 2020
[deleted]
Reply Report

Related

Looking for something else?

Ask a new question Search for more help