Hallo,
ich habe gestern meine MySQL auf die neuste Version aktualisiert. Seitdem funktioniert der Server nicht mehr.
Ich kann mich nur mit dem Root-User einloggen, alle anderen Benutzer scheinen nicht zu funktionieren und egal welche SQLs ich ausführe ich bekomme immer folgende Fehlermeldung:
Beim Starten bekomme ich folgenden Output:
Hat jemand evt. das gleiche Problem, bzw. was kann man dagegen tun?
Wie bekomme ich die MySQL wieder ordnungsgemäß zu laufen?
Wie kann ich meine Daten wieder herstellen?
LG Raffael
ich habe gestern meine MySQL auf die neuste Version aktualisiert. Seitdem funktioniert der Server nicht mehr.
Ich kann mich nur mit dem Root-User einloggen, alle anderen Benutzer scheinen nicht zu funktionieren und egal welche SQLs ich ausführe ich bekomme immer folgende Fehlermeldung:
Code:
ERROR 1449 (HY000): The user specified as a definer ('mysql.infoschema'@'localhost') does not exist
Code:
2018-04-21T17:18:29.396492Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release. 2018-04-21T17:18:29.396670Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.11) starting as process 1 mbind: Operation not permitted mbind: Operation not permitted 2018-04-21T17:18:30.100867Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2018-04-21T17:18:30.104219Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2018-04-21T17:18:30.106645Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist 2018-04-21T17:18:30.106715Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition. 2018-04-21T17:18:30.117970Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.user]. 2018-04-21T17:18:30.118021Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.db]. 2018-04-21T17:18:30.118031Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.tables_priv]. 2018-04-21T17:18:30.118039Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.columns_priv]. 2018-04-21T17:18:30.118050Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.procs_priv]. 2018-04-21T17:18:30.118058Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.proxies_priv]. 2018-04-21T17:18:30.119178Z 0 [ERROR] [MY-013143] [Server] Column count of mysql.user is wrong. Expected 49, found 45. The table is probably corrupted 2018-04-21T17:18:30.119250Z 0 [Warning] [MY-010966] [Server] ACL table mysql.role_edges missing. Some operations may fail. 2018-04-21T17:18:30.119264Z 0 [Warning] [MY-010966] [Server] ACL table mysql.default_roles missing. Some operations may fail. 2018-04-21T17:18:30.119273Z 0 [Warning] [MY-010966] [Server] ACL table mysql.global_grants missing. Some operations may fail. 2018-04-21T17:18:30.119281Z 0 [Warning] [MY-010966] [Server] ACL table mysql.password_history missing. Some operations may fail. 2018-04-21T17:18:30.120804Z 0 [Warning] [MY-010315] [Server] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. 2018-04-21T17:18:30.120868Z 0 [Warning] [MY-010315] [Server] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-04-21T17:18:30.120887Z 0 [Warning] [MY-010315] [Server] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-04-21T17:18:30.121438Z 0 [Warning] [MY-010323] [Server] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-04-21T17:18:30.121480Z 0 [Warning] [MY-010323] [Server] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-04-21T17:18:30.121893Z 0 [Warning] [MY-010311] [Server] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. 2018-04-21T17:18:30.122057Z 0 [ERROR] [MY-010965] [Server] Missing system table mysql.global_grants; please run mysql_upgrade to create it. 2018-04-21T17:18:30.132813Z 0 [Warning] [MY-010330] [Server] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-04-21T17:18:30.132857Z 0 [Warning] [MY-010330] [Server] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-04-21T17:18:30.135415Z 0 [Warning] [MY-010727] [Server] System table 'func' is expected to be transactional. 2018-04-21T17:18:30.139794Z 0 [Warning] [MY-010405] [Repl] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened. 2018-04-21T17:18:30.139850Z 0 [ERROR] [MY-010422] [Repl] Error in checking mysql.slave_master_info repository info type of TABLE. 2018-04-21T17:18:30.139867Z 0 [ERROR] [MY-010415] [Repl] Error creating master info: Error checking repositories. 2018-04-21T17:18:30.139875Z 0 [ERROR] [MY-010426] [Repl] Slave: Failed to initialize the master info structure for channel ''; its record may still be present in 'mysql.slave_master_info' table, consider deleting it. 2018-04-21T17:18:30.139884Z 0 [ERROR] [MY-010529] [Repl] Failed to create or recover replication info repositories. 2018-04-21T17:18:30.141965Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.11' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL. mbind: Operation not permitted mbind: Operation not permitted 2018-04-21T17:24:31.465206Z 157 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.user]. 2018-04-21T17:24:31.465245Z 157 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.db]. 2018-04-21T17:24:31.465257Z 157 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.tables_priv]. 2018-04-21T17:24:31.465264Z 157 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.columns_priv]. 2018-04-21T17:24:31.465271Z 157 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.procs_priv]. 2018-04-21T17:24:31.465278Z 157 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.proxies_priv]. 2018-04-21T17:24:31.466888Z 157 [ERROR] [MY-013143] [Server] Spaltenanzahl von mysql.user falsch. 49 erwartet, aber 45 gefunden. Tabelle ist wahrscheinlich beschädigt 2018-04-21T17:24:31.466938Z 157 [Warning] [MY-010966] [Server] ACL table mysql.role_edges missing. Some operations may fail. 2018-04-21T17:24:31.466949Z 157 [Warning] [MY-010966] [Server] ACL table mysql.default_roles missing. Some operations may fail. 2018-04-21T17:24:31.466956Z 157 [Warning] [MY-010966] [Server] ACL table mysql.global_grants missing. Some operations may fail. 2018-04-21T17:24:31.466966Z 157 [Warning] [MY-010966] [Server] ACL table mysql.password_history missing. Some operations may fail. 2018-04-21T17:24:31.467822Z 157 [Warning] [MY-010315] [Server] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. 2018-04-21T17:24:31.468528Z 157 [Warning] [MY-010315] [Server] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-04-21T17:24:31.468544Z 157 [Warning] [MY-010315] [Server] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-04-21T17:24:31.468576Z 157 [Warning] [MY-010323] [Server] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2018-04-21T17:24:31.468586Z 157 [Warning] [MY-010323] [Server] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2018-04-21T17:24:31.468602Z 157 [Warning] [MY-010311] [Server] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. 2018-04-21T17:24:31.468636Z 157 [ERROR] [MY-010965] [Server] Missing system table mysql.global_grants; please run mysql_upgrade to create it.
Wie bekomme ich die MySQL wieder ordnungsgemäß zu laufen?
Wie kann ich meine Daten wieder herstellen?
LG Raffael
Kommentar