방금 설치된 MariaDB 10.3 데이터베이스의 상태를 확인할 때 오류 발생

방금 설치된 MariaDB 10.3 데이터베이스의 상태를 확인할 때 오류 발생

방금 Centos 7에 MariaDB 10.3 데이터베이스 서버를 설치했습니다.

모든 것이 잘 진행되었지만 "systemctl status mariadb" 명령어를 실행할 경우.출력은 다음과 같습니다.

root@vps [/etc/init.d]# systemctl status mariadb
● 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; 40min 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..._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_st...smatch).
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 `...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. ...is 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 '...TE','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 '...TE','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..._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_st...smatch).
Hint: Some lines were ellipsized, use -l to show in full.

데이터베이스는 올라갔지만 거기서 오류를 해결하고 싶다.예를 들어 테이블에 열이 없거나 admin@localhost 사용자에 대한 액세스와 관련된 문제가 있습니다.

admin 사용자의 문제를 해결하기 위해 해당 사용자를 만들고 모든 권한을 부여했는데도 여전히 오류가 나타납니다.

어떤 도움이라도 주시면 감사하겠습니다.

mysql_upgrade 툴을 실행하면 시스템테이블이 수정되어 현재 설치된 버전에 적합한 구조로 이행됩니다.

https://mariadb.com/kb/en/library/mysql_upgrade/

언급URL : https://stackoverflow.com/questions/54858642/errors-when-checking-status-of-just-installed-mariadb-10-3-database