I'm trying to link MYSQL with SonarQube, but even though I've given the user permission, he still throws the same error in this table.
ActiveRecord :: JDBCError: Error on rename of '. \ sonar # sql-9cc_138.frm' to '. \ sonar \ active_rules.frm' (Errcode: 13 - Permission denied): ALTER TABLE
active_rules
DROPnote_data
When reviewing the Query Browser, the following message appears:
InnoDB: table "sonar". "active_rules" is corrupted. Please drop the table and recreation
[Warning] InnoDB: Can not open table sonar / active_rules from the internal data dictionary of InnoDB though the .frm file for the table exists. See link for how can you solve the problem.
The table is visible in the list of the DB but when I try to edit it, it throws an error message "Table 'sonar.active_rules' does not exist (1146).