What DB user permissions are required to run the tool?

SonarSource / mysql-migrator

Command line tool to migrate MySQL database of SonarQube 6.7-7.8 to non-MySQL

39 stars 11 forks source link

What DB user permissions are required to run the tool? #38

Closed tony-cerritelli closed 5 years ago

tony-cerritelli commented 5 years ago

Hi SonarSource Devs, I'm attempting to run mysql-migrator-1.0.2.108 and seeing this error: Access denied for user 'sonaruser'@'xxxxxxx' (using password: YES)

It seems that sonaruser doesn't have enough permission on the MySQL DB. What are the required permission on both the source and the target DBs?

Thanks and regards, Tony

tony-cerritelli commented 5 years ago

The issue was mismatched connection details for the sonaruser on the mysql server.