title: Server configuration issue: Wordpress won't display posts after migration
body: <p>I have just finished migrating a WordPress website to a freshly setup Linode, using the duplicator plugin, however, it seems that WordPress can't connect to the database properly as it doesn't display any posts or allow admin login despite using correct credentials. </p>
  
  <p>I have tested the duplicator plugin locally using MAMP and everything worked perfectly. The posts displayed correctly and I was able to log-in. 
  I dont think this is the duplicator plugin. But rather it is the server being misconfigured. </p>
  
  <p>I've followed this tutorial to setup the necessary permissions and create a database <a href="https://www.linode.com/docs/websites/cms/how-to-install-and-configure-wordpress/" rel="nofollow noreferrer">Linnode tutoral</a></p>
  
  <p>The only difference is that I used Ubuntu 16.04 and used duplicator to setup the database.</p>
  
  <p>Checking the database seems to have been duplicated correctly as all the tables and data are present. It seems they are just not being read.</p>
  
  <p>What other server configuration issues may I be missing here?</p>
  
  <p>Update:
  Get the following error log from the duplicator plugin:</p>
  
  <pre><code>INSERT INTO `wp_posts` VALUES("138", "2"...]
  **ERROR** database error write 'Table 'roses.wp_posts' doesn't exist' - [sql=INSERT INTO `wp_posts` VALUES("139", "2", "2014-12-12 11:13:53", "2014-12-1...]
  **ERROR** database error write 'Table 'roses.wp_posts' doesn't exist' - [sql=INSERT INTO `wp_posts` VALUES("140", "2", "2014-12-12 23:22:14", "2014-12-1...]
  **ERROR** database error write 'Table 'roses.wp_posts' doesn't exist' - [sql=INSERT INTO `wp_posts` VALUES("141", "2", "2014-12-12 23:22:14", "2014-12-1...]
  **ERROR** database error write 'Table 'roses.wp_posts' doesn't exist' - [sql=INSERT INTO `wp_posts` VALUES("4", "3", "2014-11-10 21:35:15", "2014-11-10 ...]
  **ERROR** database error write 'Table 'roses.wp_posts' doesn't exist' - [sql=INSERT INTO `wp_posts` VALUES("5", "3", "2014-11-10 21:35:21", "2014-11-10 ...]
  **ERROR** database error write 'Table 'roses.wp_posts' doesn't exist' - [sql=INSERT INTO `wp_posts` VALUES("190", "2", "2014-12-19 14:48:05", "2014-12-1...]
  **ERROR** database error write 'Table 'roses.wp_posts' doesn't exist' - [sql=INSERT INTO `wp_posts` VALUES("184", "2", "2014-12-19 01:15:23", "2014-12-1...]
  </code></pre>