-
Notifications
You must be signed in to change notification settings - Fork 9.3k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
error when try install #2023
Comments
You use the root mysql-user without password? Is this correct? |
No in dev machine i use pass for user root and socket for connect |
@chrom what did you do to reproduce this error? |
i just install magento |
yes: ./magento setup:install --base-url=http://magento2.local --db-host=/var/run/mysql/mysql.sock --db-name=magento2 --db-user=root --db-password=root --admin-firstname=admin --admin-lastname=admin --admin-email=[email protected] --admin-user=admin --admin-password=admin123 --language=en_US --currency=USD --timezone=America/Chicago --use-sample-data --use-rewrites=1 SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)#0 /home/ratio/public_html/magento2/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:dbname=ma...', 'root', '', Array) |
Hi, please use --db-host=localhost |
./magento setup:install --base-url=http://magento2.local --db-host=localhost --db-name=magento2 --db-user=root --db-password=root --admin-firstname=admin --admin-lastname=andrey --admin-email=[email protected] --admin-user=admin --admin-password=admin123 --language=en_US --currency=USD --timezone=America/Chicago --use-sample-data --use-rewrites=1 SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)#0 /home/ratio/public_html/magento2/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)#0 /home/ratio/public_html/magento2/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:dbname=ma...', 'root', '', Array) |
if you need extended data, just tell me |
strange in documents written: |
@daim2k5 We're curious why you say mysqdl.sock is "wrong". Is it based on your experience and knowledge or MySQL? Would you mind elaborating? |
@xcomSteveJohnson what i learn is when you say connect to "localhost" php try to connect via socket (default one) and when you type "127.0.0.1" php use TCP |
See http://php.net/manual/en/function.mysql-connect.php first note |
Thanks, updated the documentation: http://devdocs.magento.com/guides/v2.0/install-gde/install/cli/install-cli-install.html (look for db-host) |
MAGETWO-87333: Broken Mainline Test Magento\Paypal\Controller\ExpressTest::testReturnAction
SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)
#0 public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(332): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(861): Magento\Framework\DB\Adapter\Pdo\Mysql->_connect()
#3 public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(931): Zend_Db_Adapter_Abstract->quote('default', NULL)
#4 public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(1351): Zend_Db_Adapter_Abstract->quoteInto('{{fieldName}} =...', 'default', NULL, NULL)
#5 public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(2806): Magento\Framework\DB\Adapter\Pdo\Mysql->quoteInto('{{fieldName}} =...', 'default')
#6 public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(2790): Magento\Framework\DB\Adapter\Pdo\Mysql->_prepareQuotedSqlCondition('{{fieldName}} =...', 'default', '
scope
')#7 public/lib/internal/Magento/Framework/Data/Collection/AbstractDb.php(470): Magento\Framework\DB\Adapter\Pdo\Mysql->prepareSqlCondition('
scope
', 'default')#8 public/lib/internal/Magento/Framework/Data/Collection/AbstractDb.php(401): Magento\Framework\Data\Collection\AbstractDb->_getConditionSql('
scope
', 'default')#9 public/lib/internal/Magento/Framework/Data/Collection/AbstractDb.php(383): Magento\Framework\Data\Collection\AbstractDb->_translateCondition('scope', 'default')
#10 public/app/code/Magento/Store/Model/Resource/Config/Collection/Scoped.php(59): Magento\Framework\Data\Collection\AbstractDb->addFieldToFilter('scope', 'default')
#11 public/lib/internal/Magento/Framework/Model/Resource/Db/Collection/AbstractCollection.php(124): Magento\Store\Model\Resource\Config\Collection\Scoped->_initSelect()
#12 public/app/code/Magento/Store/Model/Resource/Config/Collection/Scoped.php(48): Magento\Framework\Model\Resource\Db\Collection\AbstractCollection->__construct(Object(Magento\Framework\Data\Collection\EntityFactory), Object(Magento\Framework\Logger\Monolog), Object(Magento\Framework\Data\Collection\Db\FetchStrategy\Query), Object(Magento\Framework\Event\Manager\Proxy), NULL, Object(Magento\Config\Model\Resource\Config\Data))
#13 public/lib/internal/Magento/Framework/ObjectManager/Factory/AbstractFactory.php(111): Magento\Store\Model\Resource\Config\Collection\Scoped->__construct(Object(Magento\Framework\Data\Collection\EntityFactory), Object(Magento\Framework\Logger\Monolog), Object(Magento\Framework\Data\Collection\Db\FetchStrategy\Query), Object(Magento\Framework\Event\Manager\Proxy), Object(Magento\Config\Model\Resource\Config\Data), 'default', NULL, NULL)
#14 public/lib/internal/Magento/Framework/ObjectManager/Factory/Dynamic/Developer.php(89): Magento\Framework\ObjectManager\Factory\AbstractFactory->createObject('Magento\Store\M...', Array)
#15 public/lib/internal/Magento/Framework/ObjectManager/ObjectManager.php(57): Magento\Framework\ObjectManager\Factory\Dynamic\Developer->create('Magento\Store\M...', Array)
#16 public/var/generation/Magento/Store/Model/Resource/Config/Collection/ScopedFactory.php(43): Magento\Framework\ObjectManager\ObjectManager->create('\Magento\Store...', Array)
#17 public/app/code/Magento/Store/Model/Config/Reader/DefaultReader.php(63): Magento\Store\Model\Resource\Config\Collection\ScopedFactory->create(Array)
#18 public/lib/internal/Magento/Framework/App/Config/ScopePool.php(84): Magento\Store\Model\Config\Reader\DefaultReader->read()
#19 public/lib/internal/Magento/Framework/App/Config.php(45): Magento\Framework\App\Config\ScopePool->getScope('default', NULL)
#20 public/app/code/Magento/PageCache/Model/Config.php(94): Magento\Framework\App\Config->getValue('system/full_pag...')
#21 public/app/code/Magento/PageCache/Model/App/FrontController/BuiltinPlugin.php(67): Magento\PageCache\Model\Config->getType()
#22 [internal function]: Magento\PageCache\Model\App\FrontController\BuiltinPlugin->aroundDispatch(Object(Magento\Framework\App\FrontController\Interceptor), Object(Closure), Object(Magento\Framework\App\Request\Http))
#23 public/lib/internal/Magento/Framework/Interception/Interceptor.php(141): call_user_func_array(Array, Array)
#24 public/var/generation/Magento/Framework/App/FrontController/Interceptor.php(26): Magento\Framework\App\FrontController\Interceptor->___callPlugins('dispatch', Array, Array)
#25 public/lib/internal/Magento/Framework/App/Http.php(115): Magento\Framework\App\FrontController\Interceptor->dispatch(Object(Magento\Framework\App\Request\Http))
#26 public/lib/internal/Magento/Framework/App/Bootstrap.php(257): Magento\Framework\App\Http->launch()
#27 public/index.php(39): Magento\Framework\App\Bootstrap->run(Object(Magento\Framework\App\Http))
#28 {main}
The text was updated successfully, but these errors were encountered: