Body: <p>since yesterday i have been trying to setup Craft CMS for the first time, 
  but the installation fails and tells me to check the logs.</p>
  
  <p>The database account has all rights.</p>
  
  <p>(This is only a part of the log, but this should do)</p>
  
  <pre><code>2020-05-05 07:25:50 [-][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;port=3306;dbname=craftycoffee
  2020-05-05 07:25:50 [-][-][-][profile begin][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;port=3306;dbname=craftycoffee
  2020-05-05 07:25:50 [-][-][-][profile end][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;port=3306;dbname=craftycoffee
  2020-05-05 07:25:53 [-][-][-][info][yii\db\Command::query] SELECT *
  FROM `info`
  WHERE `id`=1
  LIMIT 1
  2020-05-05 07:25:53 [-][-][-][profile begin][yii\db\Command::query] SELECT *
  FROM `info`
  WHERE `id`=1
  LIMIT 1
  2020-05-05 07:25:53 [-][-][-][profile end][yii\db\Command::query] SELECT *
  FROM `info`
  WHERE `id`=1
  LIMIT 1
  2020-05-05 07:25:53 [-][-][-][error][craft\base\ApplicationTrait::getIsInstalled] There was a problem fetching the info row: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'craftycoffee.info' doesn't exist
  The SQL being executed was: SELECT *
  FROM `info`
  WHERE `id`=1
  LIMIT 1
  2020-05-05 07:25:53 [-][-][-][error][yii\db\Exception] PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'craftycoffee.info' doesn't exist in E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php:1293
  Stack trace:
  #0 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(1293): PDOStatement-&gt;execute()
  #1 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(1159): yii\db\Command-&gt;internalExecute('SELECT *\nFROM `...')
  #2 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(415): yii\db\Command-&gt;queryInternal('fetch', NULL)
  #3 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Query.php(274): yii\db\Command-&gt;queryOne()
  #4 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\db\Query.php(168): yii\db\Query-&gt;one(NULL)
  #5 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(620): craft\db\Query-&gt;one()
  #6 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(286): craft\web\Application-&gt;getInfo(true)
  #7 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\services\Sites.php(1138): craft\web\Application-&gt;getIsInstalled()
  #8 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\services\Sites.php(448): craft\services\Sites-&gt;_loadAllSites()
  #9 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Component.php(180): craft\services\Sites-&gt;setCurrentSite(NULL)
  #10 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(558): yii\base\Component-&gt;__set('currentSite', NULL)
  #11 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(107): yii\BaseYii::configure(Object(craft\services\Sites), Array)
  #12 [internal function]: yii\base\BaseObject-&gt;__construct(Array)
  #13 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass-&gt;newInstanceArgs(Array)
  #14 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container-&gt;build('craft\\services\\...', Array, Array)
  #15 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container-&gt;get('craft\\services\\...', Array, Array)
  #16 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\ServiceLocator.php(137): yii\BaseYii::createObject(Array)
  #17 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Module.php(742): yii\di\ServiceLocator-&gt;get('sites', true)
  #18 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(341): yii\base\Module-&gt;get('sites', true)
  #19 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(1238): craft\web\Application-&gt;get('sites')
  #20 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Request.php(185): craft\web\Application-&gt;getSites()
  #21 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(109): craft\web\Request-&gt;init()
  #22 [internal function]: yii\base\BaseObject-&gt;__construct(Array)
  #23 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass-&gt;newInstanceArgs(Array)
  #24 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container-&gt;build('craft\\web\\Reque...', Array, Array)
  #25 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container-&gt;get('craft\\web\\Reque...', Array, Array)
  #26 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\config\app.web.php(13): yii\BaseYii::createObject(Array)
  #27 [internal function]: {closure}()
  #28 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(524): call_user_func_array(Object(Closure), Array)
  #29 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(349): yii\di\Container-&gt;invoke(Object(Closure), Array)
  #30 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\ServiceLocator.php(137): yii\BaseYii::createObject(Object(Closure))
  #31 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Module.php(742): yii\di\ServiceLocator-&gt;get('request', true)
  #32 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(341): yii\base\Module-&gt;get('request', true)
  #33 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\web\Application.php(160): craft\web\Application-&gt;get('request')
  #34 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(1380): yii\web\Application-&gt;getRequest()
  #35 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(100): craft\web\Application-&gt;_preInit()
  #36 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(109): craft\web\Application-&gt;init()
  #37 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Application.php(206): yii\base\BaseObject-&gt;__construct(Array)
  #38 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(91): yii\base\Application-&gt;__construct(Array)
  #39 [internal function]: craft\web\Application-&gt;__construct(Array)
  #40 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass-&gt;newInstanceArgs(Array)
  #41 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container-&gt;build('craft\\web\\Appli...', Array, Array)
  #42 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container-&gt;get('craft\\web\\Appli...', Array, Array)
  #43 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\bootstrap\bootstrap.php(245): yii\BaseYii::createObject(Array)
  #44 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\bootstrap\web.php(51): require('E:\\WAMP\\www\\cra...')
  #45 E:\WAMP\www\craftycoffee\web\index.php(20): require('E:\\WAMP\\www\\cra...')
  #46 {main}
  
  Next yii\db\Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'craftycoffee.info' doesn't exist
  The SQL being executed was: SELECT *
  FROM `info`
  WHERE `id`=1
  LIMIT 1 in E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Schema.php:674
  Stack trace:
  #0 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(1298): yii\db\Schema-&gt;convertException(Object(PDOException), 'SELECT *\nFROM `...')
  #1 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(1159): yii\db\Command-&gt;internalExecute('SELECT *\nFROM `...')
  #2 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(415): yii\db\Command-&gt;queryInternal('fetch', NULL)
  #3 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Query.php(274): yii\db\Command-&gt;queryOne()
  #4 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\db\Query.php(168): yii\db\Query-&gt;one(NULL)
  #5 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(620): craft\db\Query-&gt;one()
  #6 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(286): craft\web\Application-&gt;getInfo(true)
  #7 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\services\Sites.php(1138): craft\web\Application-&gt;getIsInstalled()
  #8 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\services\Sites.php(448): craft\services\Sites-&gt;_loadAllSites()
  #9 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Component.php(180): craft\services\Sites-&gt;setCurrentSite(NULL)
  #10 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(558): yii\base\Component-&gt;__set('currentSite', NULL)
  #11 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(107): yii\BaseYii::configure(Object(craft\services\Sites), Array)
  #12 [internal function]: yii\base\BaseObject-&gt;__construct(Array)
  #13 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass-&gt;newInstanceArgs(Array)
  #14 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container-&gt;build('craft\\services\\...', Array, Array)
  #15 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container-&gt;get('craft\\services\\...', Array, Array)
  #16 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\ServiceLocator.php(137): yii\BaseYii::createObject(Array)
  #17 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Module.php(742): yii\di\ServiceLocator-&gt;get('sites', true)
  #18 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(341): yii\base\Module-&gt;get('sites', true)
  #19 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(1238): craft\web\Application-&gt;get('sites')
  #20 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Request.php(185): craft\web\Application-&gt;getSites()
  #21 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(109): craft\web\Request-&gt;init()
  #22 [internal function]: yii\base\BaseObject-&gt;__construct(Array)
  #23 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass-&gt;newInstanceArgs(Array)
  #24 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container-&gt;build('craft\\web\\Reque...', Array, Array)
  #25 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container-&gt;get('craft\\web\\Reque...', Array, Array)
  #26 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\config\app.web.php(13): yii\BaseYii::createObject(Array)
  #27 [internal function]: {closure}()
  #28 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(524): call_user_func_array(Object(Closure), Array)
  #29 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(349): yii\di\Container-&gt;invoke(Object(Closure), Array)
  #30 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\ServiceLocator.php(137): yii\BaseYii::createObject(Object(Closure))
  #31 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Module.php(742): yii\di\ServiceLocator-&gt;get('request', true)
  #32 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(341): yii\base\Module-&gt;get('request', true)
  #33 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\web\Application.php(160): craft\web\Application-&gt;get('request')
  #34 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(1380): yii\web\Application-&gt;getRequest()
  #35 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(100): craft\web\Application-&gt;_preInit()
  #36 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(109): craft\web\Application-&gt;init()
  #37 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Application.php(206): yii\base\BaseObject-&gt;__construct(Array)
  #38 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(91): yii\base\Application-&gt;__construct(Array)
  #39 [internal function]: craft\web\Application-&gt;__construct(Array)
  #40 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass-&gt;newInstanceArgs(Array)
  #41 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container-&gt;build('craft\\web\\Appli...', Array, Array)
  #42 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container-&gt;get('craft\\web\\Appli...', Array, Array)
  #43 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\bootstrap\bootstrap.php(245): yii\BaseYii::createObject(Array)
  #44 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\bootstrap\web.php(51): require('E:\\WAMP\\www\\cra...')
  #45 E:\WAMP\www\craftycoffee\web\index.php(20): require('E:\\WAMP\\www\\cra...')
  #46 {main}
  Additional Information:
  Array
  (
      [0] =&gt; 42S02
      [1] =&gt; 1146
      [2] =&gt; Table 'craftycoffee.info' doesn't exist
  )
  
  </code></pre>
  
  <p>Edit:
  I also tried to install it with composer, but it gives me the following error:
  <a href="https://i.sstatic.net/M0Hti.jpg" rel="nofollow noreferrer">https://i.sstatic.net/M0Hti.jpg</a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-05T08:31:22.623Z
Comments.Text: Do you have a `craftycoffee` database and does it have an `info` table?
Comments.UserDisplayName: Oli
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-05T09:05:16.920Z
Comments.Text: @Oli Yes, it does. However, the info table is empty.
Comments.UserDisplayName: Jens De Muynck
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-05T09:13:35.027Z
Comments.Text: Strange... The error suggest the table doesn't even exist. Could you try to give remote access to your user, see here - https://dba.stackexchange.com/a/186309 then try the install again.
Comments.UserDisplayName: Oli
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-05T09:52:29.693Z
Comments.Text: I have put the following in my db, but without success: GRANT ALL PRIVILEGES ON *.* TO 'user'@'172.0.0.1';
Comments.UserDisplayName: Jens De Muynck
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-05T10:28:59.317Z
Comments.Text: It looks like you are using `localhost` in your connection though and not `172.0.0.1`
Comments.UserDisplayName: Oli
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-05T11:31:06.280Z
Comments.Text: So I tried making a new virtual host named "craftycoffee.test" instead of using localhost, and then tried giving my new database the priviliges with "GRANT ALL PRIVILEGES ON . TO 'user'@'craftycoffee.test';" but still no success.
Comments.UserDisplayName: Jens De Muynck
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-05T11:51:12.370Z
Comments.Text: Are you re-installing each time?
Comments.UserDisplayName: Oli
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-05T11:57:16.830Z
Comments.Text: Yes, but before i reinstall, i have to drop my database because it will not let me install it again otherwise
Comments.UserDisplayName: Jens De Muynck
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-05T11:58:58.080Z
Comments.Text: I just noticed that all my tables are being made, but none of them get filled with data, i thought only info was empty... Maybe this clarifies something?
Comments.UserDisplayName: Jens De Muynck
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-05T13:49:46.787Z
Comments.Text: Could you have a look here (related to the error you get with composer but could help..) https://stackoverflow.com/a/31276668
Comments.UserDisplayName: Oli
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-05T21:19:08.540Z
Comments.Text: @Oli Did you get my support mail back?
Comments.UserDisplayName: Jens De Muynck
Tags: <craft3>
Title: MySQL Problem fetching the info row
ThreadText: # MySQL Problem fetching the info row
  
  (Asked by: username_0 on 2020-05-05)
  
  since yesterday i have been trying to setup Craft CMS for the first time,
  but the installation fails and tells me to check the logs.
  
  The database account has all rights.
  
  (This is only a part of the log, but this should do)
  
  ```
  2020-05-05 07:25:50 [-][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;port=3306;dbname=craftycoffee
  2020-05-05 07:25:50 [-][-][-][profile begin][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;port=3306;dbname=craftycoffee
  2020-05-05 07:25:50 [-][-][-][profile end][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;port=3306;dbname=craftycoffee
  2020-05-05 07:25:53 [-][-][-][info][yii\db\Command::query] SELECT *
  FROM `info`
  WHERE `id`=1
  LIMIT 1
  2020-05-05 07:25:53 [-][-][-][profile begin][yii\db\Command::query] SELECT *
  FROM `info`
  WHERE `id`=1
  LIMIT 1
  2020-05-05 07:25:53 [-][-][-][profile end][yii\db\Command::query] SELECT *
  FROM `info`
  WHERE `id`=1
  LIMIT 1
  2020-05-05 07:25:53 [-][-][-][error][craft\base\ApplicationTrait::getIsInstalled] There was a problem fetching the info row: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'craftycoffee.info' doesn't exist
  The SQL being executed was: SELECT *
  FROM `info`
  WHERE `id`=1
  LIMIT 1
  2020-05-05 07:25:53 [-][-][-][error][yii\db\Exception] PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'craftycoffee.info' doesn't exist in E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php:1293
  Stack trace:
  #0 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(1293): PDOStatement->execute()
  #1 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(1159): yii\db\Command->internalExecute('SELECT *\nFROM `...')
  #2 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(415): yii\db\Command->queryInternal('fetch', NULL)
  #3 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Query.php(274): yii\db\Command->queryOne()
  #4 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\db\Query.php(168): yii\db\Query->one(NULL)
  #5 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(620): craft\db\Query->one()
  #6 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(286): craft\web\Application->getInfo(true)
  #7 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\services\Sites.php(1138): craft\web\Application->getIsInstalled()
  #8 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\services\Sites.php(448): craft\services\Sites->_loadAllSites()
  #9 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Component.php(180): craft\services\Sites->setCurrentSite(NULL)
  #10 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(558): yii\base\Component->__set('currentSite', NULL)
  #11 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(107): yii\BaseYii::configure(Object(craft\services\Sites), Array)
  #12 [internal function]: yii\base\BaseObject->__construct(Array)
  #13 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass->newInstanceArgs(Array)
  #14 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container->build('craft\\services\\...', Array, Array)
  #15 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container->get('craft\\services\\...', Array, Array)
  #16 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\ServiceLocator.php(137): yii\BaseYii::createObject(Array)
  #17 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Module.php(742): yii\di\ServiceLocator->get('sites', true)
  #18 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(341): yii\base\Module->get('sites', true)
  #19 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(1238): craft\web\Application->get('sites')
  #20 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Request.php(185): craft\web\Application->getSites()
  #21 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(109): craft\web\Request->init()
  #22 [internal function]: yii\base\BaseObject->__construct(Array)
  #23 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass->newInstanceArgs(Array)
  #24 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container->build('craft\\web\\Reque...', Array, Array)
  #25 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container->get('craft\\web\\Reque...', Array, Array)
  #26 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\config\app.web.php(13): yii\BaseYii::createObject(Array)
  #27 [internal function]: {closure}()
  #28 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(524): call_user_func_array(Object(Closure), Array)
  #29 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(349): yii\di\Container->invoke(Object(Closure), Array)
  #30 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\ServiceLocator.php(137): yii\BaseYii::createObject(Object(Closure))
  #31 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Module.php(742): yii\di\ServiceLocator->get('request', true)
  #32 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(341): yii\base\Module->get('request', true)
  #33 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\web\Application.php(160): craft\web\Application->get('request')
  #34 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(1380): yii\web\Application->getRequest()
  #35 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(100): craft\web\Application->_preInit()
  #36 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(109): craft\web\Application->init()
  #37 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Application.php(206): yii\base\BaseObject->__construct(Array)
  #38 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(91): yii\base\Application->__construct(Array)
  #39 [internal function]: craft\web\Application->__construct(Array)
  #40 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass->newInstanceArgs(Array)
  #41 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container->build('craft\\web\\Appli...', Array, Array)
  #42 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container->get('craft\\web\\Appli...', Array, Array)
  #43 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\bootstrap\bootstrap.php(245): yii\BaseYii::createObject(Array)
  #44 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\bootstrap\web.php(51): require('E:\\WAMP\\www\\cra...')
  #45 E:\WAMP\www\craftycoffee\web\index.php(20): require('E:\\WAMP\\www\\cra...')
  #46 {main}
  
  Next yii\db\Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'craftycoffee.info' doesn't exist
  The SQL being executed was: SELECT *
  FROM `info`
  WHERE `id`=1
  LIMIT 1 in E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Schema.php:674
  Stack trace:
  #0 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(1298): yii\db\Schema->convertException(Object(PDOException), 'SELECT *\nFROM `...')
  #1 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(1159): yii\db\Command->internalExecute('SELECT *\nFROM `...')
  #2 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(415): yii\db\Command->queryInternal('fetch', NULL)
  #3 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Query.php(274): yii\db\Command->queryOne()
  #4 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\db\Query.php(168): yii\db\Query->one(NULL)
  #5 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(620): craft\db\Query->one()
  #6 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(286): craft\web\Application->getInfo(true)
  #7 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\services\Sites.php(1138): craft\web\Application->getIsInstalled()
  #8 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\services\Sites.php(448): craft\services\Sites->_loadAllSites()
  #9 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Component.php(180): craft\services\Sites->setCurrentSite(NULL)
  #10 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(558): yii\base\Component->__set('currentSite', NULL)
  #11 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(107): yii\BaseYii::configure(Object(craft\services\Sites), Array)
  #12 [internal function]: yii\base\BaseObject->__construct(Array)
  #13 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass->newInstanceArgs(Array)
  #14 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container->build('craft\\services\\...', Array, Array)
  #15 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container->get('craft\\services\\...', Array, Array)
  #16 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\ServiceLocator.php(137): yii\BaseYii::createObject(Array)
  #17 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Module.php(742): yii\di\ServiceLocator->get('sites', true)
  #18 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(341): yii\base\Module->get('sites', true)
  #19 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(1238): craft\web\Application->get('sites')
  #20 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Request.php(185): craft\web\Application->getSites()
  #21 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(109): craft\web\Request->init()
  #22 [internal function]: yii\base\BaseObject->__construct(Array)
  #23 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass->newInstanceArgs(Array)
  #24 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container->build('craft\\web\\Reque...', Array, Array)
  #25 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container->get('craft\\web\\Reque...', Array, Array)
  #26 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\config\app.web.php(13): yii\BaseYii::createObject(Array)
  #27 [internal function]: {closure}()
  #28 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(524): call_user_func_array(Object(Closure), Array)
  #29 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(349): yii\di\Container->invoke(Object(Closure), Array)
  #30 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\ServiceLocator.php(137): yii\BaseYii::createObject(Object(Closure))
  #31 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Module.php(742): yii\di\ServiceLocator->get('request', true)
  #32 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(341): yii\base\Module->get('request', true)
  #33 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\web\Application.php(160): craft\web\Application->get('request')
  #34 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(1380): yii\web\Application->getRequest()
  #35 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(100): craft\web\Application->_preInit()
  #36 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(109): craft\web\Application->init()
  #37 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Application.php(206): yii\base\BaseObject->__construct(Array)
  #38 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(91): yii\base\Application->__construct(Array)
  #39 [internal function]: craft\web\Application->__construct(Array)
  #40 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass->newInstanceArgs(Array)
  #41 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container->build('craft\\web\\Appli...', Array, Array)
  #42 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container->get('craft\\web\\Appli...', Array, Array)
  #43 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\bootstrap\bootstrap.php(245): yii\BaseYii::createObject(Array)
  #44 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\bootstrap\web.php(51): require('E:\\WAMP\\www\\cra...')
  #45 E:\WAMP\www\craftycoffee\web\index.php(20): require('E:\\WAMP\\www\\cra...')
  #46 {main}
  Additional Information:
  Array
  (
      [0] => 42S02
      [1] => 1146
      [2] => Table 'craftycoffee.info' doesn't exist
  )
  
  ```
  
  Edit:
  I also tried to install it with composer, but it gives me the following error:
  <https://i.sstatic.net/M0Hti.jpg>
  
  **Tags:** craft3
  
  > **Comments:**
  > **username_1**: Do you have a `craftycoffee` database and does it have an `info` table?  
  > **username_0**: @username_1 Yes, it does. However, the info table is empty.  
  > **username_1**: Strange... The error suggest the table doesn't even exist. Could you try to give remote access to your user, see here - https://dba.stackexchange.com/a/186309 then try the install again.  
  > **username_0**: I have put the following in my db, but without success: GRANT ALL PRIVILEGES ON *.* TO 'user'@'172.0.0.1';  
  > **username_1**: It looks like you are using `localhost` in your connection though and not `172.0.0.1`  
  > **username_0**: So I tried making a new virtual host named "craftycoffee.test" instead of using localhost, and then tried giving my new database the priviliges with "GRANT ALL PRIVILEGES ON . TO 'user'@'craftycoffee.test';" but still no success.  
  > **username_1**: Are you re-installing each time?  
  > **username_0**: Yes, but before i reinstall, i have to drop my database because it will not let me install it again otherwise  
  > **username_0**: I just noticed that all my tables are being made, but none of them get filled with data, i thought only info was empty... Maybe this clarifies something?  
  > **username_1**: Could you have a look here (related to the error you get with composer but could help..) https://stackoverflow.com/a/31276668  
  > **username_0**: @username_1 Did you get my support mail back?  
  
  ---
  
  ## 0 answers
  
  