I am trying to migrate a magento1 shop to magento2 on another server.
install the migration tool and
configure everything correctly.
Here is an example of my
<source> <database host="mymagento1.com" name="magento1db" user="magento1user" password="mypassword"/> </source> <destination> <database host="localhost" name="magentodb2" user="magento2user" password="mypassword"/> </destination>
after executing this command:
php bin/magento migrate:settings --reset vendor/magento/data-migration-tool/etc/opensource-to-opensource/18.104.22.168/config.xml
i get the following error:
[Zend_Db_Adapter_Exception] SQLSTATE[HY000]  Access denied for user 'magento1user'@'localhost' (using password: YES)
It seems the migration tool is trying to connect to the Magento2 database with the magento1 user. I also tried with the magento2 server IP instead of
localhost but I get the same error. I triple checked the DB credentials, everything is correct...
I found mutiple posts with the same issue but no solution.