I am trying to migrate data from magento 1 to maganto 2. Both sites are on different server. So when I try to migrate by below command :
sudo php /var/www/m2.gocleaning.nl/bin/magento migrate:settings -r /var/www/siteurl/vendor/magento/data-migration-tool/etc/opensource-to-opensource/22.214.171.124/config.xml
FYI : I also can't connect to mysql remotely by using
mysql -u remote -h 126.96.36.199 -p
It is also giving connection timed out error. Tried this solution : Link
One thing I want to confirm should I have to grant privleges on remote database or on local database?
Please help me to sort out this issue ASAP.