Create a User for Sync - Non-RDS

Having updated MySQL Server parameters, you will now need to create a MySQL user on it. Log into the server from a mysql client (e.g., MySQL Workbench) with the master account. Then create a user to be used only by FlyData Sync. You can do this in MySQL like so:

mysql> CREATE USER 'sync'@'%' IDENTIFIED BY 'your_password';  mysql> GRANT REPLICATION SLAVE, SELECT, RELOAD, REPLICATION CLIENT, LOCK TABLES, SUPER ON *.* TO 'sync'@'%';   mysql> FLUSH PRIVILEGES;

For your_password, enter the password you want to use for this new user.

SUPER privilege is necessary only if your MySQL Server version is 5.1.63 or below.