Host 'XXX' is not allowed to connect to this MySQL server [solved]

Hello dear Neos community,

I already used Neos on a Win7 PC and now I am installing it on a Win10. I get the infamous 500 Internal Server error when I try to open the setup with IP/setup from another PC or localhost/setup. I often had this error in other stages of the installation and not right after the Setup’s “Initialising Setup …” message. It finds the PHP.exe because when I remove the path from Settings.yaml the setup will tell me, the php is missing. I use php7 but I also tried 5.6.16 with the same result. What bugs me is that the System.log talks about an mysql server at this stage of the installation. The database stuff comes way later in the setup.

My System.log:
[… a few times the same mysql server message as below…]
16-02-29 09:15:36 DEBUG Flow Router route(): A cached Route with the cache identifier “434fc6649174634ff5741051422df147” matched the path “setup/index”.
16-02-29 09:15:36 DEBUG Flow CSRF: No token required, safe request
16-02-29 09:15:37 DEBUG Flow Session initialization triggered by TYPO3\Flow\Security\Context->setInterceptedRequest.
16-02-29 09:15:37 DEBUG Flow Session: Started session with id QmLYGHr4FddMUPqBW2p4FTj3w5NYJ6K3.
16-02-29 09:15:37 DEBUG Flow Session: Resumed session with id QmLYGHr4FddMUPqBW2p4FTj3w5NYJ6K3 which was inactive for 1 second. (1s)
16-02-29 09:15:37 DEBUG Flow Router route(): A cached Route with the cache identifier “e633487e0f5a2abd90b21f4031d8dfbf” matched the path “setup/login”.
16-02-29 09:15:37 DEBUG Flow CSRF: No token required, safe request
16-02-29 09:15:37 CRITICAL DBAL Exception in line 133 of C:\wamp64\www\inetneointer\Packages\Libraries\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php: An exception occured in driver: SQLSTATE[HY000] [1130] Host ‘V-Studio’ is not allowed to connect to this MySQL server - See also: 20160229091537272534.txt
previousException => Exception #1130 in line 45 of C:\wamp64\www\inetneointer\Packages\Libraries\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOMySql\Driver.php: SQLSTATE[HY000] [1130] Host ‘V-Studio’ is not allowed to connect to this MySQL server

“V-Studio” is the name of this Win 10 PC (where Neos is supposed to be installed).

My httpd.conf:

<Directory "C:/wamp64/www/inetneointer/">
    Options FollowSymLinks MultiViews
    AllowOverride all
    Require ip 10.100
    Require ip 10.193
    Require local
</Directory>

Settings.yaml (I also tried using the default one and only adding the path to the php.exe -> same result)

TYPO3:
  Flow:
    persistence:
      backendOptions:
        host: 10.100.11.35
    core:
      phpBinaryPathAndFilename: 'C:/wamp64/bin/php/php7.0.0/php.exe'
      subRequestPhpIniPathAndFilename: 'C:/wamp64/bin/php/php7.0.0/php.ini'
    resource:
      publishing:
        fileSystem:
          mirrorMode: copy
  Imagine:
    driver: Imagick

That Exceptions/xxx.txt file:

Exception in line 133 of C:\wamp64\www\inetneointer\Packages\Libraries\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php: An exception occured in driver: SQLSTATE[HY000] [1130] Host 'V-Studio' is not allowed to connect to this MySQL server

36 Doctrine\DBAL\Driver\AbstractMySQLDriver::convertException("An exception occured in driver: SQLSTATE[HY000] [1130] Host 'V-Studio' is not allowed to connect to this MySQL server", Doctrine\DBAL\Driver\PDOException)
35 Doctrine\DBAL\DBALException::driverException(Doctrine\DBAL\Driver\PDOMySql\Driver, Doctrine\DBAL\Driver\PDOException)
34 Doctrine\DBAL\Driver\PDOMySql\Driver::connect(array|6|, "neo-inter", "", array|0|)
33 Doctrine\DBAL\Connection::connect()
32 TYPO3\Flow\Persistence\Doctrine\EntityManagerFactory_Original::create()
31 TYPO3\Flow\Object\ObjectManager::buildObjectByFactory("Doctrine\Common\Persistence\ObjectManager")
30 TYPO3\Flow\Object\ObjectManager::get("Doctrine\Common\Persistence\ObjectManager")
29 TYPO3\Flow\Persistence\Doctrine\PersistenceManager::TYPO3\Flow\Persistence\Doctrine\{closure}()
28 Closure::__invoke()
27 TYPO3\Flow\Object\DependencyInjection\DependencyProxy::_activateDependency()
26 TYPO3\Flow\Object\DependencyInjection\DependencyProxy::__call("getEventManager", array|0|)
25 TYPO3\Flow\Persistence\Doctrine\PersistenceManager_Original::initializeObject(1)
24 TYPO3\Flow\Persistence\Doctrine\PersistenceManager::__construct()
23 TYPO3\Flow\Core\Bootstrap::initializePersistenceManager()
22 TYPO3\Flow\Object\ObjectManager::buildObjectByFactory("TYPO3\Flow\Persistence\PersistenceManagerInterface")
21 TYPO3\Flow\Object\ObjectManager::get("TYPO3\Flow\Persistence\PersistenceManagerInterface")
20 TYPO3\Fluid\ViewHelpers\FormViewHelper::Flow_Proxy_injectProperties()
19 TYPO3\Fluid\ViewHelpers\FormViewHelper::__construct()
18 TYPO3\Flow\Object\ObjectManager::instantiateClass("TYPO3\Fluid\ViewHelpers\FormViewHelper", array|0|)
17 TYPO3\Flow\Object\ObjectManager::get("TYPO3\Fluid\ViewHelpers\FormViewHelper")
16 TYPO3\Fluid\Core\Parser\TemplateParser_Original::initializeViewHelperAndAddItToStack(TYPO3\Fluid\Core\Parser\ParsingState, "f", "form", array|1|)
15 TYPO3\Fluid\Core\Parser\TemplateParser_Original::openingViewHelperTagHandler(TYPO3\Fluid\Core\Parser\ParsingState, "f", "form", " action="authenticate"", FALSE)
14 TYPO3\Fluid\Core\Parser\TemplateParser_Original::buildObjectTree(array|57|, 2)
13 TYPO3\Fluid\Core\Parser\TemplateParser_Original::parse("<f:layout name="Default" />

<f:section name="content">
    <div class="t3-module-container indented">
        <f:form action="authenticate">
            <h1 class="text-center">Login</h1>
            <fieldset>
                <legend class="text-center">Enter the setup password to continue:</legend>
                <div class="login-box">
                    <div class="form-group">
                        <f:form.textfield class="form-control" id="password" type="password" name="__authentication[TYPO3][Flow][Security][Authentication][Token][PasswordToken][password]" additionalAttributes="{autofocus: 'autofocus'}" placeholder="Password" />
                    </div>
                    <div class="form-group">
                        <div class="controls">
                            <f:form.hidden name="step" value="{step}" />
                            <f:form.button class="btn btn-full-width btn-primary" type="submit">
                                <span class="glyphicon glyphicon-lock"></span> Login
                            </f:form.button>
                        </div>
                    </div>
                    <f:flashMessages as="flashMessages">
                        <f:for each="{flashMessages}" as="flashMessage">
                            <f:if condition="{flashMessage.severity} == 'OK'">
                                <div class="tooltip tooltip-success">
                            </f:if>
                            <f:if condition="{flashMessage.severity} == 'Notice'">
                                <div class="tooltip tooltip-info">
                            </f:if>
                            <f:if condition="{flashMessage.severity} == 'Warning'">
                                <div class="tooltip tooltip-warning">
                            </f:if>
                            <f:if condition="{flashMessage.severity} == 'Error'">
                                <div class="tooltip tooltip-error">
                            </f:if>
                                <div class="tooltip-arrow tooltip-arrow-top"></div>
                                <div class="tooltip-inner">{flashMessage.message -> f:format.raw()}</div>
                            </div>
                        </f:for>
                    </f:flashMessages>
                </div>
            </fieldset>
        </f:form>
        <f:if condition="{initialPasswordFile}">
            <f:then>
                <div class="alert alert-info"><span class="glyphicon glyphicon-info-sign"></span><strong>Setup Password:</strong> The initial password for accessing the setup can be found in the file<br /><strong>{initialPasswordFile}</strong></div>
            </f:then>
            <f:else>
                <div class="alert alert-info"><span class="glyphicon glyphicon-info-sign"></span>If you don't remember the setup password, <strong><f:link.action action="generateNewPassword" arguments="{step: step}">click here</f:link.action></strong> for creating a new one.</div>
            </f:else>
        </f:if>
    </div>
</f:section>")
12 TYPO3\Fluid\View\AbstractTemplateView::render()
11 TYPO3\Flow\Mvc\Controller\ActionController_Original::callActionMethod()
10 TYPO3\Flow\Mvc\Controller\ActionController_Original::processRequest(TYPO3\Flow\Mvc\ActionRequest, TYPO3\Flow\Http\Response)
9 TYPO3\Flow\Mvc\Dispatcher_Original::initiateDispatchLoop(TYPO3\Flow\Mvc\ActionRequest, TYPO3\Flow\Http\Response)
8 TYPO3\Flow\Mvc\Dispatcher_Original::dispatch(TYPO3\Flow\Mvc\ActionRequest, TYPO3\Flow\Http\Response)
7 call_user_func_array(array|2|, array|2|)
6 TYPO3\Flow\Object\DependencyInjection\DependencyProxy::__call("dispatch", array|2|)
5 TYPO3\Flow\Mvc\DispatchComponent_Original::handle(TYPO3\Flow\Http\Component\ComponentContext)
4 TYPO3\Flow\Http\Component\ComponentChain_Original::handle(TYPO3\Flow\Http\Component\ComponentContext)
3 TYPO3\Flow\Http\Component\ComponentChain_Original::handle(TYPO3\Flow\Http\Component\ComponentContext)
2 TYPO3\Setup\Core\RequestHandler::handleRequest()
1 TYPO3\Flow\Core\Bootstrap::run()

Previous exception: Exception #1130 in line 41 of C:\wamp64\www\inetneointer\Packages\Libraries\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOMySql\Driver.php: SQLSTATE[HY000] [1130] Host 'V-Studio' is not allowed to connect to this MySQL server

35 Doctrine\DBAL\Driver\PDOConnection::__construct("mysql:host=10.100.11.35;dbname=neo-inter;charset=utf8;", "neo-inter", "", array|0|)
34 Doctrine\DBAL\Driver\PDOMySql\Driver::connect(array|6|, "neo-inter", "", array|0|)
33 Doctrine\DBAL\Connection::connect()
32 TYPO3\Flow\Persistence\Doctrine\EntityManagerFactory_Original::create()
31 TYPO3\Flow\Object\ObjectManager::buildObjectByFactory("Doctrine\Common\Persistence\ObjectManager")
30 TYPO3\Flow\Object\ObjectManager::get("Doctrine\Common\Persistence\ObjectManager")
29 TYPO3\Flow\Persistence\Doctrine\PersistenceManager::TYPO3\Flow\Persistence\Doctrine\{closure}()
28 Closure::__invoke()
27 TYPO3\Flow\Object\DependencyInjection\DependencyProxy::_activateDependency()
26 TYPO3\Flow\Object\DependencyInjection\DependencyProxy::__call("getEventManager", array|0|)
25 TYPO3\Flow\Persistence\Doctrine\PersistenceManager_Original::initializeObject(1)
24 TYPO3\Flow\Persistence\Doctrine\PersistenceManager::__construct()
23 TYPO3\Flow\Core\Bootstrap::initializePersistenceManager()
22 TYPO3\Flow\Object\ObjectManager::buildObjectByFactory("TYPO3\Flow\Persistence\PersistenceManagerInterface")
21 TYPO3\Flow\Object\ObjectManager::get("TYPO3\Flow\Persistence\PersistenceManagerInterface")
20 TYPO3\Fluid\ViewHelpers\FormViewHelper::Flow_Proxy_injectProperties()
19 TYPO3\Fluid\ViewHelpers\FormViewHelper::__construct()
18 TYPO3\Flow\Object\ObjectManager::instantiateClass("TYPO3\Fluid\ViewHelpers\FormViewHelper", array|0|)
17 TYPO3\Flow\Object\ObjectManager::get("TYPO3\Fluid\ViewHelpers\FormViewHelper")
16 TYPO3\Fluid\Core\Parser\TemplateParser_Original::initializeViewHelperAndAddItToStack(TYPO3\Fluid\Core\Parser\ParsingState, "f", "form", array|1|)
15 TYPO3\Fluid\Core\Parser\TemplateParser_Original::openingViewHelperTagHandler(TYPO3\Fluid\Core\Parser\ParsingState, "f", "form", " action="authenticate"", FALSE)
14 TYPO3\Fluid\Core\Parser\TemplateParser_Original::buildObjectTree(array|57|, 2)
13 TYPO3\Fluid\Core\Parser\TemplateParser_Original::parse("<f:layout name="Default" />

<f:section name="content">
    <div class="t3-module-container indented">
        <f:form action="authenticate">
            <h1 class="text-center">Login</h1>
            <fieldset>
                <legend class="text-center">Enter the setup password to continue:</legend>
                <div class="login-box">
                    <div class="form-group">
                        <f:form.textfield class="form-control" id="password" type="password" name="__authentication[TYPO3][Flow][Security][Authentication][Token][PasswordToken][password]" additionalAttributes="{autofocus: 'autofocus'}" placeholder="Password" />
                    </div>
                    <div class="form-group">
                        <div class="controls">
                            <f:form.hidden name="step" value="{step}" />
                            <f:form.button class="btn btn-full-width btn-primary" type="submit">
                                <span class="glyphicon glyphicon-lock"></span> Login
                            </f:form.button>
                        </div>
                    </div>
                    <f:flashMessages as="flashMessages">
                        <f:for each="{flashMessages}" as="flashMessage">
                            <f:if condition="{flashMessage.severity} == 'OK'">
                                <div class="tooltip tooltip-success">
                            </f:if>
                            <f:if condition="{flashMessage.severity} == 'Notice'">
                                <div class="tooltip tooltip-info">
                            </f:if>
                            <f:if condition="{flashMessage.severity} == 'Warning'">
                                <div class="tooltip tooltip-warning">
                            </f:if>
                            <f:if condition="{flashMessage.severity} == 'Error'">
                                <div class="tooltip tooltip-error">
                            </f:if>
                                <div class="tooltip-arrow tooltip-arrow-top"></div>
                                <div class="tooltip-inner">{flashMessage.message -> f:format.raw()}</div>
                            </div>
                        </f:for>
                    </f:flashMessages>
                </div>
            </fieldset>
        </f:form>
        <f:if condition="{initialPasswordFile}">
            <f:then>
                <div class="alert alert-info"><span class="glyphicon glyphicon-info-sign"></span><strong>Setup Password:</strong> The initial password for accessing the setup can be found in the file<br /><strong>{initialPasswordFile}</strong></div>
            </f:then>
            <f:else>
                <div class="alert alert-info"><span class="glyphicon glyphicon-info-sign"></span>If you don't remember the setup password, <strong><f:link.action action="generateNewPassword" arguments="{step: step}">click here</f:link.action></strong> for creating a new one.</div>
            </f:else>
        </f:if>
    </div>
</f:section>")
12 TYPO3\Fluid\View\AbstractTemplateView::render()
11 TYPO3\Flow\Mvc\Controller\ActionController_Original::callActionMethod()
10 TYPO3\Flow\Mvc\Controller\ActionController_Original::processRequest(TYPO3\Flow\Mvc\ActionRequest, TYPO3\Flow\Http\Response)
9 TYPO3\Flow\Mvc\Dispatcher_Original::initiateDispatchLoop(TYPO3\Flow\Mvc\ActionRequest, TYPO3\Flow\Http\Response)
8 TYPO3\Flow\Mvc\Dispatcher_Original::dispatch(TYPO3\Flow\Mvc\ActionRequest, TYPO3\Flow\Http\Response)
7 call_user_func_array(array|2|, array|2|)
6 TYPO3\Flow\Object\DependencyInjection\DependencyProxy::__call("dispatch", array|2|)
5 TYPO3\Flow\Mvc\DispatchComponent_Original::handle(TYPO3\Flow\Http\Component\ComponentContext)
4 TYPO3\Flow\Http\Component\ComponentChain_Original::handle(TYPO3\Flow\Http\Component\ComponentContext)
3 TYPO3\Flow\Http\Component\ComponentChain_Original::handle(TYPO3\Flow\Http\Component\ComponentContext)
2 TYPO3\Setup\Core\RequestHandler::handleRequest()
1 TYPO3\Flow\Core\Bootstrap::run()

Previous exception: Exception #1130 in line 43 of C:\wamp64\www\inetneointer\Packages\Libraries\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php: SQLSTATE[HY000] [1130] Host 'V-Studio' is not allowed to connect to this MySQL server

36 PDO::__construct("mysql:host=10.100.11.35;dbname=neo-inter;charset=utf8;", "neo-inter", "", array|0|)
35 Doctrine\DBAL\Driver\PDOConnection::__construct("mysql:host=10.100.11.35;dbname=neo-inter;charset=utf8;", "neo-inter", "", array|0|)
34 Doctrine\DBAL\Driver\PDOMySql\Driver::connect(array|6|, "neo-inter", "", array|0|)
33 Doctrine\DBAL\Connection::connect()
32 TYPO3\Flow\Persistence\Doctrine\EntityManagerFactory_Original::create()
31 TYPO3\Flow\Object\ObjectManager::buildObjectByFactory("Doctrine\Common\Persistence\ObjectManager")
30 TYPO3\Flow\Object\ObjectManager::get("Doctrine\Common\Persistence\ObjectManager")
29 TYPO3\Flow\Persistence\Doctrine\PersistenceManager::TYPO3\Flow\Persistence\Doctrine\{closure}()
28 Closure::__invoke()
27 TYPO3\Flow\Object\DependencyInjection\DependencyProxy::_activateDependency()
26 TYPO3\Flow\Object\DependencyInjection\DependencyProxy::__call("getEventManager", array|0|)
25 TYPO3\Flow\Persistence\Doctrine\PersistenceManager_Original::initializeObject(1)
24 TYPO3\Flow\Persistence\Doctrine\PersistenceManager::__construct()
23 TYPO3\Flow\Core\Bootstrap::initializePersistenceManager()
22 TYPO3\Flow\Object\ObjectManager::buildObjectByFactory("TYPO3\Flow\Persistence\PersistenceManagerInterface")
21 TYPO3\Flow\Object\ObjectManager::get("TYPO3\Flow\Persistence\PersistenceManagerInterface")
20 TYPO3\Fluid\ViewHelpers\FormViewHelper::Flow_Proxy_injectProperties()
19 TYPO3\Fluid\ViewHelpers\FormViewHelper::__construct()
18 TYPO3\Flow\Object\ObjectManager::instantiateClass("TYPO3\Fluid\ViewHelpers\FormViewHelper", array|0|)
17 TYPO3\Flow\Object\ObjectManager::get("TYPO3\Fluid\ViewHelpers\FormViewHelper")
16 TYPO3\Fluid\Core\Parser\TemplateParser_Original::initializeViewHelperAndAddItToStack(TYPO3\Fluid\Core\Parser\ParsingState, "f", "form", array|1|)
15 TYPO3\Fluid\Core\Parser\TemplateParser_Original::openingViewHelperTagHandler(TYPO3\Fluid\Core\Parser\ParsingState, "f", "form", " action="authenticate"", FALSE)
14 TYPO3\Fluid\Core\Parser\TemplateParser_Original::buildObjectTree(array|57|, 2)
13 TYPO3\Fluid\Core\Parser\TemplateParser_Original::parse("<f:layout name="Default" />

<f:section name="content">
    <div class="t3-module-container indented">
        <f:form action="authenticate">
            <h1 class="text-center">Login</h1>
            <fieldset>
                <legend class="text-center">Enter the setup password to continue:</legend>
                <div class="login-box">
                    <div class="form-group">
                        <f:form.textfield class="form-control" id="password" type="password" name="__authentication[TYPO3][Flow][Security][Authentication][Token][PasswordToken][password]" additionalAttributes="{autofocus: 'autofocus'}" placeholder="Password" />
                    </div>
                    <div class="form-group">
                        <div class="controls">
                            <f:form.hidden name="step" value="{step}" />
                            <f:form.button class="btn btn-full-width btn-primary" type="submit">
                                <span class="glyphicon glyphicon-lock"></span> Login
                            </f:form.button>
                        </div>
                    </div>
                    <f:flashMessages as="flashMessages">
                        <f:for each="{flashMessages}" as="flashMessage">
                            <f:if condition="{flashMessage.severity} == 'OK'">
                                <div class="tooltip tooltip-success">
                            </f:if>
                            <f:if condition="{flashMessage.severity} == 'Notice'">
                                <div class="tooltip tooltip-info">
                            </f:if>
                            <f:if condition="{flashMessage.severity} == 'Warning'">
                                <div class="tooltip tooltip-warning">
                            </f:if>
                            <f:if condition="{flashMessage.severity} == 'Error'">
                                <div class="tooltip tooltip-error">
                            </f:if>
                                <div class="tooltip-arrow tooltip-arrow-top"></div>
                                <div class="tooltip-inner">{flashMessage.message -> f:format.raw()}</div>
                            </div>
                        </f:for>
                    </f:flashMessages>
                </div>
            </fieldset>
        </f:form>
        <f:if condition="{initialPasswordFile}">
            <f:then>
                <div class="alert alert-info"><span class="glyphicon glyphicon-info-sign"></span><strong>Setup Password:</strong> The initial password for accessing the setup can be found in the file<br /><strong>{initialPasswordFile}</strong></div>
            </f:then>
            <f:else>
                <div class="alert alert-info"><span class="glyphicon glyphicon-info-sign"></span>If you don't remember the setup password, <strong><f:link.action action="generateNewPassword" arguments="{step: step}">click here</f:link.action></strong> for creating a new one.</div>
            </f:else>
        </f:if>
    </div>
</f:section>")
12 TYPO3\Fluid\View\AbstractTemplateView::render()
11 TYPO3\Flow\Mvc\Controller\ActionController_Original::callActionMethod()
10 TYPO3\Flow\Mvc\Controller\ActionController_Original::processRequest(TYPO3\Flow\Mvc\ActionRequest, TYPO3\Flow\Http\Response)
9 TYPO3\Flow\Mvc\Dispatcher_Original::initiateDispatchLoop(TYPO3\Flow\Mvc\ActionRequest, TYPO3\Flow\Http\Response)
8 TYPO3\Flow\Mvc\Dispatcher_Original::dispatch(TYPO3\Flow\Mvc\ActionRequest, TYPO3\Flow\Http\Response)
7 call_user_func_array(array|2|, array|2|)
6 TYPO3\Flow\Object\DependencyInjection\DependencyProxy::__call("dispatch", array|2|)
5 TYPO3\Flow\Mvc\DispatchComponent_Original::handle(TYPO3\Flow\Http\Component\ComponentContext)
4 TYPO3\Flow\Http\Component\ComponentChain_Original::handle(TYPO3\Flow\Http\Component\ComponentContext)
3 TYPO3\Flow\Http\Component\ComponentChain_Original::handle(TYPO3\Flow\Http\Component\ComponentContext)
2 TYPO3\Setup\Core\RequestHandler::handleRequest()
1 TYPO3\Flow\Core\Bootstrap::run()

HTTP REQUEST:
GET /setup/login HTTP/1.1
Accept: text/html, application/xhtml+xml, image/jxr, */*
Accept-Language: de-DE
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko
Accept-Encoding: gzip, deflate
Host: localhost
Connection: Keep-Alive



HTTP RESPONSE:
[response was empty]

Edit: The problem was indeed the dbuser for whatever reason…

Issue has been solved.