MySQL: Setting Up Source User Privileges

To be able to connect to a database and to extract DDL of objects in MySQL, you need to create a user and assign select privileges to this user. As a template you can use the queries below:

• create user 'test_perm'@'%' identified by 'root';
• grant select on *.* to 'test_perm'@'%'.

Or you can do it using only one query:

• grant select on *.* to 'test_perm'@'%' identified by 'root'.

If you have any other questions, please contact us: support@ispirer.com