Ispirer Website Ispirer Capabilities: MySQL Migration Free Trial

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: