WordPress database error : wp_users’ doesn’t exist

You are developping your WordPress website and suddently, you have a database error. Errors can be listed below :

wpta_users: Table ‘wp_users’ doesn’t exist
wpta_usermeta: Table ‘wp_usermeta’ doesn’t exist
wpta_posts: Table ‘wp_posts’ doesn’t exist
wpta_links: Table ‘wp_links’ doesn’t exist
wpta_options: Table ‘wp_options’ doesn’t exist
wpta_postmeta: Table ‘wp_postmeta’ doesn’t exist
wpta_terms: Table ‘wp_terms’ doesn’t exist
wpta_term_taxonomy: Table ‘wp_term_taxonomy’ doesn’t exist
wpta_term_relationships: Table ‘wp_term_relationships’ doesn’t exist
wpta_termmeta: Table ‘wp_termmeta’ doesn’t exist

Or :

wp_users: Table ‘wp_users’ doesn’t exist in engine
wp_usermeta: Table ‘wp_usermeta’ doesn’t exist in engine
wp_posts: Table ‘wp_posts’ doesn’t exist in engine
wp_comments: Table ‘wp_comments’ doesn’t exist in engine
wp_links: Table ‘wp_links’ doesn’t exist in engine
wp_options: Table ‘wp_options’ doesn’t exist in engine
wp_postmeta: Table ‘wp_postmeta’ doesn’t exist in engine
wp_terms: Table ‘wp_terms’ doesn’t exist in engine
wp_term_taxonomy: Table ‘wp_term_taxonomy’ doesn’t exist in engine
wp_term_relationships: Table ‘wp_term_relationships’ doesn’t exist in engine
wp_termmeta: Table ‘wp_termmeta’ doesn’t exist in engine
wp_commentmeta: Table ‘wp_commentmeta’ doesn’t exist in engine

Or :

WordPress database error: [Table ‘wordpress.wp_users’ doesn’t exist]
SELECT * FROM wp_users WHERE user_login = login
WordPress database error: [Table ‘wordpress.wp_users’ doesn’t exist]
SELECT * FROM wp_users WHERE user_login = login
WordPress database error: [Table ‘wordpress.wp_users’ doesn’t exist]
SELECT * FROM wp_users WHERE user_email = ‘mon_mail@hebergeur.fr’
WordPress database error: [Table ‘wordpress.wp_users’ doesn’t exist]
SELECT ID FROM wp_users WHERE user_nicename = login AND user_login != login LIMIT 1
WordPress database error: [Table ‘wordpress.wp_users’ doesn’t exist]
SHOW FULL COLUMNS FROM wp_users

New install

If this is your first setup of WordPress and you have this kind of error, you should ensure that your mysql database charsets is utf8mb4. If your database is under utf8_unicode_ci or another charsets, then you should change it, with phpmyadmin for example.

Error appear suddently

If your website worked well before and this kind of error appeared suddenly, then your database has a problem. It seems that your WordPress tables are no longer there.

The best solution here is to apply a backup from your website. If you have a full backup, remove your current tables from your database and add your backup.

Do it carefully. If you are not sure about what you are doing, you should contact an expert.