Below you will find details on how to create a tonic user on both the source and destination databases with the minimum level of permissions needed for Tonic to function.
The following is an example of how to create a new user, called tonic, and grant necessary permissions. For the source database we recommend using a backup or fast follower database instead of connecting directly to your production environment.
--create a user. '%' matches a user coming from any host.CREATE USER 'tonic'@'%' IDENTIFIED BY 'tonic_password';--give the user access to tables in your preferred DBsGRANT SELECT, PROCESS ON preferred_db.* TO tonic;
--create a new user.CREATE USER 'tonic'@'%' IDENTIFIED BY 'tonic_password';--This user must granted access to everything. Amazon RDS handles this differently than vanilla MySQL--On Amazon RDSGRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'tonic'@'%' WITH GRANT OPTION;--On vanilla MySQLGRANT ALL PRIVILEGES ON * . * TO 'tonic'@'%';