Title: Table doesn’t exist
Last modified: April 27, 2018

---

# Table doesn’t exist

 *  [1337mirth](https://wordpress.org/support/users/1337mirth/)
 * (@1337mirth)
 * [8 years, 1 month ago](https://wordpress.org/support/topic/table-doesnt-exist-10/)
 * I’m running CentOS7, apache 2.4, php7.0 using php-fpm and mariadb 5.5.56. The
   database is completely empty (except for the standard system tables) and the 
   DocRoot has a pristine copy of latest.tar.gz extracted to it and downloaded from
   [https://wordpress.org](https://wordpress.org). I create the database ‘blogs’
   exactly as described on [https://codex.wordpress.org/Installing_WordPress](https://codex.wordpress.org/Installing_WordPress)
   using the MySQL CLI commands. I then run the install script from [http://blogs-test.example.com/wp-admin/install.php](http://blogs-test.example.com/wp-admin/install.php).
   I then put in the database parameters and get the message that the connection
   was successful and that I can proceed. The next screen is a form to fill in the
   blog site title, email, misc. stuff as well as the temp password. I then get 
   the message that the install was successful and it immediately redirects me to
   [http://blogs-test.example.com/wp-login.php](http://blogs-test.example.com/wp-login.php)
   and I get a message “Error establishing a database connection”. The log files
   from the php-fpm/www-error.log state the following:
 * [27-Apr-2018 18:31:36 UTC] WordPress database error Table ‘blogs.wp_blogs’ doesn’t
   exist for query SELECT blog_id FROM wp_blogs WHERE domain IN ( ‘blogs-test.example.
   com’ ) AND path IN ( ‘/wp-login.php/’, ‘/’ ) ORDER BY CHAR_LENGTH(path) DESC 
   LIMIT 1 made by require(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘
   wp-settings.php’), require(‘wp-includes/ms-settings.php’), ms_load_current_site_and_network,
   get_site_by_path, get_sites, WP_Site_Query->query, WP_Site_Query->get_sites, 
   WP_Site_Query->get_site_ids
    [27-Apr-2018 18:31:36 UTC] WordPress database error
   Table ‘blogs.wp_site’ doesn’t exist for query SELECT wp_site.id FROM wp_site 
   WHERE wp_site.domain IN ( ‘blogs-test.example.com’, ‘example.com’, ‘com’ ) AND
   wp_site.path IN ( ‘/wp-login.php/’, ‘/’ ) ORDER BY CHAR_LENGTH(wp_site.domain)
   DESC, CHAR_LENGTH(wp_site.path) DESC made by require(‘wp-load.php’), require_once(‘
   wp-config.php’), require_once(‘wp-settings.php’), require(‘wp-includes/ms-settings.
   php’), ms_load_current_site_and_network, WP_Network::get_by_path, get_networks,
   WP_Network_Query->query, WP_Network_Query->get_networks, WP_Network_Query->get_network_ids
 * I get another message about wp_site not existing as well. (I replaced the actual
   domain with example.com in the above).
 * I’ve tried this several times all with the exact same errors. Any help will be
   greatly appreciated.
 * Thanks,
    Mike

Viewing 1 replies (of 1 total)

 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [8 years, 1 month ago](https://wordpress.org/support/topic/table-doesnt-exist-10/#post-10226799)
 * 1. As the root database user, create a database
 * `create database wpdb;`
 * 2. Create a user and assign to the database
 * `grant all on wpdb.* to 'wpdb_user'@'localhost' identified by 'arandompassword';`
 * Exit from the MySQL command line.
 * Edit wp-config.php for the WP site and put those values in for the DB_* defines.
    -  This reply was modified 8 years, 1 month ago by [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/).

Viewing 1 replies (of 1 total)

The topic ‘Table doesn’t exist’ is closed to new replies.

## Tags

 * [tables](https://wordpress.org/support/topic-tag/tables/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 1 reply
 * 2 participants
 * Last reply from: [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * Last activity: [8 years, 1 month ago](https://wordpress.org/support/topic/table-doesnt-exist-10/#post-10226799)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics