Hello,
I've made some minor progress in that I've resolved the SSL issue by installing an older version of WorkBench (matches the version on the source server that I'm trying to migrate from)
However the Migration Task is still unable to connect to the source server :(
I'm puzzled by this.
As I know the credentials that I'm using are correct. I've used WorkBench on the source server to confirm
I've used Telnet to connect to port 3306 from the destination computer to confirm that port 3306 is open and accessible.
When I try to connect via the Migration Task
The dialog box shows
Service:
Mysql@192.168.188.233:3306 (the IP address and port are correct)
User: root
I enter the password (which I know is correct)
I see the following in the log
- Connecting to source...
Connecting to
Mysql@192.168.188.233:3306...
Connecting to
Mysql@192.168.188.233:3306...
Connecting to
Mysql@192.168.188.233:3306...
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 6.3\workbench\wizard_progress_page_widget.py", line 66, in run
self.func()
File "C:\Program Files\MySQL\MySQL Workbench 6.3\modules\migration_source_selection.py", line 444, in task_connect
raise e
DBLoginError: Access denied for user 'root'@'172.16.2.1' (using password: YES)
ERROR: Error during Connect to source DBMS: Access denied for user 'root'@'172.16.2.1' (using password: YES)
ERROR: Exception in task 'Connect to source DBMS': DBLoginError("Access denied for user 'root'@'172.16.2.1' (using password: YES)",)
I am attempting this connection over a VPN
But I don't know where this is coming from: 'root'@'172.16.2.1'
172.16.2.1 is not my IP address
172.16.2.1 is the IP address of the last hop before the Source server