Can't repair MariaDB table EVENTS

@home

• July 28, 2017 05:36

I have upgraded Mysql to MariaDB a while back but now every time I restart the SQL server I get the error : [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. I Looked up this error and found Event schedule issue But when I try to repair the table information_schema/EVENTS I get a error : SQL query REPAIR TABLE EVENTS MySQL said: #1044 - Access denied for user 'root'@'localhost' to database 'information_schema' Any ideas how to fix this? Cpanel 64.0 build 36 Cloudlinux 7.3 10.0.31-MariaDB-cll-lve

• 

  Jcats

  • July 28, 2017 11:52

  Try running this first:
  mysql mysql -e "FLUSH TABLES;"
  

  0
• 

  @home

  • July 28, 2017 13:18

  I found the solution, after the upgrade to MariaDB 10 the command mysql_upgrade did not run. So after I made a full backup of the mysql database I run mysql_upgrade --force and this solved the problem. See for more information. MySQL to MariaDB migration: handling privilege table differences when using mysqldump | MariaDB

  0
• 

  cPanelMichael

  • July 28, 2017 14:15

  Hello, I'm happy to see you were able to solve the issue. Thank you for updating us with the outcome.

  0

Please sign in to leave a comment.