Accessing MySQL remotely from a new SQL window
To access MySQL remotely from a new SQL window from Connect CDC Director you need to configure the DBMS login ID to have remote connection authority from the system on which the Director is running. See MySQL documentation on how to make this configuration change.
TIMESTAMP values between 02:00 and 02:59 during the Spring clock change are not valid in MySQL
The Connect CDC Applier processes MySQL TIMESTAMP column values so that they are updated appropriately in the MySQL database. Since this problem is occurring because MySQL is presuming that TIMESTAMP values are in the local time zone of the client, the Applier determines what the time zone offset is, and converts it to GMT to determine if that value is valid.
Since MySQL stores TIMESTAMP column values in GMT format in the database, unexpected conversions may occur if the TIMESTAMP value arriving from the source is within the hour when the Spring Daylight Savings time switch occurs. When updated into MySQL and then displayed after the value is replicated, it is likely that the TIMESTAMP value will be offset by 1 hour. This is how MySQL processes TIMESTAMP values and is not a defect in Connect CDC.