Give ALTER TABLE permissions in Sonarqube with MYSQL?

0

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 DROP note_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).

    
asked by Rubén Díaz 18.05.2018 в 00:19
source

0 answers