[SOLVED] Access denied for user ''@'localhost' / 500 Server error on first setup

Using Neos & Flow Installation & Deployment
1

Hi,

I am installing a fresh version of neos v3.1.4.

I am able to complete the full setup up until I can run $ ./flow server:run
I am then able to “Go to setup” on the localhost. It then says “initializing setup”, then it all seems to fail.

An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO)

Exception Code	0
Exception Type	Doctrine\DBAL\Exception\ConnectionException
Thrown in File	Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php
Line	103

Nested Exception
SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO)

Exception Code	1045
Exception Type	Doctrine\DBAL\Driver\PDOException
Thrown in File	Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php
Line	47

Nested Exception
SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO)

Exception Code	1045
Exception Type	PDOException
Thrown in File	Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php
Line	43

This Seems to the the issue, Neos is is trying to connect to mySQL with no username:

Neos\Flow\Persistence\Doctrine\PersistenceManager_Original::persistAll(TRUE)
Packages/Framework/Neos.Flow/Classes/Package.php
00051:                     $bootstrap->getObjectManager()->get(\Neos\Flow\Persistence\PersistenceManagerInterface::class)->persistAll();
00052:                 } elseif ($request->getHttpRequest()->isMethodSafe()) {
00053:                     $bootstrap->getObjectManager()->get(\Neos\Flow\Persistence\PersistenceManagerInterface::class)->persistAll(true);
00054:                 }
00055:             }

System_Development.log:

17-07-31 17:35:57 42994      CRITICAL  DBAL                 Exception in line 145 of /my/path/neos--test/emptyfolder/Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php: An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO) - See also: 2017073117355568b605.txt
    previousException => Exception #1045 in line 41 of /my/path/neos--test/emptyfolder/Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php: SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO)

17-07-31 17:35:58 42994      DEBUG     Flow                 Session: Resumed session with id zzbKuuJfursgzh6ZcDqFJ2EvsUPkxTb3 which was inactive for 3 seconds. (3s)
17-07-31 17:35:59 42994      CRITICAL  DBAL                 Exception in line 145 of /my/path/neos--test/emptyfolder/Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php: An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO) - See also: 2017073117355899b54b.txt
    previousException => Exception #1045 in line 41 of /my/path/neos--test/emptyfolder/Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php: SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO)

17-07-31 17:35:59 42994      CRITICAL  Flow                 Exception in line 57 of /my/path/neos--test/emptyfolder/Data/Temporary/Development/Cache/Code/Flow_Object_Classes/Neos_Flow_Persistence_Doctrine_QueryResult.php: An error occurred in the Database Abstraction Layer. - See also: 20170731173558305967.txt

20170731173558305967.txt:

Exception in line 57 of /my/path/neos--test/emptyfolder/Data/Temporary/Development/Cache/Code/Flow_Object_Classes/Neos_Flow_Persistence_Doctrine_QueryResult.php: An error occurred in the Database Abstraction Layer.

46 Neos\Flow\Persistence\Doctrine\Query_Original::getResult()
45 Neos\Flow\Persistence\Doctrine\QueryResult_Original::initialize()
44 Neos\Flow\Persistence\Doctrine\QueryResult_Original::toArray()
43 Neos\Neos\Domain\Repository\DomainRepository_Original::findByHost("127.0.0.1", TRUE)
42 Neos\Neos\Domain\Repository\DomainRepository_Original::findOneByHost("127.0.0.1", TRUE)
41 Neos\Neos\Domain\Repository\DomainRepository_Original::findOneByActiveRequest()
40 Neos\Neos\Domain\Repository\DomainRepository::findOneByActiveRequest()
39 call_user_func_array(array|2|, array|0|)
38 Neos\Neos\Domain\Repository\DomainRepository::Flow_Aop_Proxy_invokeJoinPoint(Neos\Flow\Aop\JoinPoint)
37 Neos\Flow\Aop\Advice\AdviceChain::proceed(Neos\Flow\Aop\JoinPoint)
36 Neos\Neos\Aspects\SiteRepositoryCachingAspect_Original::cacheDomainForActiveRequest(Neos\Flow\Aop\JoinPoint)
35 Neos\Flow\Aop\Advice\AroundAdvice::invoke(Neos\Flow\Aop\JoinPoint)
34 Neos\Flow\Aop\Advice\AdviceChain::proceed(Neos\Flow\Aop\JoinPoint)
33 Neos\Neos\Domain\Repository\DomainRepository::findOneByActiveRequest()
32 call_user_func_array(array|2|, array|0|)
31 Neos\Flow\ObjectManagement\DependencyInjection\DependencyProxy::__call("findOneByActiveRequest", array|0|)
30 Neos\Neos\Domain\Service\ContentContextFactory_Original::setDefaultSiteAndDomainFromCurrentRequest(array|9|)
29 Neos\Neos\Domain\Service\ContentContextFactory_Original::mergeContextPropertiesWithDefaults(array|4|)
28 Neos\ContentRepository\Domain\Service\ContextFactory_Original::create(array|4|)
27 call_user_func_array(array|2|, array|1|)
26 Neos\Flow\ObjectManagement\DependencyInjection\DependencyProxy::__call("create", array|1|)
25 Neos\Neos\Routing\FrontendNodeRoutePartHandler_Original::buildContextFromWorkspaceNameAndDimensions("live", array|1|)
24 Neos\Neos\Routing\FrontendNodeRoutePartHandler_Original::buildContextFromRequestPath("favicon.ico")
23 Neos\Neos\Routing\FrontendNodeRoutePartHandler_Original::convertRequestPathToNode("favicon.ico")
22 Neos\Neos\Routing\FrontendNodeRoutePartHandler_Original::Neos\Neos\Routing\{closure}()
21 Closure::__invoke()
20 Neos\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
19 Neos\Flow\Security\Context::withoutAuthorizationChecks(Closure)
18 call_user_func_array(array|2|, array|1|)
17 Neos\Flow\Security\Context::Flow_Aop_Proxy_invokeJoinPoint(Neos\Flow\Aop\JoinPoint)
16 Neos\Flow\Aop\Advice\AdviceChain::proceed(Neos\Flow\Aop\JoinPoint)
15 Neos\Flow\Session\Aspect\LazyLoadingAspect_Original::callMethodOnOriginalSessionObject(Neos\Flow\Aop\JoinPoint)
14 Neos\Flow\Aop\Advice\AroundAdvice::invoke(Neos\Flow\Aop\JoinPoint)
13 Neos\Flow\Aop\Advice\AdviceChain::proceed(Neos\Flow\Aop\JoinPoint)
12 Neos\Flow\Security\Context::withoutAuthorizationChecks(Closure)
11 Neos\Neos\Routing\FrontendNodeRoutePartHandler_Original::matchValue("favicon.ico")
10 Neos\Flow\Mvc\Routing\DynamicRoutePart_Original::match("favicon.ico")
9 Neos\Flow\Mvc\Routing\Route_Original::matches(Neos\Flow\Http\Request)
8 Neos\Flow\Mvc\Routing\Router_Original::route(Neos\Flow\Http\Request)
7 call_user_func_array(array|2|, array|1|)
6 Neos\Flow\ObjectManagement\DependencyInjection\DependencyProxy::__call("route", array|1|)
5 Neos\Flow\Mvc\Routing\RoutingComponent_Original::handle(Neos\Flow\Http\Component\ComponentContext)
4 Neos\Flow\Http\Component\ComponentChain_Original::handle(Neos\Flow\Http\Component\ComponentContext)
3 Neos\Flow\Http\Component\ComponentChain_Original::handle(Neos\Flow\Http\Component\ComponentContext)
2 Neos\Flow\Http\RequestHandler::handleRequest()
1 Neos\Flow\Core\Bootstrap::run()

HTTP REQUEST:
GET /favicon.ico HTTP/1.1

Host: 127.0.0.1:8081

Connection: keep-alive

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36

Accept: image/webp,image/apng,image/*,*/*;q=0.8

Dnt: 1

Referer: http://127.0.0.1:8081/setup/login

Accept-Encoding: gzip, deflate, br

Accept-Language: en-US,en;q=0.8,de-DE;q=0.6,de;q=0.4,la;q=0.2





HTTP RESPONSE:
[response was empty]

PHP PROCESS:
Inode: 
PID: 42994
UID: 501
GID: 20
User:
2

Hi,
I have the same error also with older version 2.3.8

3

Hi All,

Its been a number of days since I posted this… is something unclear in my post Considering the seriousness of this error (i.e. not able to do a basic install of the software), could the community perhaps try and help here?

Thank you.

4

Hi!

I’ve had the same error and in my case the problem was that the ‘Anonymous’ user didn’t exist. Just add the ‘Anonymous’ user to your MySQL server and the problem should be solved.

5

Hey this issue is possibly related to a recent bug that was fixed 3 days ago

Should be fixed in the latest bug release versions

6

Thank you! Setup works normal

7

Hi All,

It seems like the new update has fixed this issue.

Thank you.