MySQL: Setting Up Target User Privileges

To make import into MySQL Database you can utilize the existing user or create a new one. To create a new user you can execute the statement below:

create user tester identified by 'Pwd'

As soon as the user is created, you will need to assign appropriate privileges to that user, to be able to load the definitions and data into the target MySQL database.
Here are the sql statements that should be executed to assign required privileges:

grant create on itest.* to tester;
grant insert on itest.* to tester;
grant delete on itest.* to tester;
grant drop on itest.* to tester;
grant alter on itest.* to tester;
grant create view on itest.* to tester;
grant create routine on itest.* to tester;
grant alter routine on itest.* to tester;

FLUSH PRIVILEGES;

Or you can just assign all privileges to the created user:

GRANT ALL privileges on itest.* to tester;
FLUSH PRIVILEGES;

Then you can run the import process.

If you have any questions, please feel free to contact our support team: support@ispirer.com