Before you start

You will first need to create an empty database on your MySQL server with the following command:

CREATE DATABASE <database_name>;
 copy

The <database_name> can be whatever you wish, as long as there are no other databases with the same name on your MySQL server.

You will also need to create a MySQL user which can login from your OPC server. To do this, you need to run the following commands:

CREATE USER '<user>'@'<host>' IDENTIFIED BY '<password>';
GRANT ALL PRIVILEGES ON <database_name>.* TO '<user>'@'<host>';
FLUSH PRIVILEGES;
 copy

This has a number of variables which you will need to change:

• <user> - The username you wish to login as.

• <host> - This is the IP address of your OPC server. If you wish to allow this user to login from any server, you can use % as a wildcard.

• <password> - This is the password you will use to login as this user.

• <database_name> - The name of the database created earlier.

Once you have your database and user created, you can continue with the guide.

Configuring an external database

During the Import Instance stage of your migration, you have the option to select either the Internal Database or to use an External Database.

Select External Database and additional options will display to configure your external MySQL database

• Hostname - This is the address of your external MySQL server, and will either be an IP address or FQDN.

• Port - The default MySQL port is 3306. If you use a custom port, set it here.

• Database Name - The name of your database. (<database_name> from the guide above)

• Username - The user you wish to connect with. (<user> from the guide above)

• Password - The password of the user. (<password> from the guide above)

Once all the information has been entered, click Validate Parameters to test the connection. If everything connects successfully, return to your migration guide.