Re: How to change SSL from Require to Use if available
Posted by: Vaughan Wickham
Date: October 23, 2021 12:11AM

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

Options: ReplyQuote


Subject
Written By
Posted
Re: How to change SSL from Require to Use if available
October 23, 2021 12:11AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.