Hjdcti

I am migrating data from Magento 1.9.3.1 to magneto 2.3.1 and getting Bellow error while I am running a command

php bin/magento migrate:data -r vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.1/config.xml

Error:

`SQLSTATE[HY000] [1045] Access denied for user 'wnvjqhgtcr'@'xxx.xx.xx.xx' (using password: YES)`

if I connect same on the server using command all working fine just issue with migration

Magento 1 database is located at third party database host server, I had set proper host details in config.xml but still getting an error. Also Magento 2 database on the third party database server.

here are my configuration file vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.1/config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!--
/**
 * Copyright © Magento, Inc. All rights reserved.
 * See COPYING.txt for license details.
 */
-->
<config xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xs:noNamespaceSchemaLocation="../../config.xsd">
 <steps mode="settings">
 <step title="Settings Step">
 <integrity>MigrationStepSettingsIntegrity</integrity>
 <data>MigrationStepSettingsData</data>
 </step>
 <step title="Stores Step">
 <integrity>MigrationStepStoresIntegrity</integrity>
 <data>MigrationStepStoresData</data>
 <volume>MigrationStepStoresVolume</volume>
 </step>
 </steps>
 <steps mode="data">
 <step title="Customer Attributes Step">
 <integrity>MigrationStepCustomerIntegrity</integrity>
 <data>MigrationStepCustomerData</data>
 <volume>MigrationStepCustomerVolume</volume>
 </step>
 <step title="OrderGrids Step">
 <integrity>MigrationStepOrderGridsIntegrity</integrity>
 <data>MigrationStepOrderGridsData</data>
 <volume>MigrationStepOrderGridsVolume</volume>
 </step>
 <step title="SalesIncrement Step">
 <integrity>MigrationStepSalesIncrementIntegrity</integrity>
 <data>MigrationStepSalesIncrementData</data>
 <volume>MigrationStepSalesIncrementVolume</volume>
 </step>
 <step title="PostProcessing Step">
 <data>MigrationStepPostProcessingData</data>
 </step>
 </steps>
 <steps mode="delta">
 <step title="Customer Attributes Step">
 <delta>MigrationStepCustomerDelta</delta>
 <volume>MigrationStepCustomerVolume</volume>
 </step>
 <step title="OrderGrids Step">
 <delta>MigrationStepOrderGridsDelta</delta>
 <volume>MigrationStepOrderGridsVolume</volume>
 </step>
 <step title="SalesIncrement Step">
 <delta>MigrationStepSalesIncrementDelta</delta>
 <volume>MigrationStepSalesIncrementVolume</volume>
 </step>
 </steps>
 <source>
 <database host="xxx.xx.xx.xxx" name="magento" user="magento" password="magento" />
 </source>
 <destination>
 <database host="xxx.xx.xx.xxx" name="magento" user="magento" password="magento" />
 </destination>
 <options>
 <map_file>etc/opensource-to-opensource/1.9.3.1/map.xml.dist</map_file>
 <eav_map_file>etc/opensource-to-opensource/map-eav.xml.dist</eav_map_file>
 <eav_document_groups_file>etc/opensource-to-opensource/eav-document-groups.xml.dist</eav_document_groups_file>
 <eav_attribute_groups_file>etc/opensource-to-opensource/eav-attribute-groups.xml.dist</eav_attribute_groups_file>
 <log_map_file>etc/opensource-to-opensource/map-log.xml.dist</log_map_file>
 <log_document_groups_file>etc/opensource-to-opensource/log-document-groups.xml.dist</log_document_groups_file>
 <settings_map_file>etc/opensource-to-opensource/settings.xml.dist</settings_map_file>
 <customer_map_file>etc/opensource-to-opensource/map-customer.xml.dist</customer_map_file>
 <customer_document_groups_file>etc/opensource-to-opensource/customer-document-groups.xml.dist</customer_document_groups_file>
 <customer_attribute_groups_file>etc/opensource-to-opensource/customer-attribute-groups.xml.dist</customer_attribute_groups_file>
 <delta_document_groups_file>etc/opensource-to-opensource/deltalog.xml.dist</delta_document_groups_file>
 <order_grids_document_groups_file>etc/opensource-to-opensource/order-grids-document-groups.xml.dist</order_grids_document_groups_file>
 <map_document_groups>etc/opensource-to-opensource/map-document-groups.xml.dist</map_document_groups>
 <class_map>etc/opensource-to-opensource/class-map.xml.dist</class_map>
 <tier_price_map_file>etc/opensource-to-opensource/1.9.3.1/map-tier-price.xml.dist</tier_price_map_file>
 <stores_map_file>etc/opensource-to-opensource/map-stores.xml.dist</stores_map_file>
 <!--
 In case bulk_size=0 it will be auto-detected for every document.
 -->
 <bulk_size>0</bulk_size>
 <!--
 Set direct_document_copy = 1 for better performance.
 NOTE: 'source' and 'destination' databases MUST be placed on the same MySQL instance
 and 'destination' user MUST be granted with 'SELECT' permissions on 'source' database
 -->
 <direct_document_copy>0</direct_document_copy>
 <source_prefix />
 <dest_prefix />
 <auto_resolve_urlrewrite_duplicates>0</auto_resolve_urlrewrite_duplicates>
 <log_file>migration.log</log_file>
 <progress_bar_format>%percent%% [%bar%] Remaining Time: %remaining%</progress_bar_format>
 <upgrade_customer_password_hash>1</upgrade_customer_password_hash>
 <edition_migrate>opensource-to-opensource</edition_migrate>
 <edition_number>1.9.3.1</edition_number>
 <init_statements_source>SET NAMES utf8;</init_statements_source>
 <init_statements_destination>SET NAMES utf8;</init_statements_destination>
 <crypt_key>YvwdUIiD60FWqPAPh64rFETGTJ5VC6SR</crypt_key>
 </options>
</config>