Incorrect definition of table mysql.event
Hello... I have installed MariaDB 10.3.13 in Centos 7. All worked well, but when I execute the following command: "service mariadb status", several errors are shown regarding incorrect definition of table mysql.event and some InnoDB problems. Full command output is this:
root@vps []# service mariadb status Redirecting to /bin/systemctl status mariadb.service ● mariadb.service - MariaDB 10.3.13 database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled) Drop-In: /etc/systemd/system/mariadb.service.d └─migrated-from-my.cnf-settings.conf Active: active (running) since Sun 2019-02-24 22:34:04 -03; 1 day 12h ago Docs: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ Main PID: 12247 (mysqld) Status: "Taking your SQL requests now..." CGroup: /system.slice/mariadb.service └─12247 /usr/sbin/mysqld
Feb 24 22:46:39 vps.desytec.com mysqld[12247]: 2019-02-24 22:46:39 32 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name tabl...ql_upgrade Feb 24 22:46:39 vps.desytec.com mysqld[12247]: 2019-02-24 22:46:39 32 [ERROR] InnoDB: Column last_update in table `mysql`.`innodb_table_stats` is INT UNSIGNED NOT...mismatch). Feb 24 22:46:39 vps.desytec.com mysqld[12247]: 2019-02-24 22:46:39 32 [ERROR] InnoDB: Fetch of persistent statistics requested for table `horde`.`horde_dav_schema...s instead. Feb 24 22:46:40 vps.desytec.com mysqld[12247]: 2019-02-24 22:46:40 37 [ERROR] Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100...this error Feb 24 22:46:40 vps.desytec.com mysqld[12247]: 2019-02-24 22:46:40 37 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14...EATE','POS Feb 24 22:46:41 vps.desytec.com mysqld[12247]: 2019-02-24 22:46:41 45 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14...EATE','POS Feb 24 22:49:43 vps.desytec.com mysqld[12247]: 2019-02-24 22:49:43 47 [Warning] Access denied for user 'admin'@'localhost' (using password: YES) Feb 24 22:49:43 vps.desytec.com mysqld[12247]: 2019-02-24 22:49:43 48 [Warning] Access denied for user 'admin'@'localhost' (using password: YES) Feb 24 22:49:57 vps.desytec.com mysqld[12247]: 2019-02-24 22:49:57 55 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name tabl...ql_upgrade Feb 24 22:49:57 vps.desytec.com mysqld[12247]: 2019-02-24 22:49:57 55 [ERROR] InnoDB: Column last_update in table `mysql`.`innodb_table_stats` is INT UNSIGNED NOT...mismatch). Hint: Some lines were ellipsized, use -l to show in full. root@vps []#
Can you help me to solve those problems?
Regards Jaime