Unbelievable issues with Magento 2.0 installation on Ubuntu 14. MySql fails after install

[spuddy]

cleanded everything up and end up again with the error below It looks I need to give up and stop working with Magento.

Installing database schema:
[ERROR] exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' in /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:129
Stack trace:
#0 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:dbname=in...', 'root', '', Array)
#1 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()
#2 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(332): Zend_Db_Adapter_Pdo_Mysql->_connect()
#3 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(460): Magento\Framework\DB\Adapter\Pdo\Mysql->_connect()
#4 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT version(...', Array)
#5 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(444): Zend_Db_Adapter_Pdo_Abstract->query('SELECT version(...', Array)
#6 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(499): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('SELECT version(...', Array)
#7 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(828): Magento\Framework\DB\Adapter\Pdo\Mysql->query('SELECT version(...', Array)
#8 /var/www/public/setup/src/Magento/Setup/Validator/DbValidator.php(93): Zend_Db_Adapter_Abstract->fetchOne('SELECT version(...')
#9 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(1168): Magento\Setup\Validator\DbValidator->checkDatabaseConnection('mountains', 'localhost', 'root', '')
#10 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(751): Magento\Setup\Model\Installer->assertDbAccessible()
#11 [internal function]: Magento\Setup\Model\Installer->installSchema()
#12 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(333): call_user_func_array(Array, Array)
#13 /var/www/public/setup/src/Magento/Setup/Controller/Install.php(103): Magento\Setup\Model\Installer->install(Array)
#14 /var/www/public/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\Setup\Controller\Install->startAction()
#15 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#16 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#17 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#18 /var/www/public/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#19 /var/www/public/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#20 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#21 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#22 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#23 /var/www/public/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#24 /var/www/public/setup/index.php(31): Zend\Mvc\Application->run()
#25 {main}

Next exception 'Zend_Db_Adapter_Exception' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' in /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:144
Stack trace:
#0 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(332): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(460): Magento\Framework\DB\Adapter\Pdo\Mysql->_connect()
#3 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT version(...', Array)
#4 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(444): Zend_Db_Adapter_Pdo_Abstract->query('SELECT version(...', Array)
#5 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(499): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('SELECT version(...', Array)
#6 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(828): Magento\Framework\DB\Adapter\Pdo\Mysql->query('SELECT version(...', Array)
#7 /var/www/public/setup/src/Magento/Setup/Validator/DbValidator.php(93): Zend_Db_Adapter_Abstract->fetchOne('SELECT version(...')
#8 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(1168): Magento\Setup\Validator\DbValidator->checkDatabaseConnection('mountains', 'localhost', 'root',)
#9 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(751): Magento\Setup\Model\Installer->assertDbAccessible()
#10 [internal function]: Magento\Setup\Model\Installer->installSchema()
#11 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(333): call_user_func_array(Array, Array)
#12 /var/www/public/setup/src/Magento/Setup/Controller/Install.php(103): Magento\Setup\Model\Installer->install(Array)
#13 /var/www/public/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\Setup\Controller\Install->startAction()
#14 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#15 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#16 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#17 /var/www/public/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#18 /var/www/public/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#19 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#20 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#21 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#22 /var/www/public/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#23 /var/www/public/setup/index.php(31): Zend\Mvc\Application->run()
#24 {main}

[CommerceStudio]

It looks like Magento 2 is very picky about the hosting environment, we had to keep removing things until we managed to get it to complete the install. You really need to start with a completely clean install and load the absolute minimum.

Make sure you clear your browser, switched from Chrome to Firefox or if that fails use the cli however it appears the cli options were changed between releases, and the cli cannot handle new gTLDs whereas with the browser install it is fine but more hit and miss! There's a group who sent us a pre-installed Magento 2 PHP56 AWS AMI, we received the PHP7 version, now that's fast!

[SindreM]

@spuddy Are you running your own server or using a managed host? That error indicates that your MySQL connection details are incorrect or there is a problem with the MySQL server. Also note that the stack trace you posted contains credentials in plain text so you might want to edit your post ;-)

[spuddy]

Hi Sindre

yes I'm runing teh own host and I reinstalled it two or three time with diffrent mysql server and end up with the sam issue.

I give it now a last try and reinstalled the server again. I will now do the install and get back with the results.

Thanks for mentioning the credentials I removed it from the previous logs, but missed it on the others

But it's anyway only a test box.

Regards

Volker

[SindreM]

Have you tried installing another web application such as Wordpress to rule out whether the issue is with the MySQL server or if it only affects Magento? Also if you can paste the my.cnf settings it might help to highlight possible issues with the MySQL config.