I am trying to access MySQL through Toad Edge (TE) CLI using the connection XML file generated via CICD Wizard. I am getting access denied error from the remote server.
Further trouble-shooting found that TE CLI is appending the localhost IP to the root user account, instead of using root account for the endpoint server, which is specified in connection XML file / HOST tag below.
- Is this because CICD Wizard not generating connection XML with correct account?
- Is this caused by CLI not recognizing root account on remote server? 50.127 shown below is the ip for localhost, also the TE/CLI host PC.
- What is the correct syntax for remote server account that I should use in the connection XML?
Below are the command output and a snippet of the connection XML.
C:\Program Files\Quest Software\Toad Edge\CLI>java -jar toadedge.jar -snapshot -in “./connection/ETL (BSFAurora).xml” -out “./snapshot/BSFAurora_ETL.json”
2018-06-22 09:04:52,892 INFO : Command: snapshot
2018-06-22 09:04:52,894 INFO : Loading source input
2018-06-22 09:04:53,633 ERROR: java.sql.SQLException: Access denied for user ‘root’@‘192.168.50.127’ (using password: YES)
com.quest.toad.execution.ExecutionException: java.sql.SQLException: Access denied for user ‘root’@‘192.168.50.127’ (using password: YES)