Configure Migration Prerequisites for MySQL

To run migration jobs from a MySQL source database, the database may require some configuration changes. If Relational Migrator determines the database needs configuration changes, it automatically generates a SQL script with the required changes. It is recommended to have a Database Administrator (DBA) review the commands in this script and perform their execution on the database server.

For details on supported versions of MySQL, see Supported Databases and Versions.

Steps

To configure your MySQL instance for snapshot jobs:

(Optional) Set up user permissions

The following code creates a new MySQL service account for Relational Migrator to connect to the MySQL instance. Alternatively, you can use an existing MySQL service account to connect to Relational Migrator with the appropriate permissions.

Create a service account:
```
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
```
Grant the required permissions to the service account:
```
GRANT SELECT, RELOAD, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT
ON *.*
TO 'user'@'%';
```
Apply the user privilege changes:
```
FLUSH PRIVILEGES;
```

Learn More

Relational Migrator relies on the open-source Debezium connector to capture row-level changes. For more details, see Debezium MySQL.

Back

MySQL

Oracle