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".
  • meine localhost.err spuckt das aus aber weiß nicht as ich damit anfangen soll


    221129 15:04:07 mysqld_safe Logging to '/var/db/mysql/localhost.err'.

    221129 15:04:07 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql

    2022-11-29 15:04:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

    2022-11-29 15:04:08 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.42) starting as process 1291 ...

    2022-11-29 15:04:08 1291 [Note] Plugin 'FEDERATED' is disabled.

    2022-11-29 15:04:08 1291 [Note] InnoDB: Using atomics to ref count buffer pool pages

    2022-11-29 15:04:08 1291 [Note] InnoDB: The InnoDB memory heap is disabled

    2022-11-29 15:04:08 1291 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

    2022-11-29 15:04:08 1291 [Note] InnoDB: Memory barrier is not used

    2022-11-29 15:04:08 1291 [Note] InnoDB: Compressed tables use zlib 1.2.11

    2022-11-29 15:04:08 1291 [Note] InnoDB: Not using CPU crc32 instructions

    2022-11-29 15:04:08 1291 [Note] InnoDB: Initializing buffer pool, size = 128.0M

    2022-11-29 15:04:08 1291 [Note] InnoDB: Completed initialization of buffer pool

    2022-11-29 15:04:08 1291 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!

    2022-11-29 15:04:08 1291 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB

    2022-11-29 15:04:08 1291 [Note] InnoDB: Database physically writes the file full: wait...

    2022-11-29 15:04:08 1291 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB

    2022-11-29 15:04:08 1291 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB

    2022-11-29 15:04:08 1291 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0

    2022-11-29 15:04:08 1291 [Warning] InnoDB: New log files created, LSN=45781

    2022-11-29 15:04:08 1291 [Note] InnoDB: Doublewrite buffer not found: creating new

    2022-11-29 15:04:08 1291 [Note] InnoDB: Doublewrite buffer created

    2022-11-29 15:04:08 1291 [Note] InnoDB: 128 rollback segment(s) are active.

    2022-11-29 15:04:08 1291 [Warning] InnoDB: Creating foreign key constraint system tables.

    2022-11-29 15:04:08 1291 [Note] InnoDB: Foreign key constraint system tables created

    2022-11-29 15:04:08 1291 [Note] InnoDB: Creating tablespace and datafile system tables.

    2022-11-29 15:04:08 1291 [Note] InnoDB: Tablespace and datafile system tables created.

    2022-11-29 15:04:08 1291 [Note] InnoDB: Waiting for purge to start

    2022-11-29 15:04:08 1291 [Note] InnoDB: 5.6.42 started; log sequence number 0

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

    2022-11-29 15:04:08 1291 [Warning] World-writable config file './auto.cnf' has been removed.


    2022-11-29 15:04:08 1291 [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: 134ed9a6-6ff7-11ed-924b-080027daefd9.

    2022-11-29 15:04:08 1291 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.

    2022-11-29 15:04:08 1291 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.

    2022-11-29 15:04:08 1291 [Note] Server hostname (bind-address): '*'; port: 3306

    2022-11-29 15:04:08 1291 [Note] IPv6 is available.

    2022-11-29 15:04:08 1291 [Note] - '::' resolves to '::';

    2022-11-29 15:04:08 1291 [Note] Server socket created on IP: '::'.

    2022-11-29 15:04:08 1291 [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-11-29 15:04:09 1291 [ERROR] Event Scheduler: Failed to open table mysql.event

    2022-11-29 15:04:09 1291 [ERROR] Event Scheduler: Error while loading from disk.

    2022-11-29 15:04:09 1291 [Note] Event Scheduler: Purging the queue. 0 events

    2022-11-29 15:04:09 1291 [ERROR] Aborting


    2022-11-29 15:04:09 1291 [Note] Binlog end

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'partition'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_SYS_TABLES'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_FT_CONFIG'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_FT_DELETED'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_METRICS'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_CMPMEM'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_CMP_RESET'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_CMP'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_LOCKS'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'INNODB_TRX'

    2022-11-29 15:04:09 1291 [Note] Shutting down plugin 'InnoDB'

    2022-11-29 15:04:09 1291 [Note] InnoDB: FTS optimize thread exiting.

    2022-11-29 15:04:09 1291 [Note] InnoDB: Starting shutdown...

    2022-11-29 15:04:10 1291 [Note] InnoDB: Shutdown completed; log sequence number 1600607

    2022-11-29 15:04:10 1291 [Note] Shutting down plugin 'BLACKHOLE'

    2022-11-29 15:04:10 1291 [Note] Shutting down plugin 'ARCHIVE'

    2022-11-29 15:04:10 1291 [Note] Shutting down plugin 'MRG_MYISAM'

    2022-11-29 15:04:10 1291 [Note] Shutting down plugin 'MyISAM'

    2022-11-29 15:04:10 1291 [Note] Shutting down plugin 'MEMORY'

    2022-11-29 15:04:10 1291 [Note] Shutting down plugin 'CSV'

    2022-11-29 15:04:10 1291 [Note] Shutting down plugin 'sha256_password'

    2022-11-29 15:04:10 1291 [Note] Shutting down plugin 'mysql_old_password'

    2022-11-29 15:04:10 1291 [Note] Shutting down plugin 'mysql_native_password'

    2022-11-29 15:04:10 1291 [Note] Shutting down plugin 'binlog'

    2022-11-29 15:04:10 1291 [Note] /usr/local/libexec/mysqld: Shutdown complete


    Error in my_thread_global_end(): 1 threads didn't exit

    221129 15:04:15 mysqld_safe mysqld from pid file /var/db/mysql/localhost.pid ended

  • SolitaryVoice1362

    Hat das Thema geschlossen