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

Posted October 18, 2020 1.5k 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.

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

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!

  • 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

    • 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!