Getting there with a Magento 1 to 2 data migration but when I get here http://devdocs.magento.com/guides/v2.0/migration/migration-migrate-settings.html and run php bin/magento:settings I get and permissions issue. How do I open up these permissions in MySql? I have the user root set up to have schema privileges to the DB.

[Zend_Db_Adapter_Exception] SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using pas sword: NO)

[PDOException] SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using pas sword: NO)

1 Answer 1


You have getting this issue for wrongly configure at config.xml which is located at

[your Magento 2 install dir]/vendor/magento/data-migration-tool/etc/[migration edition]/[ce or version]

Here ,you have put wrong setting between Magento2 and Magento 1

    <database host="[HostLocation]" name="[magento1DB]" user="[DBUSER]" password="[Db_PASSWORD_FOR_magento1DB_USER]"/>
    <database host="[HostLocation]" name="[magento2DB]" user="[DBUSER]" password="[Db_PASSWORD_FOR_magento2DB_USER]"/>
    <crypt_key />

Please check this. Hope it will resolve the issue.

See configuraion setting of migration tool http://devdocs.magento.com/guides/v2.0/migration/migration-tool-configure.html

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.