Mysql Startet nicht

In diesem Bereich sind Themen vom Themenersteller als erledigt zu markieren, wenn die Frage beantwortet oder das Problem gelöst wurde. Das Thema wird daraufhin automatisch geschlossen.
Klicke hierzu auf "Thema bearbeiten > Als erledigt markieren".
  • Guten Abend,


    hat wer eine warum die Mysql nicht startet bin grade irgendwie plan los...


    hier mal die error log


    220818 22:25:47 mysqld_safe Logging to '/var/db/mysql/localhost.err'.

    220818 22:25:47 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql

    2022-08-18 22:25:47 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

    2022-08-18 22:25:47 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1834 ...

    2022-08-18 22:25:47 1834 [Note] Plugin 'FEDERATED' is disabled.

    /usr/local/libexec/mysqld: Unknown storage engine 'InnoDB'

    2022-08-18 22:25:47 1834 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

    2022-08-18 22:25:47 1834 [Note] InnoDB: Using atomics to ref count buffer pool pages

    2022-08-18 22:25:47 1834 [Note] InnoDB: The InnoDB memory heap is disabled

    2022-08-18 22:25:47 1834 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

    2022-08-18 22:25:47 1834 [Note] InnoDB: Memory barrier is not used

    2022-08-18 22:25:47 1834 [Note] InnoDB: Compressed tables use zlib 1.2.11

    2022-08-18 22:25:47 1834 [Note] InnoDB: Using CPU crc32 instructions

    2022-08-18 22:25:47 1834 [Note] InnoDB: Initializing buffer pool, size = 128.0M

    2022-08-18 22:25:47 1834 [Note] InnoDB: Completed initialization of buffer pool

    2022-08-18 22:25:47 1834 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!

    2022-08-18 22:25:47 1834 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB

    2022-08-18 22:25:47 1834 [Note] InnoDB: Database physically writes the file full: wait...

    2022-08-18 22:25:48 1834 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB

    2022-08-18 22:25:48 1834 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB

    2022-08-18 22:25:48 1834 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0

    2022-08-18 22:25:48 1834 [Warning] InnoDB: New log files created, LSN=45781

    2022-08-18 22:25:48 1834 [Note] InnoDB: Doublewrite buffer not found: creating new

    2022-08-18 22:25:48 1834 [Note] InnoDB: Doublewrite buffer created

    2022-08-18 22:25:48 1834 [Note] InnoDB: 128 rollback segment(s) are active.

    2022-08-18 22:25:48 1834 [Warning] InnoDB: Creating foreign key constraint system tables.

    2022-08-18 22:25:48 1834 [Note] InnoDB: Foreign key constraint system tables created

    2022-08-18 22:25:48 1834 [Note] InnoDB: Creating tablespace and datafile system tables.

    2022-08-18 22:25:48 1834 [Note] InnoDB: Tablespace and datafile system tables created.

    2022-08-18 22:25:48 1834 [Note] InnoDB: Waiting for purge to start

    2022-08-18 22:25:48 1834 [Note] InnoDB: 5.6.51 started; log sequence number 0

    /usr/local/libexec/mysqld: Error on delete of './auto.cnf' (Errcode: 2 - No such file or directory)

    2022-08-18 22:25:48 1834 [Warning] World-writable config file './auto.cnf' has been removed.


    2022-08-18 22:25:48 1834 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: f24e29b2-1f33-11ed-83a9-005056002308.

    2022-08-18 22:25:48 1834 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.

    2022-08-18 22:25:48 1834 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.

    2022-08-18 22:25:48 1834 [Note] Server hostname (bind-address): '*'; port: 3306

    2022-08-18 22:25:48 1834 [Note] IPv6 is available.

    2022-08-18 22:25:48 1834 [Note] - '::' resolves to '::';

    2022-08-18 22:25:48 1834 [Note] Server socket created on IP: '::'.

    2022-08-18 22:25:48 1834 [Warning] Insecure configuration for --pid-file: Location '/var/db/mysql' in the path is accessible to all OS users. Consider choosing a different directory.

    2022-08-18 22:25:48 1834 [Warning] 'user' entry 'mysql.session@localhost' has both a password and an authentication plugin specified. The password will be ignored.

    2022-08-18 22:25:48 1834 [Warning] 'user' entry 'mysql.sys@localhost' has both a password and an authentication plugin specified. The password will be ignored.

    2022-08-18 22:25:48 1834 [Warning] 'user' entry '[email protected]' has both a password and an authentication plugin specified. The password will be ignored.

    2022-08-18 22:25:48 1834 [Warning] 'user' entry 'root@%' has both a password and an authentication plugin specified. The password will be ignored.

    2022-08-18 22:25:48 1834 [Warning] 'user' entry 'root@localhost' has both a password and an authentication plugin specified. The password will be ignored.

    2022-08-18 22:25:48 1834 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format.

    220818 22:25:48 mysqld_safe mysqld from pid file /var/db/mysql/localhost.pid ended

    220818 22:27:44 mysqld_safe Logging to '/var/db/mysql/localhost.err'.

    220818 22:27:44 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql

    2022-08-18 22:27:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

    2022-08-18 22:27:45 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1973 ...

    2022-08-18 22:27:45 1973 [Note] Plugin 'FEDERATED' is disabled.

    /usr/local/libexec/mysqld: Unknown storage engine 'InnoDB'

    2022-08-18 22:27:45 1973 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

    2022-08-18 22:27:45 1973 [Note] InnoDB: Using atomics to ref count buffer pool pages

    2022-08-18 22:27:45 1973 [Note] InnoDB: The InnoDB memory heap is disabled

    2022-08-18 22:27:45 1973 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

    2022-08-18 22:27:45 1973 [Note] InnoDB: Memory barrier is not used

    2022-08-18 22:27:45 1973 [Note] InnoDB: Compressed tables use zlib 1.2.11

    2022-08-18 22:27:45 1973 [Note] InnoDB: Using CPU crc32 instructions

    2022-08-18 22:27:45 1973 [Note] InnoDB: Initializing buffer pool, size = 128.0M

    2022-08-18 22:27:45 1973 [Note] InnoDB: Completed initialization of buffer pool

    2022-08-18 22:27:45 1973 [Note] InnoDB: Highest supported file format is Barracuda.

    2022-08-18 22:27:45 1973 [Note] InnoDB: Log scan progressed past the checkpoint lsn 49463

    2022-08-18 22:27:45 1973 [Note] InnoDB: Database was not shutdown normally!

    2022-08-18 22:27:45 1973 [Note] InnoDB: Starting crash recovery.

    2022-08-18 22:27:45 1973 [Note] InnoDB: Reading tablespace information from the .ibd files...

    2022-08-18 22:27:45 1973 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_worker_info uses space ID: 17 at filepath: ./mysql/slave_worker_info.ibd. Cannot open tablespace account/blocked_hwids which uses space ID: 17 at filepath: ./account/blocked_hwids.ibd

    2022-08-18 22:27:45 801784000 InnoDB: Operating system error number 2 in a file operation.

    InnoDB: The error means the system cannot find the path specified.

    InnoDB: If you are installing InnoDB, remember that you must create

    InnoDB: directories yourself, InnoDB does not create them.

    InnoDB: Error: could not open single-table tablespace file ./account/blocked_hwids.ibd

    InnoDB: We do not continue the crash recovery, because the table may become

    InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.

    InnoDB: To fix the problem and start mysqld:

    InnoDB: 1) If there is a permission problem in the file and mysqld cannot

    InnoDB: open the file, you should modify the permissions.

    InnoDB: 2) If the table is not needed, or you can restore it from a backup,

    InnoDB: then you can remove the .ibd file, and InnoDB will do a normal

    InnoDB: crash recovery and ignore that table.

    InnoDB: 3) If the file system or the disk is broken, and you cannot remove

    InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf

    InnoDB: and force InnoDB to continue crash recovery here.

    220818 22:27:45 mysqld_safe mysqld from pid file /var/db/mysql/localhost.pid ended



    ka was ich da falsch mache >.<


    lg AceWavee

    Bitte melden Sie sich an, um dieses Bild zu sehen.

  • Bot

    Hat das Thema geschlossen
  • Dieses Thema enthält 6 weitere Beiträge, die nur für registrierte Benutzer sichtbar sind, bitte registrieren Sie sich oder melden Sie sich an um diese lesen zu können.