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.

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk