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.